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

  • Select an option

    Learn more about clone URLs
  • Save tom-lord/4b80c76d9b46856f3eccf8c6f06793e1 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tom-lord/4b80c76d9b46856f3eccf8c6f06793e1 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. tom-lord created this gist Oct 12, 2018.
    5 changes: 5 additions & 0 deletions lease_deals_explain_2.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,5 @@
    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)