explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2pvg

Settings
# exclusive inclusive rows x rows loops node
1. 29.565 9,982.800 ↓ 1.0 44,486 1

Gather (cost=1,000.56..192,663.00 rows=44,483 width=136) (actual time=2.005..9,982.800 rows=44,486 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 26.219 9,953.235 ↑ 1.2 22,243 2 / 2

Nested Loop (cost=0.56..187,214.70 rows=26,166 width=136) (actual time=0.039..9,953.235 rows=22,243 loops=2)

3. 28.881 28.881 ↑ 1.2 22,243 2 / 2

Parallel Seq Scan on pricing_clarification (cost=0.00..1,478.66 rows=26,166 width=136) (actual time=0.006..28.881 rows=22,243 loops=2)

4. 9,898.135 9,898.135 ↑ 1.0 1 44,486 / 2

Index Only Scan using wholesale_simple_pkey on wholesale_simple (cost=0.56..7.10 rows=1 width=33) (actual time=0.445..0.445 rows=1 loops=44,486)

  • Index Cond: (ws_simple_id = (pricing_clarification.simple_id)::text)
  • Heap Fetches: 20232
Planning time : 0.285 ms
Execution time : 9,986.829 ms