Update on pg_temp_8.tmp_scopeobjectpositions (cost=10088223.65..11461308.41 rows=1 width=52) (actual time=450513.504..450513.504 rows=0 loops=1)
Buffers: local read=499293 written=4095, temp read=150789 written=489655
-> Merge Join (cost=10088223.65..11461308.41 rows=1 width=52) (actual time=450513.498..450513.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
-> Sort (cost=10088143.01..10225448.59 rows=54922230 width=42) (actual time=450513.428..450513.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
-> Seq Scan on pg_temp_8.tmp_scopeobjectpositions (cost=0.00..1048515.30 rows=54922230 width=42) (actual time=9.619..196766.487 rows=53424319 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
-> Sort (cost=80.64..83.54 rows=1160 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
-> Seq Scan on new_fva_local.dss_positions dp (cost=0.00..21.60 rows=1160 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