explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cFs8

Settings
# exclusive inclusive rows x rows loops node
1. 311.807 10,505.503 ↓ 8.9 261,483 1

Hash Join (cost=580,168.43..1,500,457.17 rows=29,521 width=128) (actual time=6,252.626..10,505.503 rows=261,483 loops=1)

  • Hash Cond: (cal.property_id = load_prop.property_id)
2. 4,117.892 10,193.131 ↓ 7.8 262,307 1

Bitmap Heap Scan on cached_application_logs cal (cost=580,154.54..1,500,021.95 rows=33,632 width=105) (actual time=6,252.051..10,193.131 rows=262,307 loops=1)

  • Recheck Cond: ((apply_through_post_date >= '2019-12-31'::date) AND (post_date >= '2019-01-01'::date))
  • Filter: ((NOT is_post_date_ignored) AND (unit_number_cache IS NOT NULL) AND (application_status_id <> ALL ('{5,6}'::integer[])) AND (lease_interval_type_id <> 4) AND CASE WHEN (cancellation_list_item_id IS NULL) THEN true WHEN (hashed SubPlan 1) THEN false ELSE true END AND (reporting_post_date < '2020-01-01 00:00:00'::timestamp without time zone) AND (cid = 3395) AND (lease_interval_type_id = ANY ('{1,5,3}'::integer[])))
  • Rows Removed by Filter: 363327
  • Heap Blocks: exact=545690
3. 211.372 6,075.187 ↓ 0.0 0 1

BitmapAnd (cost=580,144.89..580,144.89 rows=273,775 width=0) (actual time=6,075.187..6,075.187 rows=0 loops=1)

4. 964.791 964.791 ↑ 1.1 2,384,855 1

Bitmap Index Scan on idx_cached_application_logs_apply_through_post_date (cost=0.00..50,322.19 rows=2,724,483 width=0) (actual time=964.791..964.791 rows=2,384,855 loops=1)

  • Index Cond: (apply_through_post_date >= '2019-12-31'::date)
5. 1,917.273 1,917.273 ↓ 1.0 11,259,249 1

Bitmap Index Scan on idx_cached_application_logs_post_date (cost=0.00..207,034.51 rows=11,209,859 width=0) (actual time=1,917.273..1,917.273 rows=11,259,249 loops=1)

  • Index Cond: (post_date >= '2019-01-01'::date)
6. 2,981.751 2,981.751 ↑ 1.0 17,424,558 1

Bitmap Index Scan on idx_cached_application_logs_is_post_date_ignored (cost=0.00..322,762.47 rows=17,475,988 width=0) (actual time=2,981.751..2,981.751 rows=17,424,558 loops=1)

  • Index Cond: (is_post_date_ignored = false)
7.          

SubPlan (forBitmap Heap Scan)

8. 0.052 0.052 ↑ 1.3 3 1

Seq Scan on list_items li (cost=0.00..9.63 rows=4 width=4) (actual time=0.021..0.052 rows=3 loops=1)

  • Filter: ((default_list_item_id = ANY ('{66,65}'::integer[])) AND (cid = 3395))
  • Rows Removed by Filter: 306
9. 0.290 0.565 ↑ 1.0 395 1

Hash (cost=8.95..8.95 rows=395 width=27) (actual time=0.564..0.565 rows=395 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
10. 0.275 0.275 ↑ 1.0 395 1

Seq Scan on load_prop (cost=0.00..8.95 rows=395 width=27) (actual time=0.009..0.275 rows=395 loops=1)

Planning time : 20.899 ms