explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FSCi

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 5,143.035 ↑ 1.0 132 1

Sort (cost=209,794.37..209,794.7 rows=132 width=8) (actual time=5,143.029..5,143.035 rows=132 loops=1)

  • Sort Key: vendorsearchvalue.vendor_id
  • Sort Method: quicksort Memory: 31kB
2. 0.043 5,143.010 ↑ 1.0 132 1

Aggregate (cost=209,788.4..209,789.72 rows=132 width=8) (actual time=5,143.002..5,143.01 rows=132 loops=1)

3. 4,711.131 5,142.967 ↑ 455.1 152 1

Nested Loop (cost=0..209,615.45 rows=69,181 width=8) (actual time=0.03..5,142.967 rows=152 loops=1)

4. 12.556 12.556 ↑ 1.0 104,820 1

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

5. 419.270 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.010 0.010 ↑ 1.0 132 1

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

Planning time : 0.146 ms
Execution time : 5,143.092 ms