explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q4jC

Settings
# exclusive inclusive rows x rows loops node
1. 12.440 300.039 ↓ 1.0 44,381 1

Gather (cost=1,000.56..192,174.75 rows=44,357 width=136) (actual time=2.752..300.039 rows=44,381 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 15.241 287.599 ↑ 1.2 22,190 2 / 2

Nested Loop (cost=0.56..186,739.05 rows=26,092 width=136) (actual time=1.282..287.599 rows=22,190 loops=2)

3. 6.072 6.072 ↑ 1.2 22,190 2 / 2

Parallel Seq Scan on pricing_clarification (cost=0.00..1,477.92 rows=26,092 width=136) (actual time=0.005..6.072 rows=22,190 loops=2)

4. 266.286 266.286 ↑ 1.0 1 44,381 / 2

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

  • Index Cond: (ws_simple_id = (pricing_clarification.simple_id)::text)
  • Heap Fetches: 19494
Planning time : 0.228 ms
Execution time : 302.952 ms