explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PnYO

Settings
# exclusive inclusive rows x rows loops node
1. 118.280 160,688.279 ↓ 0.0 0 1

Insert on pg_temp_7.wk_sum (cost=0.00..6,635.81 rows=1 width=36) (actual time=160,688.279..160,688.279 rows=0 loops=1)

  • Buffers: shared hit=2238, local hit=728702 read=197 dirtied=195 written=195
2. 80,473.728 160,569.999 ↓ 26,513.0 26,513 1

Nested Loop (cost=0.00..6,635.81 rows=1 width=36) (actual time=35.497..160,569.999 rows=26,513 loops=1)

  • Output: iprop.object_id, 'E'::character(1), iprop.property_type_id, iprop.property_offset, iprop.property_int, sumtype.inftypatt, sumtype.infsubtypatt, iprop.object_id
  • Join Filter: (sumtype.idprop = iprop.property_type_id)
  • Rows Removed by Join Filter: 74013809
  • Buffers: shared hit=2238, local hit=701804
3. 441.517 441.517 ↓ 350,902.0 350,902 1

Seq Scan on endtoend_839_local.in_int_properties iprop (cost=0.00..6,629.06 rows=1 width=16) (actual time=0.039..441.517 rows=350,902 loops=1)

  • Output: iprop.session_id, iprop.object_id, iprop.property_type_id, iprop.property_offset, iprop.property_int
  • Filter: (iprop.session_id = 318)
  • Buffers: shared hit=2238
4. 79,654.754 79,654.754 ↑ 1.0 211 350,902

Seq Scan on pg_temp_7.tmp_sumtype sumtype (cost=0.00..4.11 rows=211 width=12) (actual time=0.004..0.227 rows=211 loops=350,902)

  • Output: sumtype.idprop, sumtype.inftypatt, sumtype.infsubtypatt
  • Buffers: local hit=701804