explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SYRf : Example plan for psql borders

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

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

2. 0.077 0.077 ↑ 1.0 1 1

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

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

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

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