explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vjpj

Settings
# exclusive inclusive rows x rows loops node
1. 19.670 522.276 ↓ 1.0 44,367 1

Gather (cost=1,001.40..183,294.63 rows=44,357 width=136) (actual time=0.307..522.276 rows=44,367 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 15.900 502.606 ↑ 1.2 14,789 3 / 3

Nested Loop (cost=1.40..177,858.93 rows=18,482 width=136) (actual time=0.057..502.606 rows=14,789 loops=3)

3. 26.629 309.238 ↑ 1.2 14,789 3 / 3

Nested Loop (cost=0.98..162,572.54 rows=18,482 width=168) (actual time=0.032..309.238 rows=14,789 loops=3)

4. 16.407 16.407 ↑ 1.2 14,789 3 / 3

Parallel Index Scan using pricing_clarification_simple_id_uindex on pricing_clarification pricingcla0_ (cost=0.41..18,564.79 rows=18,482 width=136) (actual time=0.006..16.407 rows=14,789 loops=3)

5. 266.202 266.202 ↑ 1.0 1 44,367 / 3

Index Scan using wholesale_simple_pkey on wholesale_simple simple1_ (cost=0.56..7.79 rows=1 width=65) (actual time=0.018..0.018 rows=1 loops=44,367)

  • Index Cond: ((ws_simple_id)::text = (pricingcla0_.simple_id)::text)
6. 177.468 177.468 ↑ 1.0 1 44,367 / 3

Index Only Scan using article_pkey on wholesale_config config2_ (cost=0.43..0.83 rows=1 width=32) (actual time=0.012..0.012 rows=1 loops=44,367)

  • Index Cond: (ws_config_id = (simple1_.ws_config_id)::text)
  • Heap Fetches: 5099
Planning time : 0.445 ms
Execution time : 524.958 ms