explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UtGj

Settings
# exclusive inclusive rows x rows loops node
1. 22,751.119 64,855.835 ↑ 1.0 53,500,608 1

Hash Join (cost=10,000,077,724.57..10,002,730,466.62 rows=53,500,680 width=72) (actual time=1,060.084..64,855.835 rows=53,500,608 loops=1)

  • Output: NULL::unknown, 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: shared hit=6, local hit=3287 read=449116 dirtied=445839 written=441744
2. 18,252.485 41,543.637 ↑ 1.0 53,500,608 1

Hash Join (cost=10,000,038,862.29..10,001,755,342.43 rows=53,500,680 width=38) (actual time=492.407..41,543.637 rows=53,500,608 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 hit=3282 read=445839 dirtied=445839 written=441744
3. 22,809.833 22,809.833 ↑ 1.0 53,500,608 1

Seq Scan on pg_temp_5.amt_objectpropertypositions aopp (cost=10,000,000,000.00..10,000,980,845.80 rows=53,500,680 width=38) (actual time=0.127..22,809.833 rows=53,500,608 loops=1)

  • Output: aopp.objectid, aopp.propertyid, aopp.sourceid, aopp.sourcekind, aopp.positionid, aopp.positionindex, aopp.linestart, aopp.columnstart, aopp.lineend, aopp.columnend
  • Buffers: local read=445839 dirtied=445839 written=441744
4. 295.671 481.319 ↑ 1.0 855,662 1

Hash (cost=28,166.51..28,166.51 rows=855,662 width=8) (actual time=481.319..481.319 rows=855,662 loops=1)

  • Output: kwso.idkey, kwso.objectid
  • Buckets: 1048576 Batches: 1 Memory Usage: 41617kB
  • Buffers: local hit=3282
5. 185.648 185.648 ↑ 1.0 855,662 1

Index Only Scan using idx_kb_work_objectids_objectid_objectkind_idkey on pg_temp_5.kb_work_objectids kwso (cost=0.42..28,166.51 rows=855,662 width=8) (actual time=0.042..185.648 rows=855,662 loops=1)

  • Output: kwso.idkey, kwso.objectid
  • Index Cond: (kwso.objectkind = 'S'::bpchar)
  • Heap Fetches: 0
  • Buffers: local hit=3282
6. 340.620 561.079 ↑ 1.0 855,662 1

Hash (cost=26,027.36..26,027.36 rows=855,662 width=10) (actual time=561.079..561.079 rows=855,662 loops=1)

  • Output: kwois.idkey, kwois.objectid, kwois.objectkind
  • Buckets: 1048576 Batches: 1 Memory Usage: 43288kB
  • Buffers: local hit=5 read=3277
7. 220.459 220.459 ↑ 1.0 855,662 1

Index Only Scan using idx_kb_work_objectids_objectid_objectkind_idkey on pg_temp_5.kb_work_objectids kwois (cost=0.42..26,027.36 rows=855,662 width=10) (actual time=0.032..220.459 rows=855,662 loops=1)

  • Output: kwois.idkey, kwois.objectid, kwois.objectkind
  • Heap Fetches: 0
  • Buffers: local hit=5 read=3277