explain Archives

Postgres SELECT query produces exact same explain analyze results but different execution times in the results

By adminPosted on May 30, 2023

Question : I have a SELECT query which when running produces the exact same plan in terms of indexes being […]

By adminPosted on May 30, 2023

Question : I have a query, and when I call EXPLAIN for it, it appears that my db is using […]

By adminPosted on May 27, 2023

Question : Is a scalar subquery that’s independent on parent query (does not refer to the parent table) evaluated only […]

By adminPosted on May 25, 2023

Question : I’m fighting with a specific “generated” query (the SQL is generated from a proprietary system, and I won’t […]

By adminPosted on May 25, 2023

Question : Hello I have the following question: Query 1: SELECT b.id, ( SELECT SUM(cb.invoice_amount) AS sum […]

By adminPosted on May 22, 2023

Question : I have the following setup: create table Test(id integer, itemID integer, title varchar(100) ,PRIMARY KEY (id, itemID)); insert […]

By adminPosted on May 8, 2023

Question : I am running a query in some big tables, and although it runs fine even tough is a […]

By adminPosted on May 5, 2023

Question : MySQL 5.5.49-log More questions on the query in Why does it use temporary? (MySQL) (the query is the […]

By adminPosted on April 21, 2023

Question : There is a big difference in execution time, altough the ammount of table data are pretty much the […]

By adminPosted on March 23, 2023

Question : This Query scans only one document and returns only one document. But this is very slow: 2017-05-22T07:13:24.548+0000 I […]