explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k4C7

Settings
# exclusive inclusive rows x rows loops node
1. 18.422 848.722 ↓ 1.0 44,367 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 15.151 830.300 ↑ 1.2 14,789 3 / 3

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

3. 18.219 223.589 ↑ 1.2 14,789 3 / 3

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

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

5. 192.257 192.257 ↑ 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.013..0.013 rows=1 loops=44,367)

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

  • Index Cond: (ws_config_id = (simple1_.ws_config_id)::text)
  • Heap Fetches: 5128
Planning time : 0.707 ms
Execution time : 853.648 ms