explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wLVF

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 4,831.834 ↓ 0.0 152 1

Unique (cost=0..0 rows=0 width=0) (actual time=4,831.814..4,831.834 rows=152 loops=1)

2. 0.332 4,831.820 ↓ 0.0 152 1

Sort (cost=0..0 rows=0 width=0) (actual time=4,831.813..4,831.82 rows=152 loops=1)

  • Sort Key: invmanufacturer.manufacturer_name, vendorsearchvalue.vendor_id
  • Sort Method: quicksort Memory: 33kB
3. 4,401.880 4,831.488 ↓ 0.0 152 1

Nested Loop (cost=0..0 rows=0 width=0) (actual time=0.031..4,831.488 rows=152 loops=1)

4. 10.328 10.328 ↓ 0.0 104,820 1

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

5. 419.273 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)

6. 0.007 0.007 ↓ 0.0 132 1

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

Planning time : 0.096 ms
Execution time : 4,844.683 ms