explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qur3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,847.84..3,111.99 rows=3,831 width=49) (actual rows= loops=)

  • Hash Cond: (matvw_block_seek_pos.bidx = matvw_block_seek_pos_1.bidx)
  • Join Filter: ((matvw_block_seek_pos_1.block_chksum)::text <> (matvw_block_seek_pos.block_chksum)::text)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,289.14..1,467.24 rows=5,088 width=41) (actual rows= loops=)

  • Hash Cond: ((max(matvw_block_seek_pos_2.sbid)) = matvw_block_seek_pos.sbid)
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=618.80..669.69 rows=5,089 width=16) (actual rows= loops=)

  • Group Key: matvw_block_seek_pos_2.bidx
4. 0.000 0.000 ↓ 0.0

Seq Scan on matvw_block_seek_pos matvw_block_seek_pos_2 (cost=0.00..584.44 rows=6,872 width=16) (actual rows= loops=)

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)
5. 0.000 0.000 ↓ 0.0

Hash (cost=584.44..584.44 rows=6,872 width=49) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on matvw_block_seek_pos (cost=0.00..584.44 rows=6,872 width=49) (actual rows= loops=)

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)
7. 0.000 0.000 ↓ 0.0

Hash (cost=1,496.77..1,496.77 rows=4,955 width=49) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,321.32..1,496.77 rows=4,955 width=49) (actual rows= loops=)

  • Hash Cond: ((max(matvw_block_seek_pos_3.sbid)) = matvw_block_seek_pos_1.sbid)
9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=652.34..702.70 rows=5,036 width=16) (actual rows= loops=)

  • Group Key: matvw_block_seek_pos_3.bidx
10. 0.000 0.000 ↓ 0.0

Seq Scan on matvw_block_seek_pos matvw_block_seek_pos_3 (cost=0.00..618.52 rows=6,763 width=16) (actual rows= loops=)

  • Filter: ((sbid > 0) AND ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text))
11. 0.000 0.000 ↓ 0.0

Hash (cost=584.44..584.44 rows=6,763 width=49) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on matvw_block_seek_pos matvw_block_seek_pos_1 (cost=0.00..584.44 rows=6,763 width=49) (actual rows= loops=)

  • Filter: ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text)