explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CXxY

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 3,113.486 ↑ 1.0 82 1

Aggregate (cost=131,108.1..131,108.92 rows=82 width=8) (actual time=3,113.479..3,113.486 rows=82 loops=1)

2. 2,893.405 3,113.462 ↑ 467.1 92 1

Nested Loop (cost=0..131,000.66 rows=42,976 width=8) (actual time=3,111.953..3,113.462 rows=92 loops=1)

3. 10.417 10.417 ↑ 1.0 104,820 1

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

4. 209.628 209.640 ↑ 1.0 82 104,820

Materialize (cost=0..3.06 rows=82 width=17) (actual time=0..0.002 rows=82 loops=104,820)

5. 0.012 0.012 ↑ 1.0 82 1

Seq Scan on vendorsearchvalue vendorsearchvalue (cost=0..2.65 rows=82 width=17) (actual time=0.006..0.012 rows=82 loops=1)

  • Filter: (vendor_id > 50)
Planning time : 0.115 ms
Execution time : 3,113.521 ms