explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XG6J

Settings
# exclusive inclusive rows x rows loops node
1. 343.320 22,032.768 ↓ 116,927.0 116,927 1

Nested Loop (cost=1,019.44..20,895.20 rows=1 width=147) (actual time=5.016..22,032.768 rows=116,927 loops=1)

2. 775.572 21,338.667 ↓ 116,927.0 116,927 1

Nested Loop (cost=1,019.15..20,889.29 rows=1 width=145) (actual time=4.995..21,338.667 rows=116,927 loops=1)

3. 1,655.179 19,266.935 ↓ 1,296,160.0 1,296,160 1

Nested Loop (cost=1,019.14..20,887.29 rows=1 width=275) (actual time=3.462..19,266.935 rows=1,296,160 loops=1)

4. 0.000 13,723.276 ↓ 1,296,160.0 1,296,160 1

Gather (cost=1,018.85..20,886.97 rows=1 width=90) (actual time=3.453..13,723.276 rows=1,296,160 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 2,363.109 18,719.640 ↓ 432,053.0 432,053 3

Nested Loop (cost=18.85..19,886.87 rows=1 width=90) (actual time=2.349..18,719.640 rows=432,053 loops=3)

6. 12,429.613 16,356.529 ↓ 436,292.0 436,292 3

Nested Loop (cost=18.56..19,886.52 rows=1 width=449) (actual time=2.313..16,356.529 rows=436,292 loops=3)

7. 1,384.651 3,926.627 ↓ 41,956.0 41,956 3

Nested Loop (cost=18.13..19,881.49 rows=1 width=449) (actual time=1.702..3,926.627 rows=41,956 loops=3)

8. 164.092 2,541.944 ↓ 41,956.0 41,956 3

Nested Loop (cost=17.71..19,880.34 rows=1 width=428) (actual time=1.214..2,541.944 rows=41,956 loops=3)

9. 558.815 2,377.850 ↓ 41,956.0 41,956 3

Nested Loop (cost=17.57..19,880.18 rows=1 width=434) (actual time=1.167..2,377.850 rows=41,956 loops=3)

10. 580.789 1,819.023 ↓ 42,033.0 42,033 3

Nested Loop (cost=17.15..19,879.64 rows=1 width=434) (actual time=0.897..1,819.023 rows=42,033 loops=3)

11. 315.363 1,238.222 ↓ 42,038.0 42,038 3

Nested Loop (cost=16.73..19,879.10 rows=1 width=401) (actual time=0.665..1,238.222 rows=42,038 loops=3)

12. 317.844 922.855 ↓ 2,101.9 42,038 3

Hash Join (cost=16.44..19,872.71 rows=20 width=394) (actual time=0.603..922.855 rows=42,038 loops=3)

  • Hash Cond: (((sh.eav ->> 'eavbrand'::text))::uuid = brand.lookupid)
13. 604.939 604.939 ↑ 1.3 42,054 3

Parallel Seq Scan on pstyleheader sh (cost=0.00..19,172.78 rows=52,578 width=382) (actual time=0.293..604.939 rows=42,054 loops=3)

14. 0.008 0.072 ↑ 1.0 4 3

Hash (cost=16.39..16.39 rows=4 width=28) (actual time=0.072..0.072 rows=4 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.064 0.064 ↑ 1.0 4 3

Index Scan using ix_dlookup_lookuptypeid on dlookup brand (cost=0.29..16.39 rows=4 width=28) (actual time=0.046..0.064 rows=4 loops=3)

  • Index Cond: (lookuptypeid = '00000000-0000-0000-0000-000000000020'::uuid)
16. 0.004 0.004 ↑ 1.0 1 126,115

Index Scan using pk_dlookup on dlookup dept (cost=0.29..0.32 rows=1 width=23) (actual time=0.004..0.004 rows=1 loops=126,115)

  • Index Cond: (lookupid = ((sh.eav ->> 'eavdepartment'::text))::uuid)
  • Filter: (lookuptypeid = '00000000-0000-0000-0000-000000000019'::uuid)
17. 0.012 0.012 ↑ 1.0 1 126,115

Index Scan using ix_pstyledevelopmentitem_styleid on pstyledevelopmentitem var (cost=0.42..0.53 rows=1 width=33) (actual time=0.012..0.012 rows=1 loops=126,115)

  • Index Cond: (styleid = sh.styleid)
18. 0.012 0.012 ↑ 1.0 1 126,098

Index Scan using ix_pstyleseasonyear_styleid_seasonyearid on pstyleseasonyear ssy (cost=0.42..0.53 rows=1 width=48) (actual time=0.011..0.012 rows=1 loops=126,098)

  • Index Cond: (styleid = sh.styleid)
19. 0.002 0.002 ↑ 1.0 1 125,869

Index Scan using pk_pseasonyear on pseasonyear sy (cost=0.14..0.16 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=125,869)

  • Index Cond: (seasonyearid = ssy.seasonyearid)
20. 0.032 0.032 ↑ 1.0 1 125,869

Index Scan using ix_pworkflowitem_styleseasonyearid on pworkflowitem wi (cost=0.42..1.14 rows=1 width=53) (actual time=0.025..0.032 rows=1 loops=125,869)

  • Index Cond: (styleseasonyearid = ssy.styleseasonyearid)
  • Filter: (workflowid = '40000000-0000-0000-0000-000000000080'::uuid)
  • Rows Removed by Filter: 1
21. 0.289 0.289 ↑ 1.9 10 125,869

Index Scan using ix_pstylebom_workflowitemid on pstylebom sm (cost=0.43..4.84 rows=19 width=32) (actual time=0.076..0.289 rows=10 loops=125,869)

  • Index Cond: (workflowitemid = wi.workflowitemid)
22. 0.002 0.002 ↑ 1.0 1 1,308,877

Index Scan using pk_dlookup on dlookup devstage (cost=0.29..0.32 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,308,877)

  • Index Cond: (lookupid = ((sh.eav ->> 'eavdevstage'::text))::uuid)
  • Filter: ((lookuptypeid = '00000000-0000-0000-0000-000000000005'::uuid) AND ((itemkey)::text = ANY ('{001,002,003}'::text[])))
  • Rows Removed by Filter: 0
23. 3,888.480 3,888.480 ↑ 1.0 1 1,296,160

Index Scan using pk__pmaterial__53f76c67 on pmaterial mat (cost=0.29..0.31 rows=1 width=217) (actual time=0.003..0.003 rows=1 loops=1,296,160)

  • Index Cond: (materialid = sm.materialid)
24. 1,296.160 1,296.160 ↓ 0.0 0 1,296,160

Function Scan on jsonb_array_elements_text mlc (cost=0.01..1.00 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=1,296,160)

25. 350.781 350.781 ↑ 1.0 1 116,927

Index Scan using pk_dlookup on dlookup lc (cost=0.29..5.15 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=116,927)

  • Index Cond: (lookupid = (mlc.complianceid)::uuid)
  • Filter: (lookuptypeid = '00000000-0000-0000-0000-000000000045'::uuid)
Planning time : 7.694 ms
Execution time : 22,063.881 ms