explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vg6Jk

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 540.086 11,617.397 ↑ 5,455.2 93,288 1

Hash Right Join (cost=210,690.37..9,297,884.59 rows=508,906,920 width=696) (actual time=11,478.575..11,617.397 rows=93,288 loops=1)

  • Hash Cond: ((dw.fias_house_code)::uuid = d.fias_house_code)
  • Buffers: shared hit=244363 read=1577398, temp read=10976 written=10976
  • I/O Timings: read=4079.917
2. 9,590.379 9,590.379 ↓ 1.0 282,448 1

Seq Scan on hm_houses_dwelling dw (cost=0.00..1,755,370.34 rows=280,364 width=38) (actual time=0.032..9,590.379 rows=282,448 loops=1)

  • Filter: (NOT entity_is_actual)
  • Rows Removed by Filter: 16530760
  • Buffers: shared hit=9821 read=1577398
  • I/O Timings: read=4079.917
3. 173.845 1,486.932 ↑ 3.9 93,288 1

Hash (cost=174,244.46..174,244.46 rows=363,033 width=696) (actual time=1,486.932..1,486.932 rows=93,288 loops=1)

  • Buckets: 65536 Batches: 16 Memory Usage: 3251kB
  • Buffers: shared hit=234542, temp read=4127 written=9081
4. 234.541 1,313.087 ↑ 3.9 93,288 1

Hash Right Join (cost=4,248.60..174,244.46 rows=363,033 width=696) (actual time=1,164.790..1,313.087 rows=93,288 loops=1)

  • Hash Cond: ((ap.fias_house_code)::uuid = d.fias_house_code)
  • Buffers: shared hit=234542, temp read=4127 written=4127
5. 783.750 783.750 ↓ 1.0 68,204 1

Seq Scan on hm_houses_apartment ap (cost=0.00..164,687.93 rows=67,104 width=38) (actual time=0.013..783.750 rows=68,204 loops=1)

  • Filter: (NOT entity_is_actual)
  • Rows Removed by Filter: 1513889
  • Buffers: shared hit=148916
6. 90.559 294.796 ↓ 86.2 93,288 1

Hash (cost=4,235.07..4,235.07 rows=1,082 width=695) (actual time=294.796..294.796 rows=93,288 loops=1)

  • Buckets: 131072 (originally 2048) Batches: 2 (originally 1) Memory Usage: 31745kB
  • Buffers: shared hit=85626, temp written=2638
7. 15.836 204.237 ↓ 86.2 93,288 1

Append (cost=39.65..4,235.07 rows=1,082 width=695) (actual time=45.852..204.237 rows=93,288 loops=1)

  • Buffers: shared hit=85626
8. 163.406 188.401 ↓ 86.2 93,288 1

Bitmap Heap Scan on org_pf_336_offence_pd_tech_org_house_detail_2019_09 d (cost=39.65..4,229.66 rows=1,082 width=695) (actual time=45.851..188.401 rows=93,288 loops=1)

  • Recheck Cond: ((ppa_organization_guid = 'd0f5d77e-0fe6-459a-afab-265adb3a65b7'::uuid) AND (fias_region_code = '15784a67-8cea-425b-834a-6afe0e3ed61c'::uuid))
  • Filter: (report_month = '2019-09-01'::date)
  • Heap Blocks: exact=85060
  • Buffers: shared hit=85626
9. 24.995 24.995 ↓ 86.2 93,288 1

Bitmap Index Scan on idx_org_pf_336_self_pd_tech_org_house_detail_2019_09 (cost=0.00..39.38 rows=1,082 width=0) (actual time=24.995..24.995 rows=93,288 loops=1)

  • Index Cond: ((ppa_organization_guid = 'd0f5d77e-0fe6-459a-afab-265adb3a65b7'::uuid) AND (fias_region_code = '15784a67-8cea-425b-834a-6afe0e3ed61c'::uuid))
  • Buffers: shared hit=566
Planning time : 0.506 ms
Execution time : 11,623.837 ms