explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6S1h

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.168 ↓ 11.0 11 1

Group (cost=19.49..19.50 rows=1 width=8) (actual time=0.151..0.168 rows=11 loops=1)

  • Group Key: e.cid, e.lease_interval_id
2. 0.025 0.155 ↓ 11.0 11 1

Sort (cost=19.49..19.50 rows=1 width=8) (actual time=0.149..0.155 rows=11 loops=1)

  • Sort Key: e.lease_interval_id
  • Sort Method: quicksort Memory: 25kB
3. 0.023 0.130 ↓ 11.0 11 1

Nested Loop (cost=0.72..19.48 rows=1 width=8) (actual time=0.050..0.130 rows=11 loops=1)

4. 0.013 0.074 ↓ 11.0 11 1

Nested Loop (cost=0.43..13.92 rows=1 width=12) (actual time=0.038..0.074 rows=11 loops=1)

5. 0.008 0.008 ↑ 1.0 1 1

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

6. 0.053 0.053 ↓ 11.0 11 1

Index Scan using idx_events_cid_etid_pid_event_datetime on events e (cost=0.43..12.90 rows=1 width=16) (actual time=0.029..0.053 rows=11 loops=1)

  • Index Cond: ((cid = 12881) AND (event_type_id = ANY ('{9,78}'::integer[])) AND (property_id = load_prop.property_id) AND (event_datetime < '2019-11-11 00:00:00-07'::timestamp with time zone))
  • Filter: (lease_interval_id IS NOT NULL)
7. 0.033 0.033 ↑ 1.0 1 11

Index Scan using idx_event_results on event_results er (cost=0.29..4.68 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=11)

  • Index Cond: (id = e.event_result_id)
  • Filter: ((cid = 12881) AND (2 = ANY (default_event_result_ids)))
Planning time : 1.530 ms