explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2VKX

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 391,084.108 ↓ 0.0 0 1

Insert on pg_temp_8.amt_linkpropertypositions (cost=95,988.59..1,268,506.47 rows=260,003 width=44) (actual time=391,084.108..391,084.108 rows=0 loops=1)

  • Buffers: shared hit=3 read=500006, local read=20907 dirtied=13774 written=12447, temp read=372585 written=372555
2. 194,113.375 391,084.101 ↓ 0.0 0 1

Hash Join (cost=95,988.59..1,268,506.47 rows=260,003 width=44) (actual time=391,084.101..391,084.101 rows=0 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 = al.linkid)
  • Buffers: shared hit=3 read=500006, local read=20907 dirtied=13774 written=12447, temp read=372585 written=372555
3. 184,079.138 184,079.138 ↓ 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=7.132..184,079.138 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. 4,021.760 12,891.588 ↑ 1.0 2,843,315 1

Hash (cost=49,340.15..49,340.15 rows=2,843,315 width=4) (actual time=12,891.588..12,891.588 rows=2,843,315 loops=1)

  • Output: al.linkid
  • Buckets: 32768 Batches: 16 Memory Usage: 6267kB
  • Buffers: local read=20907 dirtied=13774 written=12447, temp written=7801
5. 8,869.828 8,869.828 ↑ 1.0 2,843,315 1

Seq Scan on pg_temp_8.amt_links al (cost=0.00..49,340.15 rows=2,843,315 width=4) (actual time=5.208..8,869.828 rows=2,843,315 loops=1)

  • Output: al.linkid
  • Buffers: local read=20907 dirtied=13774 written=12447