explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lhOW

Settings
# exclusive inclusive rows x rows loops node
1. 3.229 15.108 ↑ 4,939.0 1 1

HashSetOp Except (cost=0.00..1,369.00 rows=4,939 width=12) (actual time=14.952..15.108 rows=1 loops=1)

2. 0.762 11.879 ↓ 1.0 13,934 1

Append (cost=0.00..1,334.17 rows=13,932 width=12) (actual time=1.668..11.879 rows=13,934 loops=1)

3. 0.786 5.389 ↓ 1.1 6,765 1

Subquery Scan on *SELECT* 1 (cost=0.00..660.89 rows=6,347 width=12) (actual time=1.668..5.389 rows=6,765 loops=1)

4. 4.603 4.603 ↓ 1.1 6,765 1

Seq Scan on block_seek_pos (cost=0.00..597.42 rows=6,347 width=8) (actual time=1.666..4.603 rows=6,765 loops=1)

  • Filter: ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text)
  • Rows Removed by Filter: 7,189
5. 0.764 5.728 ↑ 1.1 7,169 1

Subquery Scan on *SELECT* 2 (cost=0.00..673.27 rows=7,585 width=12) (actual time=0.039..5.728 rows=7,169 loops=1)

6. 4.964 4.964 ↑ 1.1 7,169 1

Seq Scan on block_seek_pos block_seek_pos_1 (cost=0.00..597.42 rows=7,585 width=8) (actual time=0.038..4.964 rows=7,169 loops=1)

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)
  • Rows Removed by Filter: 6,785
Planning time : 0.424 ms
Execution time : 15.183 ms