explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IHY4

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 4,553.869 ↑ 1.0 132 1

Aggregate (cost=209,788.4..209,789.72 rows=132 width=8) (actual time=4,553.859..4,553.869 rows=132 loops=1)

  • Buffers: shared hit=1,022
2. 4,115.515 4,553.823 ↑ 524.1 132 1

Nested Loop (cost=0..209,615.45 rows=69,181 width=8) (actual time=0.06..4,553.823 rows=132 loops=1)

  • Buffers: shared hit=1,022
3. 19.028 19.028 ↑ 1.0 104,820 1

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

  • Buffers: shared hit=1,021
4. 419.270 419.280 ↑ 1.0 132 104,820

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

  • Buffers: shared hit=1
5. 0.010 0.010 ↑ 1.0 132 1

Seq Scan on vendorsearch2 vendorsearch2 (cost=0..2.32 rows=132 width=15) (actual time=0.003..0.01 rows=132 loops=1)

  • Buffers: shared hit=1
Planning time : 0.107 ms
Execution time : 4,553.907 ms