Skip to content

Instantly share code, notes, and snippets.

@tom-lord

tom-lord/lease_deals_explain_1.sql

Created October 12, 2018 13:15
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/2ab10e88737da6d975e3ae002cf9bead to your computer and use it in GitHub Desktop.
Save tom-lord/2ab10e88737da6d975e3ae002cf9bead to your computer and use it in GitHub Desktop.
Download ZIP
Raw
lease_deals_explain_1.sql
Bitmap Heap Scan on lease_deals (cost=172.99..18520.04 rows=5903 width=205)
Recheck Cond: (dealership_id = 1234)
Filter: ((expired_at IS NULL) AND (updated_at < '2018-10-09 09:34:11.818701'::timestamp without time zone))
-> Bitmap Index Scan on index_lease_deals_on_dealership_id (cost=0.00..172.70 rows=9724 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