explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hQmv

Settings
# exclusive inclusive rows x rows loops node
1. 0.941 69.132 ↑ 11.1 297 1

Hash Join (cost=3,188.74..3,413.79 rows=3,311 width=98) (actual time=66.603..69.132 rows=297 loops=1)

  • Hash Cond: ((max(block_seek_pos_2.sbid)) = block_seek_pos.sbid)
2. 6.044 16.380 ↓ 1.2 6,692 1

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

  • Group Key: block_seek_pos_2.bidx
3. 10.336 10.336 ↑ 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.037..10.336 rows=6,872 loops=1)

  • Filter: ((sbid > 0) AND (schid <= 3) AND ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text))
  • Rows Removed by Filter: 7,082
4. 0.255 51.811 ↑ 8.4 544 1

Hash (cost=2,427.34..2,427.34 rows=4,577 width=98) (actual time=51.811..51.811 rows=544 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 141kB
5. 4.200 51.556 ↑ 8.4 544 1

Hash Join (cost=1,649.42..2,427.34 rows=4,577 width=98) (actual time=44.112..51.556 rows=544 loops=1)

  • Hash Cond: (block_seek_pos.bidx = block_seek_pos_1.bidx)
  • Join Filter: ((block_seek_pos_1.block_chksum)::text <> (block_seek_pos.block_chksum)::text)
  • Rows Removed by Join Filter: 6,619
6. 26.851 26.851 ↑ 1.1 7,169 1

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

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

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

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

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

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

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

  • Group Key: block_seek_pos_3.bidx
10. 4.081 4.081 ↓ 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=1.917..4.081 rows=6,763 loops=1)

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

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

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

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