explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OBg2 : 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: created_date DESC
  • Sort Method: quicksort Memory: 26kB
2. 0.021 0.021 ↓ 1.1 9 1

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

  • Filter: ((quantity > '0'::numeric) AND (account_id = 125))
  • Rows Removed by Filter: 58
Planning time : 0.077 ms
Execution time : 0.063 ms