explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eDgf

Settings
# exclusive inclusive rows x rows loops node
1. 84.856 48,174.946 ↓ 724.0 724 1

GroupAggregate (cost=8,736.31..24,984.59 rows=1 width=1,138) (actual time=262.921..48,174.946 rows=724 loops=1)

  • Group Key: i.article, ((SubPlan 3)), ((SubPlan 4)), ((SubPlan 2))
2.          

Initplan (for GroupAggregate)

3. 0.543 0.543 ↑ 1.0 1 1

Seq Scan on t_cat c_1 (cost=0.00..112.80 rows=1 width=4) (actual time=0.124..0.543 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_6 (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_1 (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. 9.851 193.501 ↓ 5,396.0 5,396 1

Sort (cost=8,610.28..8,610.29 rows=1 width=1,109) (actual time=191.902..193.501 rows=5,396 loops=1)

  • Sort Key: i.article, ((SubPlan 3)), ((SubPlan 4)), ((SubPlan 2))
  • Sort Method: quicksort Memory: 951kB
7. 18.113 183.650 ↓ 5,396.0 5,396 1

Nested Loop (cost=412.24..8,610.27 rows=1 width=1,109) (actual time=2.590..183.650 rows=5,396 loops=1)

8. 2.896 3.657 ↓ 49.1 5,396 1

HashAggregate (cost=411.82..412.92 rows=110 width=8) (actual time=1.956..3.657 rows=5,396 loops=1)

  • Group Key: il1.item_id
9. 0.479 0.761 ↓ 49.1 5,396 1

Bitmap Heap Scan on t_item_link il1 (cost=5.55..411.55 rows=110 width=8) (actual time=0.291..0.761 rows=5,396 loops=1)

  • Recheck Cond: ((object_id = $41) AND (link_type_id = $40))
  • Heap Blocks: exact=46
10. 0.282 0.282 ↓ 49.1 5,396 1

Bitmap Index Scan on object_id_link_type_idx (cost=0.00..5.53 rows=110 width=0) (actual time=0.282..0.282 rows=5,396 loops=1)

  • Index Cond: ((object_id = $41) AND (link_type_id = $40))
11. 26.980 43.168 ↑ 1.0 1 5,396

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

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

SubPlan (for Index Scan)

13. 5.392 16.188 ↑ 15.0 1 5,396

Bitmap Heap Scan on t_item_link il_5 (cost=6.45..64.88 rows=15 width=4) (actual time=0.003..0.003 rows=1 loops=5,396)

  • Recheck Cond: ((i.item_id = item_id) AND (link_type_id = $42))
  • Heap Blocks: exact=5,396
14.          

Initplan (for Bitmap Heap Scan)

15. 0.004 0.004 ↑ 1.0 1 1

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

  • Filter: ((brief)::text = 'SHIRT_ARTICLE_FIBER_CODE_LINK'::text)
  • Rows Removed by Filter: 10
16. 10.792 10.792 ↑ 15.0 1 5,396

Bitmap Index Scan on il_filter_idx (cost=0.00..5.31 rows=15 width=0) (actual time=0.002..0.002 rows=1 loops=5,396)

  • Index Cond: ((item_id = i.item_id) AND (link_type_id = $42))
17.          

SubPlan (for Nested Loop)

18. 5.392 16.188 ↑ 15.0 1 5,396

Bitmap Heap Scan on t_item_link il (cost=6.45..64.88 rows=15 width=4) (actual time=0.003..0.003 rows=1 loops=5,396)

  • Recheck Cond: ((i.item_id = item_id) AND (link_type_id = $0))
  • Heap Blocks: exact=5,396
19.          

Initplan (for Bitmap Heap Scan)

20. 0.004 0.004 ↑ 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.004 rows=1 loops=1)

  • Filter: ((brief)::text = 'SHIRT_ARTICLE_FIBER_CODE_LINK'::text)
  • Rows Removed by Filter: 10
21. 10.792 10.792 ↑ 15.0 1 5,396

Bitmap Index Scan on il_filter_idx (cost=0.00..5.31 rows=15 width=0) (actual time=0.002..0.002 rows=1 loops=5,396)

  • Index Cond: ((item_id = i.item_id) AND (link_type_id = $0))
22. 10.792 53.960 ↑ 1.0 1 5,396

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

23. 5.396 37.772 ↑ 1.0 1 5,396

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

  • Join Filter: (ip.prop_id = p.prop_id)
  • Rows Removed by Join Filter: 3
24. 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.001..0.002 rows=1 loops=5,396)

  • Filter: ((brief)::text = 'cloth_type'::text)
  • Rows Removed by Filter: 17
25. 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)
26. 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)
27. 10.792 48.564 ↑ 1.0 1 5,396

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

28. 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
29. 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.001..0.002 rows=1 loops=5,396)

  • Filter: ((brief)::text = 'rost'::text)
  • Rows Removed by Filter: 17
30. 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)
31. 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)
32.          

SubPlan (for GroupAggregate)

33. 0.000 47,577.660 ↑ 1.0 1 724

Unique (cost=15,924.71..15,924.72 rows=1 width=32) (actual time=65.712..65.715 rows=1 loops=724)

34.          

Initplan (for Unique)

35. 0.472 0.472 ↑ 1.0 1 1

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

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

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

  • Filter: ((brief)::text = 'COLLECTION_LINK'::text)
  • Rows Removed by Filter: 10
37. 0.009 0.009 ↑ 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.009..0.009 rows=1 loops=1)

  • Index Cond: ((brief)::text = 'vesna-leto-2020-2021-lk'::text)
38. 0.721 2.172 ↑ 15.0 1 724

Bitmap Heap Scan on t_item_link il_3 (cost=6.45..64.88 rows=15 width=4) (actual time=0.003..0.003 rows=1 loops=724)

  • Recheck Cond: ((i.item_id = item_id) AND (link_type_id = $16))
  • Heap Blocks: exact=724
39.          

Initplan (for Bitmap Heap Scan)

40. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on t_link_type lt_4 (cost=0.00..1.14 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: ((brief)::text = 'SHIRT_ARTICLE_FIBER_CODE_LINK'::text)
  • Rows Removed by Filter: 10
41. 1.448 1.448 ↑ 15.0 1 724

Bitmap Index Scan on il_filter_idx (cost=0.00..5.31 rows=15 width=0) (actual time=0.002..0.002 rows=1 loops=724)

  • Index Cond: ((item_id = i.item_id) AND (link_type_id = $16))
42. 7.964 47,575.488 ↓ 21.0 21 724

Sort (cost=15,733.81..15,733.82 rows=1 width=32) (actual time=65.711..65.712 rows=21 loops=724)

  • Sort Key: ((SubPlan 5))
  • Sort Method: quicksort Memory: 25kB
43. 0.000 47,567.524 ↓ 21.0 21 724

Nested Loop (cost=412.24..15,733.80 rows=1 width=32) (actual time=3.642..65.701 rows=21 loops=724)

44. 975.892 976.676 ↓ 49.1 5,396 724

HashAggregate (cost=411.82..412.92 rows=110 width=8) (actual time=0.003..1.349 rows=5,396 loops=724)

  • Group Key: il1_1.item_id
45. 0.499 0.784 ↓ 49.1 5,396 1

Bitmap Heap Scan on t_item_link il1_1 (cost=5.55..411.55 rows=110 width=8) (actual time=0.292..0.784 rows=5,396 loops=1)

  • Recheck Cond: ((object_id = $11) AND (link_type_id = $10))
  • Heap Blocks: exact=46
46. 0.285 0.285 ↓ 49.1 5,396 1

Bitmap Index Scan on object_id_link_type_idx (cost=0.00..5.53 rows=110 width=0) (actual time=0.285..0.285 rows=5,396 loops=1)

  • Index Cond: ((object_id = $11) AND (link_type_id = $10))
47. 23,440.224 46,880.448 ↓ 0.0 0 3,906,704

Index Scan using t_item_pkey on t_item i_1 (cost=0.42..137.91 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=3,906,704)

  • Index Cond: (item_id = il1_1.item_id)
  • Filter: ((NOT is_disabled) AND (cat_id = $9) AND ((SubPlan 10) IS NOT NULL) AND ((SubPlan 12) = $18))
  • Rows Removed by Filter: 1
48.          

SubPlan (for Index Scan)

49. 3,906.700 11,720.112 ↑ 15.0 1 3,906,704

Bitmap Heap Scan on t_item_link il_1 (cost=6.45..64.88 rows=15 width=4) (actual time=0.003..0.003 rows=1 loops=3,906,704)

  • Recheck Cond: ((i_1.item_id = item_id) AND (link_type_id = $12))
  • Heap Blocks: exact=3,906,704
50.          

Initplan (for Bitmap Heap Scan)

51. 0.004 0.004 ↑ 1.0 1 1

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

  • Filter: ((brief)::text = 'SHIRT_ARTICLE_FIBER_CODE_LINK'::text)
  • Rows Removed by Filter: 10
52. 7,813.408 7,813.408 ↑ 15.0 1 3,906,704

Bitmap Index Scan on il_filter_idx (cost=0.00..5.31 rows=15 width=0) (actual time=0.002..0.002 rows=1 loops=3,906,704)

  • Index Cond: ((item_id = i_1.item_id) AND (link_type_id = $12))
53. 3,906.700 11,720.112 ↑ 15.0 1 3,906,704

Bitmap Heap Scan on t_item_link il_2 (cost=6.45..64.88 rows=15 width=4) (actual time=0.003..0.003 rows=1 loops=3,906,704)

  • Recheck Cond: ((i_1.item_id = item_id) AND (link_type_id = $14))
  • Heap Blocks: exact=3,906,704
54.          

Initplan (for Bitmap Heap Scan)

55. 0.004 0.004 ↑ 1.0 1 1

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

  • Filter: ((brief)::text = 'SHIRT_ARTICLE_FIBER_CODE_LINK'::text)
  • Rows Removed by Filter: 10
56. 7,813.408 7,813.408 ↑ 15.0 1 3,906,704

Bitmap Index Scan on il_filter_idx (cost=0.00..5.31 rows=15 width=0) (actual time=0.002..0.002 rows=1 loops=3,906,704)

  • Index Cond: ((item_id = i_1.item_id) AND (link_type_id = $14))
57.          

SubPlan (for Nested Loop)

58. 14.917 59.668 ↓ 0.0 0 14,917

Nested Loop (cost=0.42..13.53 rows=1 width=5) (actual time=0.004..0.004 rows=0 loops=14,917)

  • Join Filter: (pl.pl_id = p_2.pl_id)
59. 14.917 14.917 ↑ 1.0 1 14,917

Seq Scan on t_pl p_2 (cost=0.00..1.05 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=14,917)

  • Filter: (brief = 'MAIN_PRICE'::text)
  • Rows Removed by Filter: 3
60. 29.834 29.834 ↓ 0.0 0 14,917

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=14,917)

  • Index Cond: (item_id = i_1.item_id)
61. 10.792 59.356 ↑ 1.0 1 5,396

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

62. 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_6.prop_id = p_8.prop_id)
  • Rows Removed by Join Filter: 3
63. 10.792 10.792 ↑ 1.0 1 5,396

Seq Scan on t_prop p_8 (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
64. 21.584 21.584 ↑ 1.2 4 5,396

Index Scan using t_item_prop_item_id_idx on t_item_prop ip_6 (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)
65. 10.792 10.792 ↑ 1.0 1 5,396

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

  • Index Cond: (prop_value_id = ip_6.prop_value_id)
  • Filter: (ip_6.prop_id = prop_id)
66. 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)

67. 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_2.prop_id = p_3.prop_id)
  • Rows Removed by Join Filter: 3
68. 10.792 10.792 ↑ 1.0 1 5,396

Seq Scan on t_prop p_3 (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
69. 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)
70. 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)
71. 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)

72. 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_3.prop_id = p_4.prop_id)
  • Rows Removed by Join Filter: 3
73. 10.792 10.792 ↑ 1.0 1 5,396

Seq Scan on t_prop p_4 (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
74. 16.188 16.188 ↑ 1.2 4 5,396

Index Scan using t_item_prop_item_id_idx on t_item_prop ip_3 (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)
75. 5.396 5.396 ↑ 1.0 1 5,396

Index Scan using t_prop_value_pkey on t_prop_value pv_3 (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_3.prop_value_id)
  • Filter: (ip_3.prop_id = prop_id)
76. 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)

77. 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_4.prop_id = p_5.prop_id)
  • Rows Removed by Join Filter: 3
78. 10.792 10.792 ↑ 1.0 1 5,396

Seq Scan on t_prop p_5 (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
79. 16.188 16.188 ↑ 1.2 4 5,396

Index Scan using t_item_prop_item_id_idx on t_item_prop ip_4 (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)
80. 5.396 5.396 ↑ 1.0 1 5,396

Index Scan using t_prop_value_pkey on t_prop_value pv_4 (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_4.prop_value_id)
  • Filter: (ip_4.prop_id = prop_id)
81. 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_1.pl_id = p_6.pl_id)
82. 5.396 5.396 ↑ 1.0 1 5,396

Seq Scan on t_pl p_6 (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
83. 10.792 10.792 ↓ 0.0 0 5,396

Index Scan using pl_item on t_pline pl_1 (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)
84. 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)
85. 5.391 16.188 ↑ 15.0 1 5,396

Bitmap Heap Scan on t_item_link il_4 (cost=6.45..64.88 rows=15 width=4) (actual time=0.003..0.003 rows=1 loops=5,396)

  • Recheck Cond: ((i.item_id = item_id) AND (link_type_id = $31))
  • Heap Blocks: exact=5,396
86.          

Initplan (for Bitmap Heap Scan)

87. 0.005 0.005 ↑ 1.0 1 1

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

  • Filter: ((brief)::text = 'SHIRT_ARTICLE_FIBER_CODE_LINK'::text)
  • Rows Removed by Filter: 10
88. 10.792 10.792 ↑ 15.0 1 5,396

Bitmap Index Scan on il_filter_idx (cost=0.00..5.31 rows=15 width=0) (actual time=0.002..0.002 rows=1 loops=5,396)

  • Index Cond: ((item_id = i.item_id) AND (link_type_id = $31))
89. 10.792 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)

90. 10.792 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_5.prop_id = p_7.prop_id)
  • Rows Removed by Join Filter: 3
91. 10.792 10.792 ↑ 1.0 1 5,396

Seq Scan on t_prop p_7 (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
92. 16.188 16.188 ↑ 1.2 4 5,396

Index Scan using t_item_prop_item_id_idx on t_item_prop ip_5 (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)
93. 5.396 5.396 ↑ 1.0 1 5,396

Index Scan using t_prop_value_pkey on t_prop_value pv_5 (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_5.prop_value_id)
  • Filter: (ip_5.prop_id = prop_id)
Planning time : 3.595 ms
Execution time : 48,175.520 ms