explain.depesz.com

PostgreSQL's explain analyze made readable

Result: baPB

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.28..768.45 rows=45 width=136) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..708.94 rows=5 width=992) (actual rows= loops=)

  • Join Filter: (cll.occupancy_type_id = ot.id)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..706.04 rows=6 width=69) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..692.39 rows=16 width=54) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on load_prop (cost=0.00..1.01 rows=1 width=24) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using idx_cached_lease_logs_cid_property_id_lease_id_reporting_month on cached_lease_logs cll (cost=0.43..691.22 rows=16 width=38) (actual rows= loops=)

  • Index Cond: ((cid = 235) AND (property_id = load_prop.property_id))
  • Filter: ((occupancy_type_id <> 5) AND (reporting_post_date < '2020-04-01 00:00:00'::timestamp without time zone) AND (apply_through_post_date >= '2020-03-31'::date) AND (lease_status_type_id <> ALL ('{1,2}'::integer[])) AND (is_post_date_ignored = 0) AND (occupancy_type_id = ANY ('{100,6,2,1,12,9,4,10}'::integer[])))
7. 0.000 0.000 ↓ 0.0

Index Scan using idx_customers_id on customers c (cost=0.42..0.85 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (id = cll.primary_customer_id)
  • Filter: (cid = 235)
8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..2.15 rows=10 width=931) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on occupancy_types ot (cost=0.00..2.10 rows=10 width=931) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using idx_ar_transactions_lease_id on ar_transactions at (cost=0.43..7.12 rows=28 width=29) (actual rows= loops=)

  • Index Cond: (lease_id = cll.lease_id)" Filter: (cid = 235)