explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BDki

Settings
# exclusive inclusive rows x rows loops node
1. 0.065 7,486.476 ↑ 1.0 132 1

Aggregate (cost=244,379..244,380.32 rows=132 width=8) (actual time=7,486.466..7,486.476 rows=132 loops=1)

2. 7,160.051 7,486.411 ↑ 455.1 152 1

Nested Loop (cost=0..244,206.05 rows=69,181 width=8) (actual time=0.034..7,486.411 rows=152 loops=1)

3. 11.900 11.900 ↑ 1.0 104,820 1

Seq Scan on invmanufacturer invmanufacturer (cost=0..2,069.2 rows=104,820 width=39) (actual time=0.007..11.9 rows=104,820 loops=1)

4. 314.450 314.460 ↑ 1.0 132 104,820

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

5. 0.010 0.010 ↑ 1.0 132 1

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

Planning time : 0.126 ms
Execution time : 7,486.517 ms