explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kP5r

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

HashSetOp Except (cost=0.00..1,339.31 rows=5,036 width=12) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

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

3. 0.000 0.000 ↓ 0.0

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

4. 0.000 0.000 ↓ 0.0

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

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

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

6. 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,872 width=8) (actual rows= loops=)

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)