explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l3z

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 450,513.504 ↓ 0.0 0 1
→

Update on pg_temp_8.tmp_scopeobjectpositions (cost=10,088,223.65..11,461,308.41 rows=1 width=52) (actual time=450,513.504..450,513.504 rows=0 loops=1)

  • Buffers: local read=499293 written=4095, temp read=150789 written=489655
2. 0.016 450,513.498 ↓ 0.0 0 1
→

Merge Join (cost=10,088,223.65..11,461,308.41 rows=1 width=52) (actual time=450,513.498..450,513.498 rows=0 loops=1)

  • Output: dp.metricpositionid, tmp_scopeobjectpositions.objectid, tmp_scopeobjectpositions.propertyid, tmp_scopeobjectpositions.sourceid, tmp_scopeobjectpositions.positionid, tmp_scopeobjectpositions.positionindex, tmp_scopeobjectpositions.linestart, tmp_scopeobjectpositions.colstart, tmp_scopeobjectpositions.lineend, tmp_scopeobjectpositions.colend, 1, tmp_scopeobjectpositions.ctid, dp.ctid
  • Merge Cond: ((tmp_scopeobjectpositions.objectid = dp.objectid) AND (tmp_scopeobjectpositions.propertyid = dp.propertyid) AND (tmp_scopeobjectpositions.sourceid = dp.sourceid) AND (tmp_scopeobjectpositions.positionid = dp.positionid) AND (tmp_scopeobjectpositions.positionindex = dp.positionindex) AND (tmp_scopeobjectpositions.linestart = dp.linestart) AND (tmp_scopeobjectpositions.colstart = dp.colstart) AND (tmp_scopeobjectpositions.lineend = dp.lineend) AND (tmp_scopeobjectpositions.colend = dp.colend))
  • Buffers: local read=499293 written=4095, temp read=150789 written=489655
3. 253,746.941 450,513.428 ↑ 54,922,230.0 1 1
→

Sort (cost=10,088,143.01..10,225,448.59 rows=54,922,230 width=42) (actual time=450,513.428..450,513.428 rows=1 loops=1)

  • Output: tmp_scopeobjectpositions.objectid, tmp_scopeobjectpositions.propertyid, tmp_scopeobjectpositions.sourceid, tmp_scopeobjectpositions.positionid, tmp_scopeobjectpositions.positionindex, tmp_scopeobjectpositions.linestart, tmp_scopeobjectpositions.colstart, tmp_scopeobjectpositions.lineend, tmp_scopeobjectpositions.colend, tmp_scopeobjectpositions.ctid
  • Sort Key: tmp_scopeobjectpositions.objectid, tmp_scopeobjectpositions.propertyid, tmp_scopeobjectpositions.sourceid, tmp_scopeobjectpositions.positionid, tmp_scopeobjectpositions.positionindex, tmp_scopeobjectpositions.linestart, tmp_scopeobjectpositions.colstart, tmp_scopeobjectpositions.lineend, tmp_scopeobjectpositions.colend
  • Sort Method: external merge Disk: 2714288kB
  • Buffers: local read=499293 written=4095, temp read=150789 written=489655
4. 196,766.487 196,766.487 ↑ 1.0 53,424,319 1
→

Seq Scan on pg_temp_8.tmp_scopeobjectpositions (cost=0.00..1,048,515.30 rows=54,922,230 width=42) (actual time=9.619..196,766.487 rows=53,424,319 loops=1)

  • Output: tmp_scopeobjectpositions.objectid, tmp_scopeobjectpositions.propertyid, tmp_scopeobjectpositions.sourceid, tmp_scopeobjectpositions.positionid, tmp_scopeobjectpositions.positionindex, tmp_scopeobjectpositions.linestart, tmp_scopeobjectpositions.colstart, tmp_scopeobjectpositions.lineend, tmp_scopeobjectpositions.colend, tmp_scopeobjectpositions.ctid
  • Buffers: local read=499293 written=4095
5. 0.050 0.054 ↓ 0.0 0 1
→

Sort (cost=80.64..83.54 rows=1,160 width=46) (actual time=0.054..0.054 rows=0 loops=1)

  • Output: dp.metricpositionid, dp.ctid, dp.objectid, dp.propertyid, dp.sourceid, dp.positionid, dp.positionindex, dp.linestart, dp.colstart, dp.lineend, dp.colend
  • Sort Key: dp.objectid, dp.propertyid, dp.sourceid, dp.positionid, dp.positionindex, dp.linestart, dp.colstart, dp.lineend, dp.colend
  • Sort Method: quicksort Memory: 25kB
6. 0.004 0.004 ↓ 0.0 0 1
→

Seq Scan on new_fva_local.dss_positions dp (cost=0.00..21.60 rows=1,160 width=46) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: dp.metricpositionid, dp.ctid, dp.objectid, dp.propertyid, dp.sourceid, dp.positionid, dp.positionindex, dp.linestart, dp.colstart, dp.lineend, dp.colend