explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AQBC

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 166.103 754.535 ↓ 1.0 44,367 1

Gather Merge (cost=1,001.43..183,978.85 rows=44,357 width=155) (actual time=3.890..754.535 rows=44,367 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 14.198 588.432 ↑ 1.2 14,789 3 / 3

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

3. 14.537 174.931 ↑ 1.2 14,789 3 / 3

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

4. 12.504 12.504 ↑ 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.005..12.504 rows=14,789 loops=3)

5. 147.890 147.890 ↑ 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.010..0.010 rows=1 loops=44,367)

  • Index Cond: ((ws_simple_id)::text = (pricingcla0_.simple_id)::text)
6. 399.303 399.303 ↑ 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.027..0.027 rows=1 loops=44,367)

  • Index Cond: (ws_config_id = (simple1_.ws_config_id)::text)
  • Heap Fetches: 3,159
Planning time : 0.511 ms
Execution time : 758.443 ms