explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kQ7T

Settings
# exclusive inclusive rows x rows loops node
1. 5.645 23.625 ↑ 5,036.0 1 1

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

2. 1.391 17.980 ↑ 1.0 13,635 1

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

3. 1.077 8.264 ↑ 1.0 6,763 1

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

4. 7.187 7.187 ↑ 1.0 6,763 1

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

  • Filter: ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text)
  • Rows Removed by Filter: 6,872
5. 1.223 8.325 ↑ 1.0 6,872 1

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

6. 7.102 7.102 ↑ 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.048..7.102 rows=6,872 loops=1)

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)
  • Rows Removed by Filter: 6,763
Planning time : 0.397 ms
Execution time : 23.729 ms