explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2DpA

Settings
# exclusive inclusive rows x rows loops node
1. 2.924 89.248 ↑ 12.9 297 1

Hash Join (cost=2,847.84..3,111.99 rows=3,831 width=49) (actual time=80.889..89.248 rows=297 loops=1)

  • 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)
  • Rows Removed by Join Filter: 6,394
2. 3.353 29.508 ↓ 1.3 6,692 1

Hash Join (cost=1,289.14..1,467.24 rows=5,088 width=41) (actual time=23.912..29.508 rows=6,692 loops=1)

  • Hash Cond: ((max(matvw_block_seek_pos_2.sbid)) = matvw_block_seek_pos.sbid)
3. 7.917 13.870 ↓ 1.3 6,692 1

HashAggregate (cost=618.80..669.69 rows=5,089 width=16) (actual time=11.544..13.870 rows=6,692 loops=1)

  • Group Key: matvw_block_seek_pos_2.bidx
4. 5.953 5.953 ↑ 1.0 6,872 1

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

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)
  • Rows Removed by Filter: 6,763
5. 3.496 12.285 ↑ 1.0 6,872 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 608kB
6. 8.789 8.789 ↑ 1.0 6,872 1

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

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)
  • Rows Removed by Filter: 6,763
7. 3.012 56.816 ↓ 1.4 6,692 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 594kB
8. 4.931 53.804 ↓ 1.4 6,692 1

Hash Join (cost=1,321.32..1,496.77 rows=4,955 width=49) (actual time=45.914..53.804 rows=6,692 loops=1)

  • Hash Cond: ((max(matvw_block_seek_pos_3.sbid)) = matvw_block_seek_pos_1.sbid)
9. 8.338 15.344 ↓ 1.3 6,692 1

HashAggregate (cost=652.34..702.70 rows=5,036 width=16) (actual time=12.306..15.344 rows=6,692 loops=1)

  • Group Key: matvw_block_seek_pos_3.bidx
10. 7.006 7.006 ↑ 1.0 6,763 1

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

  • Filter: ((sbid > 0) AND ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text))
  • Rows Removed by Filter: 6,872
11. 2.773 33.529 ↑ 1.0 6,763 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 646kB
12. 30.756 30.756 ↑ 1.0 6,763 1

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

  • Filter: ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text)
  • Rows Removed by Filter: 6,872
Planning time : 2.046 ms
Execution time : 89.875 ms