explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0VFL

Settings
# exclusive inclusive rows x rows loops node
1. 4.588 99.765 ↑ 18.3 299 1

Hash Full Join (cost=3,045.85..3,471.18 rows=5,485 width=98) (actual time=87.956..99.765 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.743 63.910 ↓ 1.2 6,692 1

Hash Join (cost=1,396.43..1,691.21 rows=5,486 width=49) (actual time=56.516..63.910 rows=6,692 loops=1)

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

HashAggregate (cost=704.19..759.03 rows=5,484 width=16) (actual time=15.742..18.455 rows=6,692 loops=1)

  • Group Key: block_seek_pos_2.bidx
4. 11.102 11.102 ↑ 1.1 6,872 1

Seq Scan on block_seek_pos block_seek_pos_2 (cost=0.00..667.20 rows=7,399 width=16) (actual time=0.057..11.102 rows=6,872 loops=1)

  • Filter: ((sbid > 0) AND (schid <= 3) AND ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text))
  • Rows Removed by Filter: 7,082
5. 2.905 40.712 ↑ 1.1 7,169 1

Hash (cost=597.42..597.42 rows=7,585 width=49) (actual time=40.712..40.712 rows=7,169 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 681kB
6. 37.807 37.807 ↑ 1.1 7,169 1

Seq Scan on block_seek_pos (cost=0.00..597.42 rows=7,585 width=49) (actual time=0.056..37.807 rows=7,169 loops=1)

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)
  • Rows Removed by Filter: 6,785
7. 2.366 31.267 ↓ 1.6 6,692 1

Hash (cost=1,597.81..1,597.81 rows=4,129 width=49) (actual time=31.267..31.267 rows=6,692 loops=1)

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

Hash Join (cost=1,340.74..1,597.81 rows=4,129 width=49) (actual time=22.724..28.901 rows=6,692 loops=1)

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

HashAggregate (cost=663.98..713.30 rows=4,932 width=16) (actual time=11.802..14.111 rows=6,692 loops=1)

  • Group Key: block_seek_pos_3.bidx
10. 6.838 6.838 ↓ 1.1 6,763 1

Seq Scan on block_seek_pos block_seek_pos_3 (cost=0.00..632.31 rows=6,334 width=16) (actual time=3.043..6.838 rows=6,763 loops=1)

  • Filter: ((sbid > 0) AND ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text))
  • Rows Removed by Filter: 7,191
11. 2.724 10.870 ↓ 1.1 6,765 1

Hash (cost=597.42..597.42 rows=6,347 width=49) (actual time=10.870..10.870 rows=6,765 loops=1)

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

Seq Scan on block_seek_pos block_seek_pos_1 (cost=0.00..597.42 rows=6,347 width=49) (actual time=2.484..8.146 rows=6,765 loops=1)

  • Filter: ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text)
  • Rows Removed by Filter: 7,189
Planning time : 2.024 ms
Execution time : 100.283 ms