explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rBGW : performance explained

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 0.051 ↓ 1.1 9 1

Sort (cost=3.12..3.15 rows=8 width=45) (actual time=0.051..0.051 rows=9 loops=1)

  • Sort Key: alpha DESC
  • Sort Method: quicksort Memory: 26kB
2. 0.021 0.021 ↓ 1.1 9 1

Seq Scan on juliet (cost=0.00..3.00 rows=8 width=45) (actual time=0.014..0.021 rows=9 loops=1)

  • Filter: ((november_juliet > 'november_golf'::numeric) AND (kilo = 125))
  • Rows Removed by Filter: 58
Planning time : 0.077 ms
Execution time : 0.063 ms