explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oAjd : Example plan for psql borders

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2.219 ↑ 1.0 15 1

Nested Loop (cost=0.00..2,017.80 rows=15 width=133) (actual time=0.035..2.219 rows=15 loops=1)

2. 0.091 0.091 ↑ 1.0 1 1

Seq Scan on users u (cost=0.00..41.40 rows=1 width=129) (actual time=0.013..0.091 rows=1 loops=1)

  • Filter: (username = 'depesz'::text)
  • Rows Removed by Filter: 1,231
3. 2.125 2.125 ↑ 1.0 15 1

Seq Scan on part_0 p (cost=0.00..1,976.25 rows=15 width=17) (actual time=0.021..2.125 rows=15 loops=1)

  • Filter: (added_by = 'depesz'::text)
  • Rows Removed by Filter: 13,205
Planning time : 0.040 ms
Execution time : 2.228 ms