explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IpxA

Settings
# exclusive inclusive rows x rows loops node
1. 3.507 85.133 ↑ 12.1 299 1

Hash Full Join (cost=2,652.19..3,529.07 rows=3,616 width=136) (actual time=74.243..85.133 rows=299 loops=1)

  • Hash Cond: (block_seek_pos_1.bidx = block_seek_pos.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. 3.011 49.246 ↓ 2.3 6,692 1

Hash Join (cost=911.61..1,731.93 rows=2,960 width=101) (actual time=41.819..49.246 rows=6,692 loops=1)

  • Hash Cond: (block_seek_pos_1.sbid = "ANY_subquery_1".max)
3. 9.246 9.246 ↓ 1.1 6,763 1

Seq Scan on block_seek_pos block_seek_pos_1 (cost=0.00..771.85 rows=5,920 width=101) (actual time=4.797..9.246 rows=6,763 loops=1)

  • Filter: ((schid <= 1) AND (sbid > 0) AND (isdel >= 0) AND (icid <= 1) AND (sbid > 0) AND ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text))
  • Rows Removed by Filter: 7,191
4. 1.579 36.989 ↓ 33.5 6,692 1

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

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

HashAggregate (cost=907.11..909.11 rows=200 width=8) (actual time=15.747..35.410 rows=6,692 loops=1)

  • Group Key: "ANY_subquery_1".max
6. 0.728 12.962 ↓ 1.4 6,692 1

Subquery Scan on ANY_subquery_1 (cost=801.45..895.37 rows=4,696 width=8) (actual time=10.459..12.962 rows=6,692 loops=1)

7. 3.958 12.234 ↓ 1.4 6,692 1

HashAggregate (cost=801.45..848.41 rows=4,696 width=16) (actual time=10.458..12.234 rows=6,692 loops=1)

  • Group Key: block_seek_pos_2.bidx
8. 8.276 8.276 ↓ 1.1 6,763 1

Seq Scan on block_seek_pos block_seek_pos_2 (cost=0.00..771.85 rows=5,920 width=16) (actual time=4.346..8.276 rows=6,763 loops=1)

  • Filter: ((schid <= 1) AND (sbid > 0) AND (isdel >= 0) AND (icid <= 1) AND (sbid > 0) AND ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text))
  • Rows Removed by Filter: 7,191
9. 3.514 32.380 ↓ 1.9 6,692 1

Hash (cost=1,695.38..1,695.38 rows=3,616 width=101) (actual time=32.380..32.380 rows=6,692 loops=1)

  • Buckets: 8,192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 960kB
10. 3.562 28.866 ↓ 1.9 6,692 1

Hash Join (cost=899.20..1,695.38 rows=3,616 width=101) (actual time=17.020..28.866 rows=6,692 loops=1)

  • Hash Cond: (block_seek_pos.sbid = "ANY_subquery".max)
11. 8.368 8.368 ↑ 1.1 6,872 1

Seq Scan on block_seek_pos (cost=0.00..736.96 rows=7,233 width=101) (actual time=0.071..8.368 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
12. 1.263 16.936 ↓ 33.5 6,692 1

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

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

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

  • Group Key: "ANY_subquery".max
14. 0.491 12.853 ↓ 1.2 6,692 1

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

15. 3.708 12.362 ↓ 1.2 6,692 1

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

  • Group Key: block_seek_pos_3.bidx
16. 8.654 8.654 ↑ 1.1 6,872 1

Seq Scan on block_seek_pos block_seek_pos_3 (cost=0.00..736.96 rows=7,233 width=16) (actual time=0.012..8.654 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
Planning time : 1.034 ms
Execution time : 86.288 ms