explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UggP

Settings
# exclusive inclusive rows x rows loops node
1. 0.096 2,319.320 ↓ 1.1 152 1

HashSetOp Except (cost=0.00..1,945,115.24 rows=136 width=36) (actual time=2,319.306..2,319.320 rows=152 loops=1)

2. 0.018 2,319.224 ↓ 1.1 156 1

Append (cost=0.00..1,945,114.89 rows=138 width=36) (actual time=54.877..2,319.224 rows=156 loops=1)

3. 0.041 1,181.201 ↓ 1.1 154 1

Subquery Scan on "*SELECT* 1" (cost=0.00..972,558.11 rows=136 width=13) (actual time=54.877..1,181.201 rows=154 loops=1)

4. 1,181.160 1,181.160 ↓ 1.1 154 1

Seq Scan on fact_lead_daily f (cost=0.00..972,556.76 rows=136 width=9) (actual time=54.876..1,181.160 rows=154 loops=1)

  • Filter: ((date_key >= '2019-07-01'::date) AND (date_key <= '2019-07-31'::date) AND (guest_card_complete_count <> 0) AND (property_id = '653384'::text) AND (lease_type_id = '1'::text))
  • Rows Removed by Filter: 4832893
5. 0.002 1,138.005 ↑ 1.0 2 1

Subquery Scan on "*SELECT* 2" (cost=0.00..972,556.78 rows=2 width=13) (actual time=509.888..1,138.005 rows=2 loops=1)

6. 1,138.003 1,138.003 ↑ 1.0 2 1

Seq Scan on fact_lead_daily fld (cost=0.00..972,556.76 rows=2 width=9) (actual time=509.886..1,138.003 rows=2 loops=1)

  • Filter: ((date_key >= '2019-07-01'::date) AND (date_key <= '2019-07-31'::date) AND (property_id = '653384'::text) AND (lease_type_id = '1'::text) AND (combine_total_count = 1))
  • Rows Removed by Filter: 4833045
Planning time : 0.149 ms