explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gTdo

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 4,407.500 ↓ 0.0 132 1

Aggregate (cost=0..0 rows=0 width=0) (actual time=4,407.491..4,407.5 rows=132 loops=1)

2. 3,968.985 4,407.453 ↓ 0.0 132 1

Nested Loop (cost=0..0 rows=0 width=0) (actual time=0.025..4,407.453 rows=132 loops=1)

3. 19.188 19.188 ↓ 0.0 104,820 1

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

4. 419.272 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.008 0.008 ↓ 0.0 132 1

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

Planning time : 0.107 ms
Execution time : 4,407.543 ms