explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Oqr

Settings
# exclusive inclusive rows x rows loops node
1. 0.207 4,791.096 ↑ 455.1 152 1

Aggregate (cost=209,961.36..210,653.17 rows=69,181 width=47) (actual time=4,790.949..4,791.096 rows=152 loops=1)

2. 4,361.122 4,790.889 ↑ 455.1 152 1

Nested Loop (cost=0..209,615.45 rows=69,181 width=47) (actual time=0.027..4,790.889 rows=152 loops=1)

3. 10.487 10.487 ↑ 1.0 104,820 1

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

4. 419.273 419.280 ↑ 1.0 132 104,820

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

5. 0.007 0.007 ↑ 1.0 132 1

Seq Scan on vendorsearchvalue vendorsearchvalue (cost=0..2.32 rows=132 width=17) (actual time=0.002..0.007 rows=132 loops=1)

Planning time : 0.097 ms
Execution time : 4,791.774 ms