I have a "simple" query how takes 0.7678 seconds or more to be executed with MariaDB. Here is the query: select `referenceNumber` from `invoice` where `groupId` = 3550 and `referenceNumber` >= 301 order by `referenceNumber` desc limit 1; These columns…
I have a table which is used as a job queue. New rows are continuously being inserted in the table and the fetched rows are updated. There are JOINs in the query and Postgres uses Nested Loop join for it.…
Within my db I have table prediction_fsd with about 5 million entries. The site table contains approx 3 million entries. I need to execute queries that look like SELECT prediction_fsd.id AS prediction_fsd_id, prediction_fsd.site_id AS prediction_fsd_site_id, prediction_fsd.html_hash AS prediction_fsd_html_hash, prediction_fsd.prediction AS…
I have a sample query. I have tried to rewrite it with CTE but some errors occurred. Please check and solve the below query. actual query; select dt.population, dt.name, c.name from ( select distinct countrycode, name from city ) as…
I am having performance issues with a query, I have 21 million records across the table, and 2 of the tables I'm looking in here have 8 million each; individually, they are very quick. But I've done a query that,…
Given a database table events with columns: event_id, correlation_id, username, create_timestamp. It contains more than 1M records. There is a problem I am trying to solve: for each event of a particular user display its latest sibling event. Sibling events…
I have a posts table with a JSON column of an array with IDs. This column's data looks exactly like: [1, 3, 17, 19] These values are not quoted. To check if a user should see a post, I simply…
I have the below query that takes so much time >> table size 64.31GB are there any rewrite possible for this? SELECT MIN(ut.id) AS minUT, MAX(ut.id) AS maxUT FROM user_tasks ut JOIN user_tasks_metadata utm ON utm.user_task_id = ut.id JOIN ue_events_base…
I am trying to learn some postgres skills to help me building my flask application and I really care about performance but I faced some issues. I have the following table (Sessions) in postgres: SessionID Other columns Statics BDzQDeGr *…
We are trying to query millions of rows of data from 1 table (14 columns) in under 2 seconds if possible. This table is composed of more than 10 million records and is growing exponentially as live data is being…