Skip to content

Instantly share code, notes, and snippets.

@tom-lord

tom-lord/lease_deals_explain_2.sql

Created October 12, 2018 13:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tom-lord/4b80c76d9b46856f3eccf8c6f06793e1 to your computer and use it in GitHub Desktop.
Save tom-lord/4b80c76d9b46856f3eccf8c6f06793e1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
lease_deals_explain_2.sql
Bitmap Heap Scan on lease_deals (cost=448.02..903.13 rows=5903 width=205)
Recheck Cond: ((dealership_id = 1234) AND (expired_at IS NULL))
Filter: ((updated_at < '2018-10-09 09:34:11.818701'::timestamp without time zone))
-> Bitmap Index Scan on index_lease_deals_on_dealership_id_and_expired_at (cost=0.00..411.04 rows=6724 width=0)
Index Cond: (dealership_id = 1234)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment