explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 11ri

Settings
# exclusive inclusive rows x rows loops node
1. 1,740.436 12,523.527 ↓ 1,296,160.0 1,296,160 1

Nested Loop (cost=1,019.14..20,887.29 rows=1 width=135) (actual time=2.143..12,523.527 rows=1,296,160 loops=1)

2. 0.000 8,190.771 ↓ 1,296,160.0 1,296,160 1

Gather (cost=1,018.85..20,886.97 rows=1 width=90) (actual time=2.134..8,190.771 rows=1,296,160 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,680.568 10,764.480 ↓ 432,053.0 432,053 3

Nested Loop (cost=18.85..19,886.87 rows=1 width=90) (actual time=1.558..10,764.480 rows=432,053 loops=3)

4. 5,478.884 9,083.910 ↓ 436,292.0 436,292 3

Nested Loop (cost=18.56..19,886.52 rows=1 width=449) (actual time=1.536..9,083.910 rows=436,292 loops=3)

5. 1,113.519 3,604.901 ↓ 41,956.0 41,956 3

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

6. 116.941 2,491.356 ↓ 41,956.0 41,956 3

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

7. 480.923 2,374.413 ↓ 41,956.0 41,956 3

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

8. 527.956 1,893.480 ↓ 42,033.0 42,033 3

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

9. 236.838 1,365.513 ↓ 42,038.0 42,038 3

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

10. 240.898 1,128.672 ↓ 2,101.9 42,038 3

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

  • Hash Cond: (((sh.eav ->> 'eavbrand'::text))::uuid = brand.lookupid)
11. 887.708 887.708 ↑ 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.030..887.708 rows=42,054 loops=3)

12. 0.008 0.066 ↑ 1.0 4 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.058 0.058 ↑ 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.058 rows=4 loops=3)

  • Index Cond: (lookuptypeid = '00000000-0000-0000-0000-000000000020'::uuid)
14. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=126,115)

  • Index Cond: (lookupid = ((sh.eav ->> 'eavdepartment'::text))::uuid)
  • Filter: (lookuptypeid = '00000000-0000-0000-0000-000000000019'::uuid)
15. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=126,115)

  • Index Cond: (styleid = sh.styleid)
16. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=126,098)

  • Index Cond: (styleid = sh.styleid)
17. 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)
18. 0.026 0.026 ↑ 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.021..0.026 rows=1 loops=125,869)

  • Index Cond: (styleseasonyearid = ssy.styleseasonyearid)
  • Filter: (workflowid = '40000000-0000-0000-0000-000000000080'::uuid)
  • Rows Removed by Filter: 1
19. 0.125 0.125 ↑ 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.033..0.125 rows=10 loops=125,869)

  • Index Cond: (workflowitemid = wi.workflowitemid)
20. 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
21. 2,592.320 2,592.320 ↑ 1.0 1 1,296,160

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

  • Index Cond: (materialid = sm.materialid)