explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y1lV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 979.472 ↑ 1.0 1 1

Finalize Aggregate (cost=13,188.83..13,188.84 rows=1 width=8) (actual time=979.471..979.472 rows=1 loops=1)

2. 40.716 1,015.872 ↓ 2.0 2 1

Gather (cost=13,188.71..13,188.82 rows=1 width=8) (actual time=978.499..1,015.872 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 7.270 975.156 ↑ 1.0 1 2

Partial Aggregate (cost=12,188.71..12,188.72 rows=1 width=8) (actual time=975.156..975.156 rows=1 loops=2)

4. 312.579 967.886 ↓ 73.3 46,644 2

Nested Loop Left Join (cost=40.21..12,187.12 rows=636 width=0) (actual time=59.759..967.886 rows=46,644 loops=2)

  • Join Filter: ((d.house_type)::text = ANY ('{2,3}'::text[]))
5. 424.942 655.301 ↓ 73.3 46,644 2

Nested Loop Left Join (cost=40.21..7,083.92 rows=636 width=18) (actual time=59.724..655.301 rows=46,644 loops=2)

  • Join Filter: ((d.house_type)::text = '1'::text)
6. 5.932 230.351 ↓ 73.3 46,644 2

Parallel Append (cost=39.65..4,225.05 rows=636 width=18) (actual time=59.661..230.351 rows=46,644 loops=2)

7. 187.044 224.419 ↓ 73.3 46,644 2

Parallel Bitmap Heap Scan on org_pf_336_offence_pd_tech_org_house_detail_2019_09 d (cost=39.65..4,221.87 rows=636 width=18) (actual time=59.660..224.419 rows=46,644 loops=2)

  • 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=51685
8. 37.375 37.375 ↓ 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=37.375..37.375 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))
9. 0.008 0.008 ↓ 0.0 0 93,288

Index Only Scan using udx_hm_houses_apartment_fias_house_code on hm_houses_apartment ap (cost=0.56..4.48 rows=1 width=37) (actual time=0.008..0.008 rows=0 loops=93,288)

  • Index Cond: (fias_house_code = ((d.fias_house_code)::character varying)::text)
  • Heap Fetches: 1113
10. 0.006 0.006 ↑ 1.0 1 93,288

Index Scan using udx_hm_houses_dwelling_fias_house_code_hash on hm_houses_dwelling dw (cost=0.01..8.01 rows=1 width=37) (actual time=0.006..0.006 rows=1 loops=93,288)

  • Index Cond: ((fias_house_code)::text = ((d.fias_house_code)::character varying)::text)
  • Rows Removed by Index Recheck: 0
  • Filter: entity_is_actual
  • Rows Removed by Filter: 0
Planning time : 0.567 ms
Execution time : 1,015.986 ms