explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aER

Settings
# exclusive inclusive rows x rows loops node
1. 0.367 0.731 ↑ 1.1 300 1

Sort (cost=73.30..74.13 rows=330 width=12) (actual time=0.613..0.731 rows=300 loops=1)

  • Sort Key: first
  • Sort Method: quicksort Memory: 39kB
2. 0.364 0.364 ↑ 1.1 300 1

Seq Scan on newtab (cost=0.00..59.50 rows=330 width=12) (actual time=0.014..0.364 rows=300 loops=1)

  • Filter: (id < 10000)
  • Rows Removed by Filter: 2700