explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WvSL : Optimization for: plan #TR3c

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 12,157.405 17,696.637 ↑ 1.0 41,463,420 1

Nested Loop (cost=0.00..519,007.57 rows=41,463,420 width=32) (actual time=0.028..17,696.637 rows=41,463,420 loops=1)

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

Seq Scan on public.f_migration (cost=0.00..604.12 rows=27,012 width=0) (actual time=0.008..28.784 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. 5,509.293 5,510.448 ↑ 1.0 1,535 27,012

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

  • Output: d_org_loc_dim.city_guid, d_org_loc_dim.auth_guid
  • Buffers: shared hit=86
4. 1.155 1.155 ↑ 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.008..1.155 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.262 ms
Execution time : 21,831.880 ms