explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i7BW : Optimization for: plan #TR3c

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 5,255.559 7,777.481 ↑ 1.0 41,463,420 1

Nested Loop (cost=0.00..519,007.57 rows=41,463,420 width=32) (actual time=0.024..7,777.481 rows=41,463,420 loops=1)

  • Output: d_org_loc_dim.city_guid, d_org_loc_dim.auth_guid
  • Buffers: shared hit=420
2. 9.806 9.806 ↑ 1.0 27,012 1

Seq Scan on public.f_migration (cost=0.00..604.12 rows=27,012 width=0) (actual time=0.012..9.806 rows=27,012 loops=1)

  • Output: f_migration.group_guid, f_migration.org_guid, f_migration.month_id, f_migration.max_occ, f_migration.student_count_start, f_migration.student_count_end, f_migration.enrolled_count, f_migration.expelled_count
  • Buffers: shared hit=334
3. 2,511.617 2,512.116 ↑ 1.0 1,535 27,012

Materialize (cost=0.00..114.54 rows=1,535 width=32) (actual time=0.000..0.093 rows=1,535 loops=27,012)

  • Output: d_org_loc_dim.city_guid, d_org_loc_dim.auth_guid
  • Buffers: shared hit=86
4. 0.499 0.499 ↑ 1.0 1,535 1

Seq Scan on public.d_org d_org_loc_dim (cost=0.00..106.86 rows=1,535 width=32) (actual time=0.006..0.499 rows=1,535 loops=1)

  • Output: d_org_loc_dim.city_guid, d_org_loc_dim.auth_guid
  • Filter: (d_org_loc_dim.city_guid = '91bd0dde-967d-4b7d-ba60-b25a4c985d1a'::uuid)
  • Rows Removed by Filter: 134
  • Buffers: shared hit=86
Planning time : 0.092 ms
Execution time : 9,724.716 ms