explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nnbo

Settings
# exclusive inclusive rows x rows loops node
1. 4.835 85.614 ↑ 18.3 299 1

Hash Full Join (cost=3,080.29..3,505.83 rows=5,482 width=98) (actual time=72.828..85.614 rows=299 loops=1)

  • Hash Cond: (block_seek_pos.bidx = block_seek_pos_1.bidx)
  • Filter: ((block_seek_pos.bidx IS NULL) OR (block_seek_pos_1.bidx IS NULL) OR ((block_seek_pos_1.block_chksum)::text <> (block_seek_pos.block_chksum)::text))
  • Rows Removed by Filter: 6,394
2. 4.874 34.376 ↓ 1.2 6,692 1

Hash Join (cost=1,414.86..1,709.96 rows=5,483 width=49) (actual time=26.252..34.376 rows=6,692 loops=1)

  • Hash Cond: ((max(block_seek_pos_2.sbid)) = block_seek_pos.sbid)
3. 7.717 17.047 ↓ 1.2 6,692 1

HashAggregate (cost=687.92..742.84 rows=5,492 width=16) (actual time=13.720..17.047 rows=6,692 loops=1)

  • Group Key: block_seek_pos_2.bidx
  • Filter: (max(block_seek_pos_2.sbid) > 0)
  • Rows Removed by Filter: 1
4. 9.330 9.330 ↑ 1.1 6,876 1

Seq Scan on block_seek_pos block_seek_pos_2 (cost=0.00..632.31 rows=7,415 width=16) (actual time=0.056..9.330 rows=6,876 loops=1)

  • Filter: ((schid <= 3) AND ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text))
  • Rows Removed by Filter: 7,078
5. 3.267 12.455 ↑ 1.1 7,164 1

Hash (cost=632.31..632.31 rows=7,570 width=49) (actual time=12.455..12.455 rows=7,164 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 680kB
6. 9.188 9.188 ↑ 1.1 7,164 1

Seq Scan on block_seek_pos (cost=0.00..632.31 rows=7,570 width=49) (actual time=0.068..9.188 rows=7,164 loops=1)

  • Filter: ((sbid > 0) AND ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text))
  • Rows Removed by Filter: 6,790
7. 1.978 46.403 ↓ 1.6 6,692 1

Hash (cost=1,613.85..1,613.85 rows=4,126 width=49) (actual time=46.403..46.403 rows=6,692 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 594kB
8. 3.241 44.425 ↓ 1.6 6,692 1

Hash Join (cost=1,356.51..1,613.85 rows=4,126 width=49) (actual time=39.208..44.425 rows=6,692 loops=1)

  • Hash Cond: ((max(block_seek_pos_3.sbid)) = block_seek_pos_1.sbid)
9. 5.334 28.938 ↓ 1.4 6,692 1

HashAggregate (cost=645.03..694.42 rows=4,939 width=16) (actual time=26.911..28.938 rows=6,692 loops=1)

  • Group Key: block_seek_pos_3.bidx
  • Filter: (max(block_seek_pos_3.sbid) > 0)
  • Rows Removed by Filter: 1
10. 23.604 23.604 ↓ 1.1 6,765 1

Seq Scan on block_seek_pos block_seek_pos_3 (cost=0.00..597.42 rows=6,347 width=16) (actual time=21.748..23.604 rows=6,765 loops=1)

  • Filter: ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text)
  • Rows Removed by Filter: 7,189
11. 3.009 12.246 ↓ 1.1 6,763 1

Hash (cost=632.31..632.31 rows=6,334 width=49) (actual time=12.246..12.246 rows=6,763 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 646kB
12. 9.237 9.237 ↓ 1.1 6,763 1

Seq Scan on block_seek_pos block_seek_pos_1 (cost=0.00..632.31 rows=6,334 width=49) (actual time=3.152..9.237 rows=6,763 loops=1)

  • Filter: ((sbid > 0) AND ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text))
  • Rows Removed by Filter: 7,191
Planning time : 2.129 ms
Execution time : 86.133 ms