explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C43r

Settings
# exclusive inclusive rows x rows loops node
1. 99,580.823 497,002.149 ↓ 0.0 0 1

Insert on pg_temp_8.amt_objectpropertypositions (cost=47,293.40..1,212,697.28 rows=260,003 width=44) (actual time=497,002.149..497,002.149 rows=0 loops=1)

  • Buffers: shared hit=3 read=500006, local hit=54392172 read=470648 dirtied=455971 written=451878, temp read=292171 written=292165
2. 222,993.331 397,421.326 ↓ 205.8 53,500,608 1

Hash Join (cost=47,293.40..1,212,697.28 rows=260,003 width=44) (actual time=2,478.610..397,421.326 rows=53,500,608 loops=1)

  • Output: ipp.object_id, ipp.property_type_id, ipp.object_source_id, CASE WHEN (ipp.object_source_kind = 'I'::bpchar) THEN 'K'::text WHEN (ipp.object_source_kind = 'E'::bpchar) THEN 'S'::text ELSE NULL::text END, ipp.position_id, ipp.position_index, ipp.line_start, ipp.col_start, ipp.line_end, ipp.col_end
  • Hash Cond: (ipp.object_id = ao.objectid)
  • Buffers: shared hit=3 read=500006, local read=24698 dirtied=10132 written=7131, temp read=292171 written=292165
3. 171,959.859 171,959.859 ↓ 205.8 53,500,608 1

Seq Scan on new_fva_local.in_prop_positions ipp (cost=0.00..1,150,013.80 rows=260,003 width=44) (actual time=9.619..171,959.859 rows=53,500,608 loops=1)

  • Output: ipp.object_id, ipp.property_type_id, ipp.object_source_id, ipp.object_source_kind, ipp.position_id, ipp.position_index, ipp.line_start, ipp.col_start, ipp.line_end, ipp.col_end
  • Filter: (ipp.session_id = 252)
  • Buffers: shared read=500006
4. 1,115.910 2,468.136 ↑ 1.0 855,662 1

Hash (cost=33,254.62..33,254.62 rows=855,662 width=4) (actual time=2,468.136..2,468.136 rows=855,662 loops=1)

  • Output: ao.objectid
  • Buckets: 32768 Batches: 4 Memory Usage: 7541kB
  • Buffers: local read=24698 dirtied=10132 written=7131, temp written=1879
5. 1,352.226 1,352.226 ↑ 1.0 855,662 1

Seq Scan on pg_temp_8.amt_objects ao (cost=0.00..33,254.62 rows=855,662 width=4) (actual time=0.050..1,352.226 rows=855,662 loops=1)

  • Output: ao.objectid
  • Buffers: local read=24698 dirtied=10132 written=7131