explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ObNT : Example plan for psql borders

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

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

2. 0.082 0.082 ↑ 1.0 1 1

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

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

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

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