explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2HLa

Settings
# exclusive inclusive rows x rows loops node
1. 184.783 234,425.982 ↓ 3.6 215,993 1

Nested Loop (cost=0.57..457,425.56 rows=59,776 width=44) (actual time=45,514.156..234,425.982 rows=215,993 loops=1)

2. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on load_prop (cost=0.00..1.01 rows=1 width=4) (actual time=0.005..0.007 rows=1 loops=1)

3. 234,241.192 234,241.192 ↓ 3.6 215,993 1

Index Scan using idx_events_s1314 on events e (cost=0.57..456,826.79 rows=59,776 width=44) (actual time=45,514.148..234,241.192 rows=215,993 loops=1)

  • Index Cond: ((cid = 3395) AND (property_id = load_prop.property_id))
  • Filter: ((NOT is_deleted) AND (event_datetime >= '2018-01-01 00:00:00-07'::timestamp with time zone) AND (event_datetime <= '2018-12-31 23:59:59-07'::timestamp with time zone))
  • Rows Removed by Filter: 790720
Planning time : 0.712 ms