explain.depesz.com

PostgreSQL's explain analyze made readable

Result: svbd

Settings
# exclusive inclusive rows x rows loops node
1. 6,236.701 591,976.984 ↓ 0.0 0 1

Insert on pg_temp_9.kb_work_linkids (cost=147,572.60..784,180.11 rows=1 width=20) (actual time=591,976.984..591,976.984 rows=0 loops=1)

  • Buffers: shared hit=2 read=20,136, local hit=1,069,906,734 read=96,753 dirtied=36,596 written=34,257, temp read=33,721 written=33,715
2. 220,509.228 585,740.283 ↓ 6,770,120.0 6,770,120 1

Nested Loop (cost=147,572.60..784,180.11 rows=1 width=20) (actual time=2,260.365..585,740.283 rows=6,770,120 loops=1)

  • Output: al.linkid, 'S'::character(1), 0, a.idacc
  • Join Filter: (a.idclr = kwoir.idkey)
  • Rows Removed by Join Filter: 258,011,070
  • Buffers: shared hit=2 read=20,136, local hit=1,063,063,435 read=60,147 written=12,465, temp read=33,721 written=33,715
3. 90,810.941 100,449.865 ↓ 876,758.9 264,781,190 1

Hash Join (cost=147,572.18..784,043.12 rows=302 width=18) (actual time=2,260.325..100,449.865 rows=264,781,190 loops=1)

  • Output: al.linkid, al.callerid, al.callerkind, a.idacc, a.idclr
  • Hash Cond: ((al.projectid = kwsop.objectid) AND (al.projectkind = kwsop.objectkind) AND (kwoie.idkey = a.idcle))
  • Buffers: shared hit=2 read=20,136, local hit=1,262 read=51,390 written=7,290, temp read=33,721 written=33,715
4. 5,451.641 7,507.603 ↓ 1.0 6,817,302 1

Hash Join (cost=7,096.05..244,415.40 rows=6,787,657 width=20) (actual time=122.738..7,507.603 rows=6,817,302 loops=1)

  • Output: al.linkid, al.callerid, al.callerkind, al.projectid, al.projectkind, kwoie.idkey
  • Hash Cond: ((al.calleeid = kwoie.objectid) AND (al.calleekind = kwoie.objectkind))
  • Buffers: local hit=3 read=51,390 written=7,290
5. 1,934.859 1,934.859 ↑ 1.0 6,817,750 1

Seq Scan on pg_temp_9.amt_links al (cost=0.00..118,309.16 rows=6,817,816 width=22) (actual time=0.044..1,934.859 rows=6,817,750 loops=1)

  • Output: al.linkid, al.callerid, al.callerkind, al.calleeid, al.calleekind, al.projectid, al.projectkind, al.linktypeid
  • Buffers: local read=50,131 written=7,290
6. 68.995 121.103 ↑ 1.0 233,362 1

Hash (cost=3,595.62..3,595.62 rows=233,362 width=10) (actual time=121.103..121.103 rows=233,362 loops=1)

  • Output: kwoie.objectid, kwoie.objectkind, kwoie.idkey
  • Buckets: 262,144 Batches: 1 Memory Usage: 12,076kB
  • Buffers: local hit=3 read=1,259
7. 52.108 52.108 ↑ 1.0 233,362 1

Seq Scan on pg_temp_9.kb_work_objectids kwoie (cost=0.00..3,595.62 rows=233,362 width=10) (actual time=0.039..52.108 rows=233,362 loops=1)

  • Output: kwoie.objectid, kwoie.objectkind, kwoie.idkey
  • Buffers: local hit=3 read=1,259
8. 655.844 2,131.321 ↑ 1.4 1,691,776 1

Hash (cost=84,027.33..84,027.33 rows=2,416,503 width=18) (actual time=2,131.321..2,131.321 rows=1,691,776 loops=1)

  • Output: kwsop.objectid, kwsop.objectkind, a.idacc, a.idclr, a.idcle
  • Buckets: 1,048,576 Batches: 4 Memory Usage: 29,571kB
  • Buffers: shared hit=2 read=20,136, local hit=1,259, temp written=6,203
9. 661.087 1,475.477 ↑ 1.4 1,691,776 1

Hash Join (cost=6,497.38..84,027.33 rows=2,416,503 width=18) (actual time=149.829..1,475.477 rows=1,691,776 loops=1)

  • Output: kwsop.objectid, kwsop.objectkind, a.idacc, a.idclr, a.idcle
  • Hash Cond: (a.idpro = kwsop.idobj)
  • Buffers: shared hit=2 read=20,136, local hit=1,259
10. 728.007 728.007 ↑ 1.0 2,416,503 1

Seq Scan on diw_castoncast_local.acc a (cost=0.00..44,303.03 rows=2,416,503 width=16) (actual time=0.032..728.007 rows=2,416,503 loops=1)

  • Output: a.idacc, a.idclr, a.idcle, a.acctyplo, a.acctyphi, a.acctyplo2, a.acctyphi2, a.accknd, a.idpro, a.prop
  • Buffers: shared hit=2 read=20,136
11. 52.665 86.383 ↑ 1.0 232,817 1

Hash (cost=3,587.17..3,587.17 rows=232,817 width=10) (actual time=86.383..86.383 rows=232,817 loops=1)

  • Output: kwsop.objectid, kwsop.objectkind, kwsop.idobj
  • Buckets: 262,144 Batches: 1 Memory Usage: 12,052kB
  • Buffers: local hit=1,259
12. 33.718 33.718 ↑ 1.0 232,817 1

Seq Scan on pg_temp_9.kb_work_scopeobjects kwsop (cost=0.00..3,587.17 rows=232,817 width=10) (actual time=0.025..33.718 rows=232,817 loops=1)

  • Output: kwsop.objectid, kwsop.objectkind, kwsop.idobj
  • Buffers: local hit=1,259
13. 264,781.190 264,781.190 ↑ 1.0 1 264,781,190

Index Scan using idx_kb_work_objectids_objectid_objectkind on pg_temp_9.kb_work_objectids kwoir (cost=0.42..0.44 rows=1 width=10) (actual time=0.001..0.001 rows=1 loops=264,781,190)

  • Output: kwoir.objectid, kwoir.objectkind, kwoir.idkey, kwoir.objtyp
  • Index Cond: ((kwoir.objectid = al.callerid) AND (kwoir.objectkind = al.callerkind))
  • Buffers: local hit=1,063,062,173 read=8,757 written=5,175