Skip to content

Instantly share code, notes, and snippets.

@tom-lord

tom-lord/lease_deals_explain_3.sql

Created October 12, 2018 13:57
Show Gist options
  • Save tom-lord/4df7555fe7d25d6a91069a292b386c21 to your computer and use it in GitHub Desktop.
Save tom-lord/4df7555fe7d25d6a91069a292b386c21 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
lease_deals_explain_3.sql
Limit (cost=0.11..4232.55 rows=1000 width=4)
-> Index Scan using lease_deals_pkey on lease_deals (cost=0.11..3130311.24 rows=739600 width=4)
Filter: ((expired_at IS NULL) AND (updated_at < '2018-10-09 09:26:33.507679'::timestamp without time zone) AND (dealership_id = 5678))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment