Describing the scenario I have this table called event defined in PostgresSQL that, among some not relevant ones, basically has 5 columns: id (integer): primary key of the table date (timestamp): date when the event occurred fk_type (integer): foreign key…
Background I'm getting insanely slow queries when using small LIMIT clause values on a relatively simple query. I've already read and re-read PostgreSQL query very slow with limit 1. (not that I couldn't have missed anything, but it's related, and…
I have a following SQL running in PostgreSQL v13.10: WITH stuckable_statuses AS ( SELECT status_id FROM status_descriptions WHERE (tags @> ARRAY['stuckable']::varchar[]) ) SELECT jobs.* FROM jobs WHERE jobs.status = ANY(select status_id from stuckable_statuses) And it is running really slow while…
I am trying to run a transaction report but it is taking more than 40sec then timeout by the server. Hope I can get some help to get it optimised. select test_txn.abcid, txndate, txndate2 from test_txn inner join test_abc on…
i have a query in postgres which is taking 1 min and a few seconds to execute, found out that it's due to the order by clause. my understanding is that order by clause is one of the last to…
I have a Sql database with +2 million rows and growing fast. There aren't many columns, only code, price, date and stationID. The aim is to get the latest price by code and stationID. The query works well, but takes…
com_cards_charge : com_cards_charge table(DB) com_debt : com_debt table(DB) some of result: Result1 Result2 SELECT * FROM com_cards_charge, com_debt where com_debt.com_debt_cards_charge_id = com_cards_charge.com_cards_charge_id AND debt_Creditor_type in (0, 15) AND com_cards_charge_deleted = '0' GROUP BY com_cards_charge.com_cards_charge_id order by com_cards_charge_id DESC This query…
I have a slow delete query. As suggested here when I add an index I get much better results. Beside this scenario I don't need this index, so what I did is: Added the index. Deleted the rows. Dropped the…
I'm using MySQL and have a table with name Music that has tracks information like title,duration and ... This table also has "total_hit" column that it's value will be updated frequently by each track played(+1) : id title duration ...…
We have an expensive query that needs to extract daily values from a table storing metrics for objects over timeranges. We have isolated the expensive part of the query and extracted the following minimal example. Some details on the tables…