explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NwHC

Settings
# exclusive inclusive rows x rows loops node
1. 3.616 20.137 ↑ 4,939.0 1 1

HashSetOp Except (cost=613.29..1,416.66 rows=4,939 width=12) (actual time=20.039..20.137 rows=1 loops=1)

2. 0.872 16.521 ↓ 1.1 13,862 1

Append (cost=613.29..1,385.35 rows=12,524 width=12) (actual time=6.018..16.521 rows=13,862 loops=1)

3. 0.639 8.116 ↓ 1.4 6,693 1

Subquery Scan on *SELECT* 1 (cost=613.29..712.07 rows=4,939 width=12) (actual time=6.017..8.116 rows=6,693 loops=1)

4. 4.073 7.477 ↓ 1.4 6,693 1

HashAggregate (cost=613.29..662.68 rows=4,939 width=8) (actual time=6.015..7.477 rows=6,693 loops=1)

  • Group Key: block_seek_pos.bidx
5. 3.404 3.404 ↓ 1.1 6,765 1

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

  • Filter: ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text)
  • Rows Removed by Filter: 7,189
6. 0.993 7.533 ↑ 1.1 7,169 1

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

7. 6.540 6.540 ↑ 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.049..6.540 rows=7,169 loops=1)

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