explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pl2g

Settings
# exclusive inclusive rows x rows loops node
1. 3.752 79.700 ↑ 12.1 299 1

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

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

  • Hash Cond: (block_seek_pos_1.sbid = "ANY_subquery_1".max)
3. 7.816 7.816 ↓ 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.541..7.816 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.067 15.783 ↓ 33.5 6,692 1

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

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

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

  • Group Key: "ANY_subquery_1".max
6. 0.507 11.692 ↓ 1.4 6,692 1

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

7. 3.850 11.185 ↓ 1.4 6,692 1

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

  • Group Key: block_seek_pos_2.bidx
8. 7.335 7.335 ↓ 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.482..7.335 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.403 49.012 ↓ 1.9 6,692 1

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

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

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

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

Seq Scan on block_seek_pos (cost=0.00..736.96 rows=7,233 width=101) (actual time=0.032..26.155 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.211 16.006 ↓ 33.5 6,692 1

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

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

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

  • Group Key: "ANY_subquery".max
14. 0.528 11.574 ↓ 1.2 6,692 1

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

15. 3.533 11.046 ↓ 1.2 6,692 1

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

  • Group Key: block_seek_pos_3.bidx
16. 7.513 7.513 ↑ 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.013..7.513 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.044 ms
Execution time : 80.826 ms