explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3F6Y7

Settings
# exclusive inclusive rows x rows loops node
1. 169.572 140,268.995 ↓ 3.6 215,993 1

Nested Loop (cost=0.57..457,425.56 rows=59,776 width=44) (actual time=143.253..140,268.995 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. 140,099.416 140,099.416 ↓ 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=143.245..140,099.416 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.743 ms