explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VZ4y

Settings
# exclusive inclusive rows x rows loops node
1. 0.077 5,418.258 ↑ 1.0 132 1

HashAggregate (cost=209,619.11..209,620.43 rows=132 width=8) (actual time=5,418.248..5,418.258 rows=132 loops=1)

  • Group Key: vendorsearchvalue.vendor_id
2. 4,980.689 5,418.181 ↑ 454.8 152 1

Nested Loop (cost=0.00..209,446.30 rows=69,125 width=8) (actual time=0.024..5,418.181 rows=152 loops=1)

  • Join Filter: (invmanufacturer.manufacturer_name ~~ vendorsearchvalue.search_value)
  • Rows Removed by Join Filter: 13,836,088
3. 18.212 18.212 ↓ 1.0 104,820 1

Seq Scan on invmanufacturer (cost=0.00..2,068.35 rows=104,735 width=39) (actual time=0.006..18.212 rows=104,820 loops=1)

4. 419.272 419.280 ↑ 1.0 132 104,820

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

5. 0.008 0.008 ↑ 1.0 132 1

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

Planning time : 0.085 ms