explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OqYS

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 35.434 ↓ 0.0 0 1

Sort (cost=2,372.97..2,385.83 rows=5,142 width=198) (actual time=35.434..35.434 rows=0 loops=1)

  • Sort Key: matvw_block_seek_pos.sbid
  • Sort Method: quicksort Memory: 25kB
2. 3.912 35.416 ↓ 0.0 0 1

Hash Join (cost=1,453.82..2,056.02 rows=5,142 width=198) (actual time=35.416..35.416 rows=0 loops=1)

  • Hash Cond: (matvw_block_seek_pos.bidx = t1.bidx)
3. 11.623 11.623 ↑ 1.0 6,763 1

Seq Scan on matvw_block_seek_pos (cost=0.00..584.44 rows=6,763 width=198) (actual time=1.517..11.623 rows=6,763 loops=1)

  • Filter: ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text)
  • Rows Removed by Filter: 6,872
4. 0.014 19.881 ↑ 5,089.0 1 1

Hash (cost=1,390.20..1,390.20 rows=5,089 width=8) (actual time=19.881..19.881 rows=1 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 65kB
5. 0.003 19.867 ↑ 5,089.0 1 1

Subquery Scan on t1 (cost=0.00..1,390.20 rows=5,089 width=8) (actual time=19.817..19.867 rows=1 loops=1)

6. 4.394 19.864 ↑ 5,089.0 1 1

HashSetOp Except (cost=0.00..1,339.31 rows=5,089 width=12) (actual time=19.815..19.864 rows=1 loops=1)

7. 1.012 15.470 ↑ 1.0 13,635 1

Append (cost=0.00..1,305.22 rows=13,635 width=12) (actual time=0.027..15.470 rows=13,635 loops=1)

8. 0.765 5.585 ↑ 1.0 6,872 1

Subquery Scan on *SELECT* 1 (cost=0.00..653.16 rows=6,872 width=12) (actual time=0.027..5.585 rows=6,872 loops=1)

9. 4.820 4.820 ↑ 1.0 6,872 1

Seq Scan on matvw_block_seek_pos matvw_block_seek_pos_1 (cost=0.00..584.44 rows=6,872 width=8) (actual time=0.026..4.820 rows=6,872 loops=1)

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)
  • Rows Removed by Filter: 6,763
10. 1.325 8.873 ↑ 1.0 6,763 1

Subquery Scan on *SELECT* 2 (cost=0.00..652.07 rows=6,763 width=12) (actual time=2.398..8.873 rows=6,763 loops=1)

11. 7.548 7.548 ↑ 1.0 6,763 1

Seq Scan on matvw_block_seek_pos matvw_block_seek_pos_2 (cost=0.00..584.44 rows=6,763 width=8) (actual time=2.397..7.548 rows=6,763 loops=1)

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