explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hWrk

Settings
# exclusive inclusive rows x rows loops node
1. 23.990 255.242 ↓ 5,396.0 5,396 1

Nested Loop (cost=369.16..1,352.74 rows=1 width=2,079) (actual time=2.854..255.242 rows=5,396 loops=1)

2.          

Initplan (for Nested Loop)

3. 0.611 0.611 ↑ 1.0 1 1

Seq Scan on t_cat c (cost=0.00..112.80 rows=1 width=4) (actual time=0.157..0.611 rows=1 loops=1)

  • Filter: ((brief)::text = 'SHIRTS'::text)
  • Rows Removed by Filter: 4,543
4. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on t_link_type lt_1 (cost=0.00..1.14 rows=1 width=4) (actual time=0.006..0.008 rows=1 loops=1)

  • Filter: ((brief)::text = 'COLLECTION_LINK'::text)
  • Rows Removed by Filter: 10
5. 0.014 0.014 ↑ 2.0 1 1

Index Scan using brief_idx on t_item i2 (cost=0.42..12.08 rows=2 width=4) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: ((brief)::text = 'vesna-leto-2020-2021-lk'::text)
6. 3.180 3.987 ↓ 85.7 5,396 1

HashAggregate (cost=242.72..243.35 rows=63 width=8) (actual time=2.086..3.987 rows=5,396 loops=1)

  • Group Key: il1.item_id
7. 0.519 0.807 ↓ 85.7 5,396 1

Bitmap Heap Scan on t_item_link il1 (cost=5.07..242.56 rows=63 width=8) (actual time=0.298..0.807 rows=5,396 loops=1)

  • Recheck Cond: ((object_id = $15) AND (link_type_id = $14))
  • Heap Blocks: exact=46
8. 0.288 0.288 ↓ 85.7 5,396 1

Bitmap Index Scan on object_id_link_type_idx (cost=0.00..5.05 rows=63 width=0) (actual time=0.288..0.288 rows=5,396 loops=1)

  • Index Cond: ((object_id = $15) AND (link_type_id = $14))
9. 16.188 26.980 ↑ 1.0 1 5,396

Index Scan using t_item_pkey on t_item i (cost=0.42..13.90 rows=1 width=73) (actual time=0.005..0.005 rows=1 loops=5,396)

  • Index Cond: (item_id = il1.item_id)
  • Filter: ((NOT is_disabled) AND (cat_id = $13) AND ((SubPlan 12) IS NOT NULL))
10.          

SubPlan (for Index Scan)

11. 10.784 10.792 ↑ 1.0 1 5,396

Index Only Scan using il_filter_idx on t_item_link il_1 (cost=1.56..5.59 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=5,396)

  • Index Cond: ((item_id = i.item_id) AND (link_type_id = $16))
  • Heap Fetches: 0
12.          

Initplan (for Index Only Scan)

13. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on t_link_type lt_2 (cost=0.00..1.14 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=1)

  • Filter: ((brief)::text = 'SHIRT_ARTICLE_FIBER_CODE_LINK'::text)
  • Rows Removed by Filter: 10
14.          

SubPlan (for Nested Loop)

15. 16.188 59.356 ↑ 1.0 1 5,396

Nested Loop (cost=0.70..24.54 rows=1 width=39) (actual time=0.008..0.011 rows=1 loops=5,396)

16. 5.396 37.772 ↑ 1.0 1 5,396

Nested Loop (cost=0.42..17.84 rows=1 width=12) (actual time=0.005..0.007 rows=1 loops=5,396)

  • Join Filter: (ip.prop_id = p.prop_id)
  • Rows Removed by Join Filter: 3
17. 10.792 10.792 ↑ 1.0 1 5,396

Seq Scan on t_prop p (cost=0.00..1.23 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=5,396)

  • Filter: ((brief)::text = 'rost'::text)
  • Rows Removed by Filter: 17
18. 21.584 21.584 ↑ 1.2 4 5,396

Index Scan using t_item_prop_item_id_idx on t_item_prop ip (cost=0.42..16.55 rows=5 width=8) (actual time=0.002..0.004 rows=4 loops=5,396)

  • Index Cond: (item_id = i.item_id)
19. 5.396 5.396 ↑ 1.0 1 5,396

Index Scan using t_prop_value_pkey on t_prop_value pv (cost=0.28..6.70 rows=1 width=47) (actual time=0.001..0.001 rows=1 loops=5,396)

  • Index Cond: (prop_value_id = ip.prop_value_id)
  • Filter: (ip.prop_id = prop_id)
20. 16.188 53.960 ↑ 1.0 1 5,396

Nested Loop (cost=0.70..24.54 rows=1 width=39) (actual time=0.008..0.010 rows=1 loops=5,396)

21. 5.396 32.376 ↑ 1.0 1 5,396

Nested Loop (cost=0.42..17.84 rows=1 width=12) (actual time=0.004..0.006 rows=1 loops=5,396)

  • Join Filter: (ip_1.prop_id = p_1.prop_id)
  • Rows Removed by Join Filter: 3
22. 10.792 10.792 ↑ 1.0 1 5,396

Seq Scan on t_prop p_1 (cost=0.00..1.23 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=5,396)

  • Filter: ((brief)::text = 'razmer'::text)
  • Rows Removed by Filter: 17
23. 16.188 16.188 ↑ 1.2 4 5,396

Index Scan using t_item_prop_item_id_idx on t_item_prop ip_1 (cost=0.42..16.55 rows=5 width=8) (actual time=0.002..0.003 rows=4 loops=5,396)

  • Index Cond: (item_id = i.item_id)
24. 5.396 5.396 ↑ 1.0 1 5,396

Index Scan using t_prop_value_pkey on t_prop_value pv_1 (cost=0.28..6.70 rows=1 width=47) (actual time=0.001..0.001 rows=1 loops=5,396)

  • Index Cond: (prop_value_id = ip_1.prop_value_id)
  • Filter: (ip_1.prop_id = prop_id)
25. 10.792 48.564 ↑ 1.0 1 5,396

Nested Loop (cost=0.70..24.54 rows=1 width=39) (actual time=0.008..0.009 rows=1 loops=5,396)

26. 5.396 32.376 ↑ 1.0 1 5,396

Nested Loop (cost=0.42..17.84 rows=1 width=12) (actual time=0.005..0.006 rows=1 loops=5,396)

  • Join Filter: (ip_2.prop_id = p_2.prop_id)
  • Rows Removed by Join Filter: 3
27. 10.792 10.792 ↑ 1.0 1 5,396

Seq Scan on t_prop p_2 (cost=0.00..1.23 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=5,396)

  • Filter: ((brief)::text = 'cloth_type'::text)
  • Rows Removed by Filter: 17
28. 16.188 16.188 ↑ 1.2 4 5,396

Index Scan using t_item_prop_item_id_idx on t_item_prop ip_2 (cost=0.42..16.55 rows=5 width=8) (actual time=0.002..0.003 rows=4 loops=5,396)

  • Index Cond: (item_id = i.item_id)
29. 5.396 5.396 ↑ 1.0 1 5,396

Index Scan using t_prop_value_pkey on t_prop_value pv_2 (cost=0.28..6.70 rows=1 width=47) (actual time=0.001..0.001 rows=1 loops=5,396)

  • Index Cond: (prop_value_id = ip_2.prop_value_id)
  • Filter: (ip_2.prop_id = prop_id)
30. 0.000 16.188 ↓ 0.0 0 5,396

Nested Loop (cost=0.42..13.53 rows=1 width=5) (actual time=0.003..0.003 rows=0 loops=5,396)

  • Join Filter: (pl.pl_id = p_3.pl_id)
31. 5.396 5.396 ↑ 1.0 1 5,396

Seq Scan on t_pl p_3 (cost=0.00..1.05 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=5,396)

  • Filter: (brief = 'MAIN_PRICE'::text)
  • Rows Removed by Filter: 3
32. 10.792 10.792 ↓ 0.0 0 5,396

Index Scan using pl_item on t_pline pl (cost=0.42..12.45 rows=2 width=9) (actual time=0.002..0.002 rows=0 loops=5,396)

  • Index Cond: (item_id = i.item_id)
33. 10.792 10.792 ↑ 1.0 1 5,396

Index Scan using icd_item_id_idx on t_icode ic (cost=0.42..8.44 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=5,396)

  • Index Cond: (item_id = i.item_id)
34. 10.787 10.792 ↑ 1.0 1 5,396

Index Only Scan using il_filter_idx on t_item_link il (cost=1.56..5.59 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=5,396)

  • Index Cond: ((item_id = i.item_id) AND (link_type_id = $11))
  • Heap Fetches: 0
35.          

Initplan (for Index Only Scan)

36. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on t_link_type lt (cost=0.00..1.14 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=1)

  • Filter: ((brief)::text = 'SHIRT_ARTICLE_FIBER_CODE_LINK'::text)
  • Rows Removed by Filter: 10
Planning time : 1.629 ms
Execution time : 255.754 ms