explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3CbFw

Settings
# exclusive inclusive rows x rows loops node
1. 66,730.590 93,197.171 ↓ 0.0 0 1

Update on pg_temp_13.tmp_scopeaccbook (cost=2,291,990.04..2,627,161.03 rows=1 width=52) (actual time=93,197.171..93,197.171 rows=0 loops=1)

  • Buffers: shared read=64733, local hit=1232475 read=1075456 dirtied=1029931 written=1029930, temp read=67264 written=88596
2. 3,773.104 26,466.581 ↓ 1,117,154.0 1,117,154 1

Merge Join (cost=2,291,990.04..2,627,161.03 rows=1 width=52) (actual time=18,886.871..26,466.581 rows=1,117,154 loops=1)

  • Output: tmp_scopeaccbook.idacc, tmp_scopeaccbook.bookmode, tmp_scopeaccbook.info1, tmp_scopeaccbook.info2, tmp_scopeaccbook.info3, tmp_scopeaccbook.info4, tmp_scopeaccbook.prop, tmp_scopeaccbook.blkno, tmp_scopeaccbook.isprototype, 1, tmp_scopeaccbook.ctid, ab.ctid
  • Merge Cond: ((ab.idacc = tmp_scopeaccbook.idacc) AND (ab.bookmode = tmp_scopeaccbook.bookmode) AND (ab.info1 = tmp_scopeaccbook.info1) AND (ab.info2 = tmp_scopeaccbook.info2) AND (ab.info3 = tmp_scopeaccbook.info3) AND (ab.info4 = tmp_scopeaccbook.info4) AND (ab.prop = tmp_scopeaccbook.prop) AND (ab.blkno = tmp_scopeaccbook.blkno))
  • Buffers: shared read=64733, local read=45696 written=4093, temp read=67264 written=88596
3. 8,620.732 14,228.532 ↑ 1.0 8,803,569 1

Sort (cost=1,408,987.55..1,430,996.77 rows=8,803,688 width=38) (actual time=11,549.064..14,228.532 rows=8,803,569 loops=1)

  • Output: ab.ctid, ab.idacc, ab.bookmode, ab.info1, ab.info2, ab.info3, ab.info4, ab.prop, ab.blkno
  • Sort Key: ab.idacc, ab.bookmode, ab.info1, ab.info2, ab.info3, ab.info4, ab.prop, ab.blkno
  • Sort Method: external merge Disk: 429912kB
  • Buffers: shared read=64733, temp read=53768 written=53768
4. 5,607.800 5,607.800 ↑ 1.0 8,803,569 1

Seq Scan on castoncast_local.accbook ab (cost=0.00..152,769.88 rows=8,803,688 width=38) (actual time=1.186..5,607.800 rows=8,803,569 loops=1)

  • Output: ab.ctid, ab.idacc, ab.bookmode, ab.info1, ab.info2, ab.info3, ab.info4, ab.prop, ab.blkno
  • Buffers: shared read=64733
5. 342.630 8,464.945 ↑ 3.5 1,564,209 1

Materialize (cost=883,002.49..910,420.09 rows=5,483,520 width=42) (actual time=7,086.972..8,464.945 rows=1,564,209 loops=1)

  • Output: tmp_scopeaccbook.idacc, tmp_scopeaccbook.bookmode, tmp_scopeaccbook.info1, tmp_scopeaccbook.info2, tmp_scopeaccbook.info3, tmp_scopeaccbook.info4, tmp_scopeaccbook.prop, tmp_scopeaccbook.blkno, tmp_scopeaccbook.isprototype, tmp_scopeaccbook.ctid
  • Buffers: local read=45696 written=4093, temp read=13496 written=34828
6. 6,105.054 8,122.315 ↑ 3.5 1,564,209 1

Sort (cost=883,002.49..896,711.29 rows=5,483,520 width=42) (actual time=7,086.951..8,122.315 rows=1,564,209 loops=1)

  • Output: tmp_scopeaccbook.idacc, tmp_scopeaccbook.bookmode, tmp_scopeaccbook.info1, tmp_scopeaccbook.info2, tmp_scopeaccbook.info3, tmp_scopeaccbook.info4, tmp_scopeaccbook.prop, tmp_scopeaccbook.blkno, tmp_scopeaccbook.isprototype, tmp_scopeaccbook.ctid
  • Sort Key: tmp_scopeaccbook.idacc, tmp_scopeaccbook.bookmode, tmp_scopeaccbook.info1, tmp_scopeaccbook.info2, tmp_scopeaccbook.info3, tmp_scopeaccbook.info4, tmp_scopeaccbook.prop, tmp_scopeaccbook.blkno
  • Sort Method: external merge Disk: 278488kB
  • Buffers: local read=45696 written=4093, temp read=13496 written=34828
7. 2,017.261 2,017.261 ↑ 1.0 5,483,422 1

Seq Scan on pg_temp_13.tmp_scopeaccbook (cost=0.00..100,531.20 rows=5,483,520 width=42) (actual time=4.128..2,017.261 rows=5,483,422 loops=1)

  • Output: tmp_scopeaccbook.idacc, tmp_scopeaccbook.bookmode, tmp_scopeaccbook.info1, tmp_scopeaccbook.info2, tmp_scopeaccbook.info3, tmp_scopeaccbook.info4, tmp_scopeaccbook.prop, tmp_scopeaccbook.blkno, tmp_scopeaccbook.isprototype, tmp_scopeaccbook.ctid
  • Buffers: local read=45696 written=4093