explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q0H7 : Example plan for psql borders

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 2.759 ↑ 1.0 15 1

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

2. 0.079 0.079 ↑ 1.0 1 1

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

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

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

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