explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4W6s

Settings
# exclusive inclusive rows x rows loops node
1. 154.712 175,885.471 ↓ 0.0 0 1

Insert on pg_temp_6.wk_sum (cost=0.00..6,621.62 rows=1 width=36) (actual time=175,885.471..175,885.471 rows=0 loops=1)

  • Buffers: shared hit=2233, local hit=727406 read=198 dirtied=196 written=10
2. 86,593.799 175,730.759 ↓ 26,545.0 26,545 1

Nested Loop (cost=0.00..6,621.62 rows=1 width=36) (actual time=0.119..175,730.759 rows=26,545 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: 73873462
  • Buffers: shared hit=2233, local hit=700474
3. 526.999 526.999 ↓ 350,237.0 350,237 1

Seq Scan on endtoend_839_local.in_int_properties iprop (cost=0.00..6,614.88 rows=1 width=16) (actual time=0.055..526.999 rows=350,237 loops=1)

  • Output: iprop.session_id, iprop.object_id, iprop.property_type_id, iprop.property_offset, iprop.property_int
  • Filter: (iprop.session_id = 349)
  • Buffers: shared hit=2233
4. 88,609.961 88,609.961 ↑ 1.0 211 350,237

Seq Scan on pg_temp_6.tmp_sumtype sumtype (cost=0.00..4.11 rows=211 width=12) (actual time=0.005..0.253 rows=211 loops=350,237)

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