explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vlsF

Settings
# exclusive inclusive rows x rows loops node
1. 3.151 114.455 ↑ 5.9 297 1

Hash Join (cost=2,300.60..3,029.52 rows=1,759 width=136) (actual time=101.684..114.455 rows=297 loops=1)

  • Hash Cond: (block_seek_pos.bidx = block_seek_pos_1.bidx)
  • Join Filter: ((block_seek_pos.block_chksum)::text <> (block_seek_pos_1.block_chksum)::text)
  • Rows Removed by Join Filter: 6,394
2. 4.541 36.123 ↓ 1.8 6,692 1

Hash Join (cost=832.08..1,491.60 rows=3,792 width=101) (actual time=26.434..36.123 rows=6,692 loops=1)

  • Hash Cond: (block_seek_pos.sbid = "ANY_subquery".max)
3. 5.226 5.226 ↑ 1.1 7,169 1

Seq Scan on block_seek_pos (cost=0.00..597.42 rows=7,585 width=101) (actual time=0.038..5.226 rows=7,169 loops=1)

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)
  • Rows Removed by Filter: 6,785
4. 1.911 26.356 ↓ 33.5 6,692 1

Hash (cost=829.58..829.58 rows=200 width=8) (actual time=26.356..26.356 rows=6,692 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 326kB
5. 5.998 24.445 ↓ 33.5 6,692 1

HashAggregate (cost=827.58..829.58 rows=200 width=8) (actual time=22.421..24.445 rows=6,692 loops=1)

  • Group Key: "ANY_subquery".max
6. 0.899 18.447 ↓ 1.2 6,692 1

Subquery Scan on ANY_subquery (cost=704.19..813.87 rows=5,484 width=8) (actual time=14.645..18.447 rows=6,692 loops=1)

7. 7.467 17.548 ↓ 1.2 6,692 1

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

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

  • Filter: ((schid <= 3) AND (sbid > 0) AND ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text))
  • Rows Removed by Filter: 7,082
9. 5.193 75.181 ↓ 2.1 6,692 1

Hash (cost=1,428.85..1,428.85 rows=3,174 width=101) (actual time=75.181..75.181 rows=6,692 loops=1)

  • Buckets: 8,192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 960kB
10. 6.021 69.988 ↓ 2.1 6,692 1

Hash Join (cost=779.45..1,428.85 rows=3,174 width=101) (actual time=60.558..69.988 rows=6,692 loops=1)

  • Hash Cond: (block_seek_pos_1.sbid = "ANY_subquery_1".max)
11. 5.880 5.880 ↓ 1.1 6,765 1

Seq Scan on block_seek_pos block_seek_pos_1 (cost=0.00..597.42 rows=6,347 width=101) (actual time=2.425..5.880 rows=6,765 loops=1)

  • Filter: ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text)
  • Rows Removed by Filter: 7,189
12. 2.018 58.087 ↓ 33.5 6,692 1

Hash (cost=776.95..776.95 rows=200 width=8) (actual time=58.087..58.087 rows=6,692 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 326kB
13. 5.595 56.069 ↓ 33.5 6,692 1

HashAggregate (cost=774.95..776.95 rows=200 width=8) (actual time=54.290..56.069 rows=6,692 loops=1)

  • Group Key: "ANY_subquery_1".max
14. 0.899 50.474 ↓ 1.4 6,692 1

Subquery Scan on ANY_subquery_1 (cost=663.98..762.62 rows=4,932 width=8) (actual time=46.915..50.474 rows=6,692 loops=1)

15. 8.194 49.575 ↓ 1.4 6,692 1

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

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

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