Skip to content

Instantly share code, notes, and snippets.

@eliank

eliank/postgres-the-unwanted-side-effects-of-limit-on-query-planning-1.sql

Last active May 23, 2016 11:48
Show Gist options
  • Save eliank/2c6ccbb2f05e59102fa978395c852231 to your computer and use it in GitHub Desktop.
Save eliank/2c6ccbb2f05e59102fa978395c852231 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres-the-unwanted-side-effects-of-limit-on-query-planning-1.sql
moneybird_app=> EXPLAIN ANALYZE SELECT "some_table"."id" FROM "some_table" WHERE (some_variable IN ('some_value', 'another_value', 'yet_another_value') AND ((some_date <= '2016-05-01' AND DATE_TRUNC('day', updated_at) <= some_date) AND ("some_table"."id" > 123456789) ORDER BY "some_table"."id" ASC LIMIT 1000;
-- REMOVED DETAILS
Index Scan using some_table_pkey on some_table (cost=0.43..1295055.42 rows=75277 width=8) (actual time=0.771..36133.574 rows=1000 loops=1)
-- REMOVED DETAILS
Planning time: 2.200 ms
Execution time: 36134.375 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment