explain.depesz.com

PostgreSQL's explain analyze made readable

Result: juTZ

Settings
# exclusive inclusive rows x rows loops node
1. 98,340.768 645,732.234 ↓ 0.0 0 1

Insert on pg_temp_8.tmp_scopeobjectpositions (cost=61,207.10..5,062,129.65 rows=53,500,680 width=36) (actual time=645,732.234..645,732.234 rows=0 loops=1)

  • Buffers: local hit=54422766 read=956170 dirtied=501397 written=500488, temp read=585318 written=585298
2. 207,368.222 547,391.466 ↑ 1.0 53,424,319 1

Hash Join (cost=61,207.10..5,062,129.65 rows=53,500,680 width=36) (actual time=4,676.528..547,391.466 rows=53,424,319 loops=1)

  • Output: NULL::integer, kwso.idkey, aopp.propertyid, kwois.idkey, aopp.positionid, aopp.positionindex, aopp.linestart, aopp.columnstart, aopp.lineend, aopp.columnend, 0
  • Hash Cond: ((aopp.sourceid = kwois.objectid) AND (aopp.sourcekind = kwois.objectkind))
  • Buffers: local read=456741 dirtied=1973 written=26697, temp read=585318 written=585298
3. 158,351.509 337,704.174 ↑ 1.0 53,424,319 1

Hash Join (cost=30,185.55..2,987,213.80 rows=53,500,680 width=38) (actual time=2,322.373..337,704.174 rows=53,424,319 loops=1)

  • Output: aopp.propertyid, aopp.positionid, aopp.positionindex, aopp.linestart, aopp.columnstart, aopp.lineend, aopp.columnend, aopp.sourceid, aopp.sourcekind, kwso.idkey
  • Hash Cond: (aopp.objectid = kwso.objectid)
  • Buffers: local read=451290 dirtied=1973 written=24438, temp read=245031 written=245025
4. 177,039.059 177,039.059 ↑ 1.0 53,424,319 1

Seq Scan on pg_temp_8.amt_objectpropertypositions aopp (cost=0.00..980,845.80 rows=53,500,680 width=38) (actual time=8.518..177,039.059 rows=53,424,319 loops=1)

  • Output: aopp.propertyid, aopp.positionid, aopp.positionindex, aopp.linestart, aopp.columnstart, aopp.lineend, aopp.columnend, aopp.objectid, aopp.sourceid, aopp.sourcekind
  • Buffers: local read=445839 dirtied=1973 written=23511
5. 1,146.799 2,313.606 ↑ 1.0 855,662 1

Hash (cost=16,146.78..16,146.78 rows=855,662 width=8) (actual time=2,313.606..2,313.606 rows=855,662 loops=1)

  • Output: kwso.idkey, kwso.objectid
  • Buckets: 32768 Batches: 4 Memory Usage: 8377kB
  • Buffers: local read=5451 written=927, temp written=2191
6. 1,166.807 1,166.807 ↑ 1.0 855,662 1

Seq Scan on pg_temp_8.kb_work_objectids kwso (cost=0.00..16,146.78 rows=855,662 width=8) (actual time=0.039..1,166.807 rows=855,662 loops=1)

  • Output: kwso.idkey, kwso.objectid
  • Filter: (kwso.objectkind = 'S'::bpchar)
  • Buffers: local read=5451 written=927
7. 1,179.620 2,319.070 ↑ 1.0 855,662 1

Hash (cost=14,007.62..14,007.62 rows=855,662 width=10) (actual time=2,319.070..2,319.070 rows=855,662 loops=1)

  • Output: kwois.idkey, kwois.objectid, kwois.objectkind
  • Buckets: 32768 Batches: 8 Memory Usage: 4401kB
  • Buffers: local read=5451 written=2259, temp written=2738
8. 1,139.450 1,139.450 ↑ 1.0 855,662 1

Seq Scan on pg_temp_8.kb_work_objectids kwois (cost=0.00..14,007.62 rows=855,662 width=10) (actual time=0.037..1,139.450 rows=855,662 loops=1)

  • Output: kwois.idkey, kwois.objectid, kwois.objectkind
  • Buffers: local read=5451 written=2259