explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LaMR

Settings
# exclusive inclusive rows x rows loops node
1. 950.244 27,806.922 ↓ 116,927.0 116,927 1

Nested Loop (cost=1,019.15..20,889.30 rows=1 width=135) (actual time=2.550..27,806.922 rows=116,927 loops=1)

2. 1,725.615 25,560.518 ↓ 1,296,160.0 1,296,160 1

Nested Loop (cost=1,019.14..20,887.29 rows=1 width=275) (actual time=2.346..25,560.518 rows=1,296,160 loops=1)

3. 0.000 19,946.423 ↓ 1,296,160.0 1,296,160 1

Gather (cost=1,018.85..20,886.97 rows=1 width=90) (actual time=2.338..19,946.423 rows=1,296,160 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 2,417.326 24,667.455 ↓ 432,053.0 432,053 3

Nested Loop (cost=18.85..19,886.87 rows=1 width=90) (actual time=1.587..24,667.455 rows=432,053 loops=3)

5. 17,984.583 22,250.126 ↓ 436,292.0 436,292 3

Nested Loop (cost=18.56..19,886.52 rows=1 width=449) (actual time=1.555..22,250.126 rows=436,292 loops=3)

6. 1,773.919 4,265.122 ↓ 41,956.0 41,956 3

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

7. 158.470 2,491.162 ↓ 41,956.0 41,956 3

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

8. 569.374 2,332.690 ↓ 41,956.0 41,956 3

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

9. 605.326 1,763.304 ↓ 42,033.0 42,033 3

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

10. 308.996 1,157.965 ↓ 42,038.0 42,038 3

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

11. 310.749 848.965 ↓ 2,101.9 42,038 3

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

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

13. 0.006 0.039 ↑ 1.0 4 3

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

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

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

  • Index Cond: (styleid = sh.styleid)
17. 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.012..0.012 rows=1 loops=126,098)

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

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

  • Index Cond: (workflowitemid = wi.workflowitemid)
21. 0.003 0.003 ↑ 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.003..0.003 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
22. 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)
23. 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=0) (actual time=0.001..0.001 rows=0 loops=1,296,160)