explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZDAC

Settings
# exclusive inclusive rows x rows loops node
1. 5.025 89.315 ↑ 12.7 299 1

ash Full Join (cost=2,367.72..3,096.64 rows=3,791 width=136) (actual time=73.722..89.315 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.block_chksum)::text <> (block_seek_pos_1.block_chksum)::text))
  • Rows Removed by Filter: 6,394
2. 5.608 29.468 ↓ 1.8 6,692 1

Hash Join (cost=899.20..1,558.72 rows=3,792 width=101) (actual time=18.869..29.468 rows=6,692 loops=1)

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

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

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

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

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

HashAggregate (cost=894.70..896.70 rows=200 width=8) (actual time=15.167..16.881 rows=6,692 loops=1)

  • Group Key: "ANY_subquery".max
6. 0.532 12.500 ↓ 1.2 6,692 1

Subquery Scan on ANY_subquery (cost=773.13..881.19 rows=5,403 width=8) (actual time=10.237..12.500 rows=6,692 loops=1)

7. 4.240 11.968 ↓ 1.2 6,692 1

HashAggregate (cost=773.13..827.16 rows=5,403 width=16) (actual time=10.236..11.968 rows=6,692 loops=1)

  • Group Key: block_seek_pos_2.bidx
8. 7.728 7.728 ↑ 1.1 6,872 1

Seq Scan on block_seek_pos block_seek_pos_2 (cost=0.00..736.96 rows=7,233 width=16) (actual time=0.011..7.728 rows=6,872 loops=1)

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

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

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

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

  • Hash Cond: (block_seek_pos_1.sbid = "ANY_subquery_1".max)
11. 4.911 4.911 ↓ 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.493..4.911 rows=6,765 loops=1)

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

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

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

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

  • Group Key: "ANY_subquery_1".max
14. 0.877 35.288 ↓ 1.4 6,692 1

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

15. 28.057 34.411 ↓ 1.4 6,692 1

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

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

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