explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YsLV

Settings
# exclusive inclusive rows x rows loops node
1. 14,302.288 680,087.821 ↓ 0.0 0 1

Delete on pg_temp_4.amt_objectpropertypositions (cost=9,783,346.47..11,256,539.08 rows=1 width=12) (actual time=680,087.821..680,087.821 rows=0 loops=1)

  • Buffers: local hit=74321 read=448443 dirtied=1973 written=548, temp read=1147064 written=1147064
2. 74,947.230 665,785.533 ↓ 76,289.0 76,289 1

Merge Join (cost=9,783,346.47..11,256,539.08 rows=1 width=12) (actual time=520,476.678..665,785.533 rows=76,289 loops=1)

  • Output: amt_objectpropertypositions.ctid, twopp.ctid
  • Merge Cond: ((amt_objectpropertypositions.objectid = twopp.objectid) AND (amt_objectpropertypositions.propertyid = twopp.propertyid) AND (amt_objectpropertypositions.sourceid = twopp.sourceid) AND (amt_objectpropertypositions.sourcekind = twopp.sourcekind) AND (amt_objectpropertypositions.positionid = twopp.positionid) AND (amt_objectpropertypositions.positionindex = twopp.positionindex) AND (amt_objectpropertypositions.linestart = twopp.linestart) AND (amt_objectpropertypositions.columnstart = twopp.columnstart) AND (amt_objectpropertypositions.lineend = twopp.lineend) AND (amt_objectpropertypositions.columnend = twopp.columnend))
  • Buffers: local read=446475 written=548, temp read=1147064 written=1147064
3. 472,414.203 589,773.419 ↑ 1.0 53,500,211 1

Sort (cost=9,776,381.10..9,910,132.80 rows=53,500,680 width=44) (actual time=516,402.827..589,773.419 rows=53,500,211 loops=1)

  • Output: amt_objectpropertypositions.ctid, amt_objectpropertypositions.objectid, amt_objectpropertypositions.propertyid, amt_objectpropertypositions.sourceid, amt_objectpropertypositions.sourcekind, amt_objectpropertypositions.positionid, amt_objectpropertypositions.positionindex, amt_objectpropertypositions.linestart, amt_objectpropertypositions.columnstart, amt_objectpropertypositions.lineend, amt_objectpropertypositions.columnend
  • Sort Key: amt_objectpropertypositions.objectid, amt_objectpropertypositions.propertyid, amt_objectpropertypositions.sourceid, amt_objectpropertypositions.sourcekind, amt_objectpropertypositions.positionid, amt_objectpropertypositions.positionindex, amt_objectpropertypositions.linestart, amt_objectpropertypositions.columnstart, amt_objectpropertypositions.lineend, amt_objectpropertypositions.columnend
  • Sort Method: external merge Disk: 3031840kB
  • Buffers: local read=445839 written=548, temp read=1145907 written=1145907
4. 117,359.216 117,359.216 ↑ 1.0 53,500,608 1

Seq Scan on pg_temp_4.amt_objectpropertypositions (cost=0.00..980,845.80 rows=53,500,680 width=44) (actual time=7.889..117,359.216 rows=53,500,608 loops=1)

  • Output: amt_objectpropertypositions.ctid, amt_objectpropertypositions.objectid, amt_objectpropertypositions.propertyid, amt_objectpropertypositions.sourceid, amt_objectpropertypositions.sourcekind, amt_objectpropertypositions.positionid, amt_objectpropertypositions.positionindex, amt_objectpropertypositions.linestart, amt_objectpropertypositions.columnstart, amt_objectpropertypositions.lineend, amt_objectpropertypositions.columnend
  • Buffers: local read=445839 written=548
5. 363.748 1,064.884 ↓ 1.1 76,289 1

Sort (cost=6,965.37..7,140.27 rows=69,960 width=50) (actual time=949.773..1,064.884 rows=76,289 loops=1)

  • Output: twopp.ctid, twopp.objectid, twopp.propertyid, twopp.sourceid, twopp.sourcekind, twopp.positionid, twopp.positionindex, twopp.linestart, twopp.columnstart, twopp.lineend, twopp.columnend
  • Sort Key: twopp.objectid, twopp.propertyid, twopp.sourceid, twopp.sourcekind, twopp.positionid, twopp.positionindex, twopp.linestart, twopp.columnstart, twopp.lineend, twopp.columnend
  • Sort Method: external sort Disk: 4624kB
  • Buffers: local read=636, temp read=1157 written=1157
6. 701.136 701.136 ↓ 1.1 76,289 1

Seq Scan on pg_temp_4.tmp_wrongobjectpropertypositions twopp (cost=0.00..1,335.60 rows=69,960 width=50) (actual time=5.808..701.136 rows=76,289 loops=1)

  • Output: twopp.ctid, twopp.objectid, twopp.propertyid, twopp.sourceid, twopp.sourcekind, twopp.positionid, twopp.positionindex, twopp.linestart, twopp.columnstart, twopp.lineend, twopp.columnend
  • Buffers: local read=636