explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xvkx

Settings
# exclusive inclusive rows x rows loops node
1. 2.393 8.034 ↑ 31.3 51 1

HashAggregate (cost=1,132.68..1,148.63 rows=1,595 width=76) (actual time=8.024..8.034 rows=51 loops=1)

  • Group Key: ped.start_stamp, ped.vid, ped.sid, ped.name, ped.table_type, ped.end_stamp, ped.version, ped.schema_type
2. 1.731 5.641 ↑ 1.0 5,139 1

Hash Join (cost=134.32..1,025.34 rows=5,367 width=76) (actual time=1.155..5.641 rows=5,139 loops=1)

  • Hash Cond: (psff.physical_entity_sid = ped.sid)
  • Join Filter: ((lcs.entity_query_sid <> psff.physical_entity_sid) AND (lcs.entity_load_sid <> psff.physical_entity_sid))
  • Rows Removed by Join Filter: 147
3. 2.895 2.895 ↓ 1.0 5,469 1

Seq Scan on physical_schema_field_fact psff (cost=0.00..732.14 rows=5,220 width=8) (actual time=0.128..2.895 rows=5,469 loops=1)

  • Filter: (logical_entity_sid = 2)
  • Rows Removed by Filter: 21278
4. 0.392 1.015 ↓ 1.0 1,629 1

Hash (cost=114.38..114.38 rows=1,595 width=88) (actual time=1.015..1.015 rows=1,629 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 221kB
5. 0.210 0.623 ↓ 1.0 1,629 1

Nested Loop (cost=4.29..114.38 rows=1,595 width=88) (actual time=0.017..0.623 rows=1,629 loops=1)

6. 0.003 0.009 ↑ 1.0 1 1

Bitmap Heap Scan on load_current_schema lcs (cost=4.29..11.44 rows=1 width=12) (actual time=0.009..0.009 rows=1 loops=1)

  • Recheck Cond: ((sid = 2) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((entity_query_sid IS NOT NULL) AND (entity_load_sid IS NOT NULL))
  • Heap Blocks: exact=1
7. 0.006 0.006 ↑ 2.0 1 1

Bitmap Index Scan on load_current_sche_sid_end_stamp (cost=0.00..4.29 rows=2 width=0) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: ((sid = 2) AND (end_stamp = '32503680000000'::bigint))
8. 0.404 0.404 ↓ 1.0 1,629 1

Seq Scan on physical_entity_dim ped (cost=0.00..87.00 rows=1,595 width=76) (actual time=0.006..0.404 rows=1,629 loops=1)

  • Filter: ((schema_type = 'TABLE'::text) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Filter: 104