explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L1m8

Settings
# exclusive inclusive rows x rows loops node
1. 1,109.087 196,600.870 ↓ 1.5 658,725 1

Hash Join (cost=373,357.41..3,236,966.50 rows=437,081 width=128) (actual time=8,174.505..196,600.870 rows=658,725 loops=1)

  • Hash Cond: (cal.property_id = load_prop.property_id)
2. 188,003.677 195,491.185 ↓ 1.8 883,502 1

Bitmap Heap Scan on cached_application_logs cal (cost=373,343.53..3,230,714.52 rows=497,940 width=105) (actual time=8,173.817..195,491.185 rows=883,502 loops=1)

  • Recheck Cond: (apply_through_post_date >= '2019-12-31'::date)
  • Filter: ((NOT is_post_date_ignored) 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))
  • Rows Removed by Filter: 1501350
  • Heap Blocks: exact=1708503
3. 157.771 7,486.335 ↓ 0.0 0 1

BitmapAnd (cost=373,333.88..373,333.88 rows=1,078,350 width=0) (actual time=7,486.334..7,486.335 rows=0 loops=1)

4. 994.912 994.912 ↑ 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=994.912..994.912 rows=2,384,855 loops=1)

  • Index Cond: (apply_through_post_date >= '2019-12-31'::date)
5. 6,333.652 6,333.652 ↑ 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=6,333.652..6,333.652 rows=17,424,558 loops=1)

  • Index Cond: (is_post_date_ignored = false)
6.          

SubPlan (forBitmap Heap Scan)

7. 1.173 1.173 ↑ 1.3 3 1

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
9. 0.310 0.310 ↑ 1.0 395 1

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

Planning time : 8.356 ms