explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AAsg

Settings
# exclusive inclusive rows x rows loops node
1. 19.181 540.652 ↓ 1.0 44,367 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 18.506 521.471 ↑ 1.2 14,789 3 / 3

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

3. 16.977 310.708 ↑ 1.2 14,789 3 / 3

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

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

5. 280.991 280.991 ↑ 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.019..0.019 rows=1 loops=44,367)

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

  • Index Cond: (ws_config_id = (simple1_.ws_config_id)::text)
  • Heap Fetches: 6,635
Planning time : 0.481 ms
Execution time : 543.432 ms