I have a users table with bio field and "n:n" relationship with itself via the followers table so each user U can follow many other users. My user search query is super slow. All queries get the first 20 search…
The below query finds one id by using the below query format but it seems I have indexed all columns, but it took time to execute between 54.3 seconds - 1.2 mins. What can I try next? Query: select op.ord_prod_id…
I have a table with close to a billion records, and need to query it with HAVING. It's very slow (about 15 minutes on decent hardware). How to speed it up? SELECT ((mean - 3.0E-4)/(stddev/sqrt(N))) as t, ttest.strategyid, mean, stddev,…
So I have a table of 4.7 billion records on which I want to perform a group by count expression in Postgres using PGadmin4. Obviously this is gonna take a lot of time and I want to speed up the…
I'm completely new in mysql and struggling to write a store procedure to get a required result set. As you can see below are the tables I have, I'm using node & express api to connect to mysql database. Then…
the below query it scans more rows while the table has an index on it but not using that index for that column. Query; SELECT * FROM st_aepsrequest_log WHERE `snd_transno` IN ( SELECT pwcashout_transno FROM st_aeps_transaction_master a WHERE a.`entry_date` >=…
I have a query. It has an index but I'm not sure why it's taking time for fewer rows. Can anyone please suggest to improving that query performance? SELECT up.id post_id, c.id community_id, SUBSTRING(up.description, 1, 30) post_description, c.name community_name, c.is_index…
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…