explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oJTa

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 5,219.538 ↑ 455.1 152 1

Unique (cost=215,176.94..215,695.8 rows=69,181 width=47) (actual time=5,219.499..5,219.538 rows=152 loops=1)

2. 0.184 5,219.522 ↑ 455.1 152 1

Sort (cost=215,176.94..215,349.89 rows=69,181 width=47) (actual time=5,219.498..5,219.522 rows=152 loops=1)

  • Sort Key: invmanufacturer.manufacturer_name, vendorsearchvalue.vendor_id
  • Sort Method: quicksort Memory: 33kB
3. 4,785.424 5,219.338 ↑ 455.1 152 1

Nested Loop (cost=0..209,615.45 rows=69,181 width=47) (actual time=0.036..5,219.338 rows=152 loops=1)

4. 14.634 14.634 ↑ 1.0 104,820 1

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

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

6. 0.009 0.009 ↑ 1.0 132 1

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

Planning time : 0.126 ms
Execution time : 5,219.586 ms