explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PR1N

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 4,261.939 ↑ 1.0 132 1

Aggregate (cost=209,789.4..209,790.72 rows=132 width=8) (actual time=4,261.931..4,261.939 rows=132 loops=1)

2. 3,831.303 4,261.904 ↑ 455.1 152 1

Nested Loop (cost=0..209,616.45 rows=69,181 width=8) (actual time=0.028..4,261.904 rows=152 loops=1)

3. 11.321 11.321 ↑ 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.321 rows=104,820 loops=1)

4. 419.272 419.280 ↑ 1.0 132 104,820

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

5. 0.008 0.008 ↑ 1.0 132 1

Seq Scan on vendorsearch3 vendorsearch3 (cost=0..3.32 rows=132 width=16) (actual time=0.002..0.008 rows=132 loops=1)

Planning time : 0.1 ms
Execution time : 4,261.981 ms