explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rzs

Settings
# exclusive inclusive rows x rows loops node
1. 4.028 75.524 ↑ 18.3 299 1

Hash Full Join (cost=3,080.29..3,505.83 rows=5,482 width=98) (actual time=65.034..75.524 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. 3.924 48.695 ↓ 1.2 6,692 1

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

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

HashAggregate (cost=687.92..742.84 rows=5,492 width=16) (actual time=12.477..15.189 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.072 9.072 ↑ 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.047..9.072 rows=6,876 loops=1)

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

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

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

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

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

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

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

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

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

HashAggregate (cost=645.03..694.42 rows=4,939 width=16) (actual time=6.554..9.014 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. 3.585 3.585 ↓ 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=1.718..3.585 rows=6,765 loops=1)

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

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 646kB
12. 6.171 6.171 ↓ 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=2.069..6.171 rows=6,763 loops=1)

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