explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UUWH

Settings
# exclusive inclusive rows x rows loops node
1. 23.900 184,720.507 ↓ 4,104.0 4,104 1

Sort (cost=1,121.45..1,121.46 rows=1 width=1,444) (actual time=184,720.103..184,720.507 rows=4,104 loops=1)

  • Sort Key: c.id
  • Sort Method: quicksort Memory: 4361kB
2. 31.752 184,696.607 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,113.08..1,121.44 rows=1 width=1,444) (actual time=210.755..184,696.607 rows=4,104 loops=1)

3. 8.990 739.991 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,106.78..1,112.45 rows=1 width=1,438) (actual time=163.458..739.991 rows=4,104 loops=1)

4. 8.577 628.401 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,098.24..1,103.88 rows=1 width=1,358) (actual time=163.396..628.401 rows=4,104 loops=1)

5. 10.156 566.472 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,089.71..1,095.31 rows=1 width=1,262) (actual time=163.360..566.472 rows=4,104 loops=1)

6. 8.337 453.716 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,084.30..1,089.87 rows=1 width=1,215) (actual time=163.266..453.716 rows=4,104 loops=1)

7. 7.248 441.275 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,084.03..1,089.56 rows=1 width=1,127) (actual time=163.263..441.275 rows=4,104 loops=1)

8. 8.702 421.715 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,083.76..1,089.24 rows=1 width=1,039) (actual time=163.259..421.715 rows=4,104 loops=1)

9. 7.054 396.597 ↓ 4,104.0 4,104 1

Nested Loop (cost=1,083.48..1,088.93 rows=1 width=1,048) (actual time=163.250..396.597 rows=4,104 loops=1)

10. 7.103 369.023 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,083.06..1,087.50 rows=1 width=1,032) (actual time=163.245..369.023 rows=4,104 loops=1)

11. 8.879 341.400 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,082.64..1,085.19 rows=1 width=974) (actual time=163.237..341.400 rows=4,104 loops=1)

12. 10.594 332.521 ↓ 4,104.0 4,104 1

Nested Loop (cost=1,082.51..1,085.03 rows=1 width=458) (actual time=163.235..332.521 rows=4,104 loops=1)

13. 4.076 297.303 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,082.08..1,084.52 rows=1 width=184) (actual time=163.228..297.303 rows=4,104 loops=1)

  • Join Filter: (f.id = f_2.id)
14. 7.921 289.123 ↓ 4,104.0 4,104 1

Nested Loop (cost=1,014.84..1,017.23 rows=1 width=152) (actual time=163.214..289.123 rows=4,104 loops=1)

15. 5.707 256.578 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,014.42..1,016.74 rows=1 width=104) (actual time=163.194..256.578 rows=4,104 loops=1)

16. 8.636 222.143 ↓ 4,104.0 4,104 1

Nested Loop (cost=1,013.99..1,016.25 rows=1 width=88) (actual time=163.189..222.143 rows=4,104 loops=1)

17. 2.088 184.779 ↓ 4,104.0 4,104 1

Limit (cost=1,013.57..1,013.60 rows=1 width=101) (actual time=163.181..184.779 rows=4,104 loops=1)

18.          

Initplan (for Limit)

19. 0.006 0.030 ↑ 1.0 1 1

Nested Loop (cost=0.42..5.27 rows=1 width=32) (actual time=0.024..0.030 rows=1 loops=1)

20. 0.019 0.019 ↑ 1.0 1 1

Index Scan using i__retailstore__account_id on retailstore r_2 (cost=0.14..2.37 rows=1 width=16) (actual time=0.014..0.019 rows=1 loops=1)

  • Index Cond: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
  • Filter: (id = 'ca3e93a6-dec1-11e8-9ff4-34e8000ae1e1'::uuid)
  • Rows Removed by Filter: 1
21. 0.005 0.005 ↑ 1.0 1 1

Index Scan using place_pkey on place p_5 (cost=0.28..2.50 rows=1 width=69) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = r_2.warehouse_id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
22. 17.421 182.661 ↓ 4,104.0 4,104 1

GroupAggregate (cost=1,008.30..1,008.33 rows=1 width=101) (actual time=163.180..182.661 rows=4,104 loops=1)

  • Group Key: c_1.id, f_1.id, g_1.dtype
23. 4.857 165.240 ↓ 4,104.0 4,104 1

Sort (cost=1,008.30..1,008.30 rows=1 width=41) (actual time=163.170..165.240 rows=4,104 loops=1)

  • Sort Key: c_1.id, f_1.id, g_1.dtype
  • Sort Method: quicksort Memory: 513kB
24. 21.098 160.383 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1.97..1,008.29 rows=1 width=41) (actual time=0.133..160.383 rows=4,104 loops=1)

  • Filter: (((cost.account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid) AND (cost.momentto = 'infinity'::timestamp without time zone) AND (cost.initialcost_id IS NULL) AND (cost.motion_id IS NOT NULL) AND cost.isvalid AND (cost.stock <> '0'::numeric) AND ((g_1.dtype)::text = 'Good'::text) AND (((p.path)::text || (p.id)::text) ~~ $10)) OR ((cost.consignment_id IS NULL) AND ((g_1.dtype)::text <> 'Good'::text)))
  • Rows Removed by Filter: 11878
25. 16.611 123.303 ↓ 15,982.0 15,982 1

Nested Loop Left Join (cost=1.70..1,007.96 rows=1 width=130) (actual time=0.087..123.303 rows=15,982 loops=1)

  • Filter: (((COALESCE(cost.stock, '0'::numeric) > '0'::numeric) AND ((g_1.dtype)::text = 'Good'::text)) OR ((g_1.dtype)::text <> 'Good'::text))
  • Rows Removed by Filter: 6903
26. 4.513 55.572 ↓ 10,224.0 10,224 1

Nested Loop (cost=1.27..992.13 rows=1 width=37) (actual time=0.064..55.572 rows=10,224 loops=1)

27. 3.267 20.387 ↓ 10,224.0 10,224 1

Nested Loop (cost=0.84..990.78 rows=1 width=21) (actual time=0.048..20.387 rows=10,224 loops=1)

28. 4.304 4.304 ↓ 200.2 1,602 1

Index Scan using i__good__account_id on good g_1 (cost=0.42..960.61 rows=8 width=21) (actual time=0.031..4.304 rows=1,602 loops=1)

  • Index Cond: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
  • Filter: ((NOT archived) AND (((path)::text ~~ '/d1806e1f-0f29-11e8-9ff4-34e800011aa2%'::text) OR ((path)::text ~~ '/0b4b0985-0f29-11e8-9107-50480002c614%'::text) OR ((path)::text ~~ '/51b0f0ab-0f29-11e8-9107-50480002c892%'::text) OR ((path)::text ~~ '/4d46d949-18c6-11e8-9107-5048001df1aa%'::text) OR ((path)::text ~~ '/cafd4c42-0f28-11e8-9ff4-34e80002c2ab%'::text) OR ((path)::text ~~ '/13e59efb-0f29-11e8-9107-50480002c659%'::text) OR ((path)::text ~~ '/97cab9e6-0f28-11e8-9107-504800013eba%'::text) OR ((path)::text ~~ '/5ca8d9d4-1977-11e8-9ff4-34e80021f2f3%'::text) OR ((path)::text ~~ '/fdae9a26-0f28-11e8-9ff4-34e8000110d5%'::text) OR ((path)::text ~~ '/3896e460-0f28-11e8-9ff4-34e8000109a2%'::text)))
  • Rows Removed by Filter: 143
29. 12.816 12.816 ↓ 6.0 6 1,602

Index Scan using i__feature__parent_id on feature f_1 (cost=0.42..3.76 rows=1 width=32) (actual time=0.005..0.008 rows=6 loops=1,602)

  • Index Cond: (parent_id = g_1.id)
  • Filter: ((NOT archived) AND (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid))
30. 30.672 30.672 ↑ 1.0 1 10,224

Index Scan using i_consignment_feature_id on consignment c_1 (cost=0.42..1.34 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=10,224)

  • Index Cond: (feature_id = f_1.id)
  • Filter: (isdefault AND (id > '00000000-0000-0000-0000-000000000000'::uuid) AND (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid))
31. 51.120 51.120 ↑ 20.5 2 10,224

Index Scan using i__cost__consignment_id on cost (cost=0.43..15.12 rows=41 width=93) (actual time=0.003..0.005 rows=2 loops=10,224)

  • Index Cond: (c_1.id = consignment_id)
32. 15.982 15.982 ↑ 1.0 1 15,982

Index Scan using place_pkey on place p (cost=0.28..0.29 rows=1 width=69) (actual time=0.001..0.001 rows=1 loops=15,982)

  • Index Cond: (cost.store_id = id)
33. 28.728 28.728 ↑ 1.0 1 4,104

Index Scan using pk__feature on feature f (cost=0.42..2.64 rows=1 width=56) (actual time=0.007..0.007 rows=1 loops=4,104)

  • Index Cond: (id = f_1.id)
34. 28.728 28.728 ↑ 1.0 1 4,104

Index Scan using i_consignment_feature_id on consignment c (cost=0.42..0.49 rows=1 width=32) (actual time=0.006..0.007 rows=1 loops=4,104)

  • Index Cond: (feature_id = f.id)
  • Filter: (isdefault AND (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid))
35. 24.624 24.624 ↑ 1.0 1 4,104

Index Scan using u__feature__default on feature deffeature (cost=0.42..0.49 rows=1 width=48) (actual time=0.006..0.006 rows=1 loops=4,104)

  • Index Cond: (parent_id = f.parent_id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
36. 4.104 4.104 ↓ 0.0 0 4,104

GroupAggregate (cost=67.24..67.27 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=4,104)

  • Group Key: f_2.id
37.          

Initplan (for GroupAggregate)

38. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..5.27 rows=1 width=32) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Index Scan using i__retailstore__account_id on retailstore r_1 (cost=0.14..2.37 rows=1 width=16) (never executed)

  • Index Cond: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
  • Filter: (id = 'ca3e93a6-dec1-11e8-9ff4-34e8000ae1e1'::uuid)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using place_pkey on place p_4 (cost=0.28..2.50 rows=1 width=69) (never executed)

  • Index Cond: (id = r_1.warehouse_id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
41. 0.000 0.000 ↓ 0.0 0 4,104

Sort (cost=61.97..61.98 rows=1 width=19) (actual time=0.000..0.000 rows=0 loops=4,104)

  • Sort Key: f_2.id
  • Sort Method: quicksort Memory: 25kB
42. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=2.09..61.96 rows=1 width=19) (actual time=0.006..0.006 rows=0 loops=1)

43. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.67..60.55 rows=1 width=35) (actual time=0.006..0.006 rows=0 loops=1)

44. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.25..60.06 rows=1 width=19) (actual time=0.006..0.006 rows=0 loops=1)

45. 0.000 0.005 ↓ 0.0 0 1

Nested Loop (cost=0.83..57.42 rows=1 width=19) (actual time=0.005..0.005 rows=0 loops=1)

46. 0.005 0.005 ↓ 0.0 0 1

Index Scan using i__reserve_momentto on reserve r (cost=0.55..25.00 rows=22 width=35) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: (isvalid AND (reservetype = 1))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using place_pkey on place p_1 (cost=0.28..1.45 rows=1 width=16) (never executed)

  • Index Cond: (id = r.store_id)
  • Filter: (((path)::text || (id)::text) ~~ $2)
48. 0.000 0.000 ↓ 0.0 0

Index Scan using consignment_pkey on consignment c_2 (cost=0.42..2.64 rows=1 width=32) (never executed)

  • Index Cond: (id = r.consignment_id)
49. 0.000 0.000 ↓ 0.0 0

Index Scan using pk__feature on feature f_2 (cost=0.42..0.49 rows=1 width=32) (never executed)

  • Index Cond: (id = c_2.feature_id)
  • Filter: ((NOT archived) AND (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid))
50. 0.000 0.000 ↓ 0.0 0

Index Scan using good_pkey on good g_2 (cost=0.42..1.40 rows=1 width=16) (never executed)

  • Index Cond: (id = f_2.parent_id)
  • Filter: ((NOT archived) AND (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid) AND ((dtype)::text = 'Good'::text))
51. 24.624 24.624 ↑ 1.0 1 4,104

Index Scan using good_pkey on good g (cost=0.42..0.50 rows=1 width=306) (actual time=0.006..0.006 rows=1 loops=4,104)

  • Index Cond: (id = f.parent_id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
52. 0.000 0.000 ↓ 0.0 0 4,104

Index Scan using taxsystem_pkey on taxsystem ts (cost=0.13..0.15 rows=1 width=532) (actual time=0.000..0.000 rows=0 loops=4,104)

  • Index Cond: (id = g.taxsystem_id)
53. 20.520 20.520 ↑ 1.0 1 4,104

Index Scan using good_pkey on good gf (cost=0.42..2.31 rows=1 width=74) (actual time=0.005..0.005 rows=1 loops=4,104)

  • Index Cond: (g.parent_id = id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
54. 20.520 20.520 ↑ 1.0 1 4,104

Index Scan using i_consignment_feature_id on consignment defgoodconsignment (cost=0.42..1.42 rows=1 width=32) (actual time=0.004..0.005 rows=1 loops=4,104)

  • Index Cond: (feature_id = deffeature.id)
  • Filter: (isdefault AND (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid))
55. 16.416 16.416 ↑ 1.0 1 4,104

Index Scan using uom_pkey on uom (cost=0.27..0.31 rows=1 width=23) (actual time=0.004..0.004 rows=1 loops=4,104)

  • Index Cond: (id = g.uom_id)
  • Filter: ((account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid) OR (account_id IS NULL))
56. 12.312 12.312 ↓ 0.0 0 4,104

Index Scan using assortmentfavorite_consignment_id_retailstore_id__unique on assortmentfavorite featurefavorite (cost=0.27..0.29 rows=1 width=104) (actual time=0.003..0.003 rows=0 loops=4,104)

  • Index Cond: ((consignment_id = c.id) AND (retailstore_id = 'ca3e93a6-dec1-11e8-9ff4-34e8000ae1e1'::uuid))
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
57. 4.104 4.104 ↓ 0.0 0 4,104

Index Scan using assortmentfavorite_consignment_id_retailstore_id__unique on assortmentfavorite goodfavorite (cost=0.27..0.29 rows=1 width=104) (actual time=0.001..0.001 rows=0 loops=4,104)

  • Index Cond: ((consignment_id = defgoodconsignment.id) AND (retailstore_id = 'ca3e93a6-dec1-11e8-9ff4-34e8000ae1e1'::uuid))
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
58. 41.040 102.600 ↑ 1.0 1 4,104

Aggregate (cost=5.41..5.42 rows=1 width=64) (actual time=0.025..0.025 rows=1 loops=4,104)

59. 12.880 61.560 ↑ 1.0 1 4,104

Nested Loop (cost=0.70..5.40 rows=1 width=58) (actual time=0.013..0.015 rows=1 loops=4,104)

60. 28.728 28.728 ↑ 1.0 1 4,104

Index Scan using u_featureattributevalue_account_feature_metadata on featureattributevalue fav (cost=0.42..2.64 rows=1 width=30) (actual time=0.006..0.007 rows=1 loops=4,104)

  • Index Cond: ((account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid) AND (f.id = parent_id))
61. 19.952 19.952 ↑ 1.0 1 4,988

Index Scan using attributemetadata_pkey on attributemetadata favm (cost=0.28..2.50 rows=1 width=44) (actual time=0.004..0.004 rows=1 loops=4,988)

  • Index Cond: (id = fav.metadata_id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
62. 20.520 53.352 ↑ 1.0 1 4,104

Aggregate (cost=8.54..8.55 rows=1 width=96) (actual time=0.013..0.013 rows=1 loops=4,104)

63. 3.780 32.832 ↓ 0.0 0 4,104

Nested Loop Left Join (cost=0.71..8.52 rows=1 width=43) (actual time=0.008..0.008 rows=0 loops=4,104)

  • Join Filter: (p_2.account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
64. 3.780 28.728 ↓ 0.0 0 4,104

Nested Loop (cost=0.57..6.14 rows=1 width=67) (actual time=0.007..0.007 rows=0 loops=4,104)

  • Join Filter: (p_2.pricetype_id = pt.id)
65. 24.624 24.624 ↓ 0.0 0 4,104

Index Scan using u__price__parent_id__pricetype_id on price p_2 (cost=0.42..3.77 rows=1 width=56) (actual time=0.006..0.006 rows=0 loops=4,104)

  • Index Cond: (parent_id = f.id)
  • Filter: ((value <> '0'::double precision) AND (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid))
  • Rows Removed by Filter: 1
66. 0.324 0.324 ↑ 1.0 1 108

Index Scan using i__pricetype__account_id on pricetype pt (cost=0.14..2.36 rows=1 width=43) (actual time=0.003..0.003 rows=1 loops=108)

  • Index Cond: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
67. 0.324 0.324 ↑ 1.0 1 108

Index Scan using currency_pkey on currency c_3 (cost=0.14..2.37 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=108)

  • Index Cond: (p_2.currency_id = id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
68. 36.936 102.600 ↑ 1.0 1 4,104

Aggregate (cost=8.53..8.54 rows=1 width=96) (actual time=0.025..0.025 rows=1 loops=4,104)

69. 4.104 65.664 ↑ 1.0 1 4,104

Result (cost=0.72..8.52 rows=1 width=43) (actual time=0.015..0.016 rows=1 loops=4,104)

  • One-Time Filter: (deffeature.account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
70. 8.208 61.560 ↑ 1.0 1 4,104

Nested Loop Left Join (cost=0.72..8.52 rows=1 width=43) (actual time=0.014..0.015 rows=1 loops=4,104)

  • Join Filter: (p_3.account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
71. 8.208 41.040 ↑ 1.0 1 4,104

Nested Loop (cost=0.57..6.14 rows=1 width=67) (actual time=0.009..0.010 rows=1 loops=4,104)

  • Join Filter: (p_3.pricetype_id = pt_1.id)
72. 20.520 20.520 ↑ 1.0 1 4,104

Index Scan using u__price__parent_id__pricetype_id on price p_3 (cost=0.42..3.76 rows=1 width=56) (actual time=0.004..0.005 rows=1 loops=4,104)

  • Index Cond: (parent_id = deffeature.id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
73. 12.312 12.312 ↑ 1.0 1 4,104

Index Scan using i__pricetype__account_id on pricetype pt_1 (cost=0.14..2.36 rows=1 width=43) (actual time=0.003..0.003 rows=1 loops=4,104)

  • Index Cond: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
74. 12.312 12.312 ↑ 1.0 1 4,104

Index Scan using currency_pkey on currency c_4 (cost=0.14..2.37 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=4,104)

  • Index Cond: (p_3.currency_id = id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
75. 12.312 183,863.304 ↑ 1.0 1 4,104

Aggregate (cost=6.30..6.31 rows=1 width=128) (actual time=44.801..44.801 rows=1 loops=4,104)

76. 28.728 183,850.992 ↓ 0.0 0 4,104

Merge Right Join (cost=5.43..6.27 rows=2 width=44) (actual time=44.798..44.798 rows=0 loops=4,104)

  • Merge Cond: (bc.goodpack_id = gp.id)
77. 183,756.600 183,756.600 ↑ 11,672.0 1 4,104

Index Scan using i__barcode__goodpack_id on barcode bc (cost=0.42..9,577.54 rows=11,672 width=29) (actual time=44.775..44.775 rows=1 loops=4,104)

  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
  • Rows Removed by Filter: 227351
78. 32.832 65.664 ↓ 0.0 0 4,104

Sort (cost=5.01..5.02 rows=1 width=31) (actual time=0.016..0.016 rows=0 loops=4,104)

  • Sort Key: gp.id
  • Sort Method: quicksort Memory: 25kB
79. 8.208 32.832 ↓ 0.0 0 4,104

Nested Loop Left Join (cost=0.55..5.00 rows=1 width=31) (actual time=0.008..0.008 rows=0 loops=4,104)

80. 24.624 24.624 ↓ 0.0 0 4,104

Index Scan using goodpack_good_index on goodpack gp (cost=0.28..2.50 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=4,104)

  • Index Cond: (good_id = g.id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
81. 0.000 0.000 ↓ 0.0 0

Index Scan using uom_pkey on uom uom_1 (cost=0.27..2.49 rows=1 width=23) (never executed)

  • Index Cond: (gp.uom_id = id)
82.          

SubPlan (for Nested Loop Left Join)

83. 36.936 61.560 ↑ 1.0 1 4,104

Aggregate (cost=2.64..2.65 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=4,104)

84. 24.624 24.624 ↑ 1.0 1 4,104

Index Scan using i__barcode__consignment_id on barcode bc_1 (cost=0.42..2.64 rows=1 width=13) (actual time=0.006..0.006 rows=1 loops=4,104)

  • Index Cond: ((account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid) AND (consignment_id = c.id))
Planning time : 102.069 ms
Execution time : 184,721.929 ms