explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ofJY

Settings
# exclusive inclusive rows x rows loops node
1. 335.398 23,224.760 ↓ 8.8 261,483 1

Hash Join (cost=580,168.53..1,499,432.30 rows=29,639 width=128) (actual time=6,753.593..23,224.760 rows=261,483 loops=1)

  • Hash Cond: (cal.property_id = load_prop.property_id)
2. 16,315.415 22,888.807 ↓ 7.8 262,307 1

Bitmap Heap Scan on cached_application_logs cal (cost=580,154.64..1,498,995.40 rows=33,766 width=105) (actual time=6,753.027..22,888.807 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))
  • Rows Removed by Filter: 363327
  • Heap Blocks: exact=545690
3. 211.231 6,573.341 ↓ 0.0 0 1

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

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

  • Index Cond: (apply_through_post_date >= '2019-12-31'::date)
5. 2,006.810 2,006.810 ↓ 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=2,006.810..2,006.810 rows=11,259,249 loops=1)

  • Index Cond: (post_date >= '2019-01-01'::date)
6. 3,288.715 3,288.715 ↑ 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=3,288.715..3,288.715 rows=17,424,558 loops=1)

  • Index Cond: (is_post_date_ignored = false)
7.          

SubPlan (forBitmap Heap Scan)

8. 0.051 0.051 ↑ 1.3 3 1

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

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

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

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

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

Planning time : 1.141 ms