explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ryIb

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 5,192.550 ↓ 0.0 132 1

Aggregate (cost=0..0 rows=0 width=0) (actual time=5,192.541..5,192.55 rows=132 loops=1)

2. 4,750.646 5,192.504 ↓ 0.0 152 1

Nested Loop (cost=0..0 rows=0 width=0) (actual time=0.025..5,192.504 rows=152 loops=1)

3. 22.578 22.578 ↓ 0.0 104,820 1

Seq Scan on invmanufacturer invmanufacturer (cost=0..0 rows=0 width=0) (actual time=0.006..22.578 rows=104,820 loops=1)

4. 419.271 419.280 ↓ 0.0 132 104,820

Materialize (cost=0..0 rows=0 width=0) (actual time=0..0.004 rows=132 loops=104,820)

5. 0.009 0.009 ↓ 0.0 132 1

Seq Scan on vendorsearchvalue vendorsearchvalue (cost=0..0 rows=0 width=0) (actual time=0.003..0.009 rows=132 loops=1)

Planning time : 0.135 ms
Execution time : 5,192.589 ms