explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HUF9

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1.320 ↓ 2.0 2 1

Nested Loop (cost=0.28..191.10 rows=1 width=459) (actual time=0.923..1.320 rows=2 loops=1)

2. 1.305 1.305 ↓ 2.0 2 1

Seq Scan on objects (cost=0.00..182.80 rows=1 width=89) (actual time=0.914..1.305 rows=2 loops=1)

  • Filter: ((name)::text = 'Welse'::text)
  • Rows Removed by Filter: 6542
3. 0.010 0.010 ↑ 1.0 1 2

Index Scan using img_pkey on img (cost=0.28..8.29 rows=1 width=374) (actual time=0.004..0.005 rows=1 loops=2)

  • Index Cond: ((object_id)::integer = (objects.object_id)::integer)