explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bstt

Settings
# exclusive inclusive rows x rows loops node
1. 0.061 4,919.235 ↑ 1.0 132 1

Aggregate (cost=209,619.11..209,620.43 rows=132 width=8) (actual time=4,919.227..4,919.235 rows=132 loops=1)

  • Buffers: shared hit=1,022
2. 4,489.154 4,919.174 ↑ 454.8 152 1

Nested Loop (cost=0..209,446.3 rows=69,125 width=8) (actual time=0.026..4,919.174 rows=152 loops=1)

  • Buffers: shared hit=1,022
3. 10.740 10.740 ↓ 1.0 104,820 1

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

  • Buffers: shared hit=1,021
4. 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)

  • Buffers: shared hit=1
5. 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)

  • Buffers: shared hit=1
Planning time : 0.105 ms
Execution time : 4,919.311 ms