explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gyGb

Settings
# exclusive inclusive rows x rows loops node
1. 3.529 81.129 ↑ 12.1 299 1

Hash Full Join (cost=2,652.19..3,529.07 rows=3,616 width=136) (actual time=70.310..81.129 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.059 28.467 ↓ 2.3 6,692 1

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

  • Hash Cond: (block_seek_pos_1.sbid = "ANY_subquery_1".max)
3. 7.870 7.870 ↓ 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=3.536..7.870 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.057 17.538 ↓ 33.5 6,692 1

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

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

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

  • Group Key: "ANY_subquery_1".max
6. 0.467 13.452 ↓ 1.4 6,692 1

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

7. 4.377 12.985 ↓ 1.4 6,692 1

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

  • Group Key: block_seek_pos_2.bidx
8. 8.608 8.608 ↓ 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=3.410..8.608 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.117 49.133 ↓ 1.9 6,692 1

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

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

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

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

Seq Scan on block_seek_pos (cost=0.00..736.96 rows=7,233 width=101) (actual time=0.046..7.421 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.092 35.682 ↓ 33.5 6,692 1

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

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

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

  • Group Key: "ANY_subquery".max
14. 17.808 30.875 ↓ 1.2 6,692 1

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

15. 4.478 13.067 ↓ 1.2 6,692 1

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

  • Group Key: block_seek_pos_3.bidx
16. 8.589 8.589 ↑ 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.027..8.589 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.469 ms
Execution time : 82.159 ms