explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8DTz

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 12,769.428 ↓ 327,219.2 1,308,877 1

Gather Merge (cost=20,883.54..20,884.01 rows=4 width=89) (actual time=11,167.772..12,769.428 rows=1,308,877 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 6,278.352 34,607.292 ↓ 218,146.0 436,292 3

Sort (cost=19,883.52..19,883.52 rows=2 width=89) (actual time=11,113.180..11,535.764 rows=436,292 loops=3)

  • Sort Key: brand.itemkey, sh.styleno, var.styledevelopmentname
  • Sort Method: external merge Disk: 34720kB
3. 726.561 28,328.940 ↓ 218,146.0 436,292 3

Nested Loop (cost=18.56..19,883.51 rows=2 width=89) (actual time=1.893..9,442.980 rows=436,292 loops=3)

4. 228.686 11,342.046 ↓ 78,552.0 78,552 3

Nested Loop (cost=18.13..19,881.50 rows=1 width=83) (actual time=1.388..3,780.682 rows=78,552 loops=3)

5. 123.037 7,966.635 ↓ 41,956.0 41,956 3

Nested Loop (cost=17.71..19,880.34 rows=1 width=62) (actual time=1.144..2,655.545 rows=41,956 loops=3)

6. 101.819 7,591.860 ↓ 41,956.0 41,956 3

Nested Loop (cost=17.57..19,880.18 rows=1 width=68) (actual time=1.108..2,530.620 rows=41,956 loops=3)

7. 161.116 6,102.963 ↓ 42,033.0 42,033 3

Nested Loop (cost=17.15..19,879.64 rows=1 width=68) (actual time=0.887..2,034.321 rows=42,033 loops=3)

8. 340.001 4,554.582 ↓ 42,038.0 42,038 3

Nested Loop (cost=16.73..19,879.10 rows=1 width=35) (actual time=0.682..1,518.194 rows=42,038 loops=3)

9. 864.174 3,710.121 ↓ 2,101.9 42,038 3

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

  • Hash Cond: (((sh.eav ->> 'eavbrand'::text))::uuid = brand.lookupid)
10. 2,845.698 2,845.698 ↑ 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.070..948.566 rows=42,054 loops=3)

11. 0.051 0.249 ↑ 1.0 4 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.198 0.198 ↑ 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.055..0.066 rows=4 loops=3)

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

Index Scan using pk_dlookup on dlookup dept (cost=0.29..0.32 rows=1 width=16) (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)
14. 1,387.265 1,387.265 ↑ 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)
15. 1,387.078 1,387.078 ↑ 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.011 rows=1 loops=126,098)

  • Index Cond: (styleid = sh.styleid)
16. 251.738 251.738 ↑ 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)
17. 3,146.725 3,146.725 ↑ 1.0 2 125,869

Index Scan using ix_pworkflowitem_styleseasonyearid on pworkflowitem wi (cost=0.42..1.13 rows=2 width=53) (actual time=0.016..0.025 rows=2 loops=125,869)

  • Index Cond: (styleseasonyearid = ssy.styleseasonyearid)
18. 16,260.333 16,260.333 ↑ 3.2 6 235,657

Index Only Scan using ix_pstylebom_workflowitemid on pstylebom sm (cost=0.43..1.81 rows=19 width=16) (actual time=0.022..0.069 rows=6 loops=235,657)

  • Index Cond: (workflowitemid = wi.workflowitemid)
  • Heap Fetches: 438569