explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H51c : good except

Settings
# exclusive inclusive rows x rows loops node
1. 2.065 5.313 ↑ 1.2 6,802 1

HashSetOp Except (cost=0.00..1,624.68 rows=8,205 width=8) (actual time=4.834..5.313 rows=6,802 loops=1)

2. 0.791 3.248 ↑ 4.0 9,608 1

Append (cost=0.00..1,527.52 rows=38,861 width=8) (actual time=0.004..3.248 rows=9,608 loops=1)

3. 0.902 1.903 ↑ 1.0 8,205 1

Subquery Scan on *SELECT* 1 (cost=0.00..241.10 rows=8,205 width=8) (actual time=0.004..1.903 rows=8,205 loops=1)

4. 1.001 1.001 ↑ 1.0 8,205 1

Seq Scan on weather (cost=0.00..159.05 rows=8,205 width=4) (actual time=0.003..1.001 rows=8,205 loops=1)

5. 0.145 0.554 ↑ 21.9 1,403 1

Subquery Scan on *SELECT* 2 (cost=0.00..1,092.12 rows=30,656 width=8) (actual time=0.003..0.554 rows=1,403 loops=1)

6. 0.409 0.409 ↑ 21.9 1,403 1

Seq Scan on fire_weather (cost=0.00..785.56 rows=30,656 width=4) (actual time=0.002..0.409 rows=1,403 loops=1)

Planning time : 0.246 ms
Execution time : 5.897 ms