explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X4gv

Settings
# exclusive inclusive rows x rows loops node
1. 27.407 176,513.153 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,163.52..1,166.33 rows=1 width=1,444) (actual time=341.848..176,513.153 rows=4,104 loops=1)

2. 10.249 584.202 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,157.22..1,157.33 rows=1 width=1,438) (actual time=293.737..584.202 rows=4,104 loops=1)

3. 7.118 475.457 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,148.68..1,148.77 rows=1 width=1,358) (actual time=293.697..475.457 rows=4,104 loops=1)

4. 10.522 414.987 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,140.15..1,140.20 rows=1 width=1,262) (actual time=293.676..414.987 rows=4,104 loops=1)

5. 10.759 305.969 ↓ 4,104.0 4,104 1

Merge Left Join (cost=1,134.73..1,134.76 rows=1 width=1,215) (actual time=293.634..305.969 rows=4,104 loops=1)

  • Merge Cond: (c.id = featurefavorite.consignment_id)
6. 8.415 295.150 ↓ 4,104.0 4,104 1

Sort (cost=1,128.69..1,128.70 rows=1 width=1,127) (actual time=293.569..295.150 rows=4,104 loops=1)

  • Sort Key: c.id
  • Sort Method: quicksort Memory: 2310kB
7. 1.916 286.735 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,123.15..1,128.68 rows=1 width=1,127) (actual time=169.154..286.735 rows=4,104 loops=1)

8. 4.089 272.507 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,122.73..1,126.37 rows=1 width=1,069) (actual time=169.144..272.507 rows=4,104 loops=1)

  • Join Filter: (f.id = f_2.id)
9. 1.960 268.418 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,054.72..1,058.31 rows=1 width=1,037) (actual time=169.128..268.418 rows=4,104 loops=1)

10. 3.448 258.250 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,054.45..1,058.00 rows=1 width=1,046) (actual time=169.122..258.250 rows=4,104 loops=1)

11. 2.677 254.802 ↓ 4,104.0 4,104 1

Nested Loop (cost=1,054.31..1,057.84 rows=1 width=530) (actual time=169.119..254.802 rows=4,104 loops=1)

12. 1.845 239.813 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,053.89..1,057.34 rows=1 width=256) (actual time=169.111..239.813 rows=4,104 loops=1)

13. 3.577 225.656 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,053.47..1,056.84 rows=1 width=240) (actual time=169.107..225.656 rows=4,104 loops=1)

14. 14.306 217.975 ↓ 4,104.0 4,104 1

Nested Loop (cost=1,053.20..1,056.53 rows=1 width=152) (actual time=169.096..217.975 rows=4,104 loops=1)

  • -> Index Scan using i_consignment_feature_id on consignment defgoodconsignment (cost=0.42..1.42 rows=1 width=32) (actual time=0.
15. 1.126 203.669 ↓ 4,104.0 4,104 1

Nested Loop (cost=1,052.78..1,055.10 rows=1 width=136) (actual time=169.090..203.669 rows=4,104 loops=1)

  • Index Cond: (feature_id = deffeature.id)
  • Filter: (isdefault AND (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid))
16. 2.578 190.231 ↓ 4,104.0 4,104 1

Nested Loop (cost=1,052.35..1,054.61 rows=1 width=88) (actual time=169.083..190.231 rows=4,104 loops=1)

17. 0.580 175.341 ↓ 4,104.0 4,104 1

Limit (cost=1,051.93..1,051.96 rows=1 width=101) (actual time=169.075..175.341 rows=4,104 loops=1)

18.          

Initplan (for Limit)

19. 0.004 0.027 ↑ 1.0 1 1

Nested Loop (cost=0.42..5.72 rows=1 width=32) (actual time=0.025..0.027 rows=1 loops=1)

20. 0.015 0.015 ↑ 1.0 1 1

Index Scan using i__retailstore__account_id on retailstore r_2 (cost=0.14..2.41 rows=1 width=16) (actual time=0.012..0.015 rows=1 loops=1)

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

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

  • Index Cond: (id = r_2.warehouse_id)
  • Filter: ((account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid) AND CASE WHEN (get_bit(B'0000
22. 5.065 174.734 ↓ 4,104.0 4,104 1

GroupAggregate (cost=1,046.21..1,046.24 rows=1 width=101) (actual time=169.073..174.734 rows=4,104 loops=1)

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

Sort (cost=1,046.21..1,046.22 rows=1 width=41) (actual time=169.064..169.669 rows=4,104 loops=1)

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

Nested Loop Left Join (cost=1.97..1,046.20 rows=1 width=41) (actual time=0.124..165.930 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.pat
  • Rows Removed by Filter: 11878
25. 19.687 127.143 ↓ 15,982.0 15,982 1

Nested Loop Left Join (cost=1.70..1,045.88 rows=1 width=130) (actual time=0.076..127.143 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. 0.601 66.560 ↓ 10,224.0 10,224 1

Nested Loop (cost=1.27..1,018.79 rows=1 width=37) (actual time=0.059..66.560 rows=10,224 loops=1)

27. 2.096 25.063 ↓ 10,224.0 10,224 1

Nested Loop (cost=0.84..1,017.11 rows=1 width=21) (actual time=0.045..25.063 rows=10,224 loops=1)

28. 3.743 3.743 ↓ 400.5 1,602 1

Index Scan using i__good__account_id on good g_1 (cost=0.42..1,001.65 rows=4 width=21) (actual time=0.031..3.743 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)) AND CASE WHEN (get_bit(B'00000000000000000000000000101000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
  • Rows Removed by Filter: 143
29. 19.224 19.224 ↓ 6.0 6 1,602

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

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

Index Scan using i_consignment_feature_id on consignment c_1 (cost=0.42..1.66 rows=1 width=32) (actual time=0.003..0.004 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) AND CASE WHEN (get_bit(B'000000000000000000000000001010000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000
31. 40.896 40.896 ↑ 20.5 2 10,224

Index Scan using i__cost__consignment_id on cost (cost=0.43..26.37 rows=41 width=93) (actual time=0.003..0.004 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. 12.312 12.312 ↑ 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.003..0.003 rows=1 loops=4,104)

  • Index Cond: (id = f_1.id)
34. 12.312 12.312 ↑ 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.003..0.003 rows=1 loops=4,104)

  • Index Cond: (parent_id = f.parent_id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
35. 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)
36. 12.312 12.312 ↑ 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.003..0.003 rows=1 loops=4,104)

  • Index Cond: (feature_id = f.id)
  • Filter: (isdefault AND (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid))
37. 12.312 12.312 ↑ 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.003..0.003 rows=1 loops=4,104)

  • Index Cond: (id = f.parent_id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
38. 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)
39. 8.208 8.208 ↑ 1.0 1 4,104

Index Scan using uom_pkey on uom (cost=0.27..0.31 rows=1 width=23) (actual time=0.002..0.002 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))
40. 0.000 0.000 ↓ 0.0 0 4,104

GroupAggregate (cost=68.01..68.03 rows=1 width=48) (actual time=0.000..0.000 rows=0 loops=4,104)

  • Group Key: f_2.id
41.          

Initplan (for GroupAggregate)

42. 0.000 0.000 ↓ 0.0 0

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

43. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Sort (cost=62.29..62.30 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
46. 0.000 0.007 ↓ 0.0 0 1

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

47. 0.001 0.007 ↓ 0.0 0 1

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

48. 0.000 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)

49. 0.000 0.006 ↓ 0.0 0 1

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

50. 0.006 0.006 ↓ 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.006..0.006 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))
51. 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)
52. 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)
53. 0.000 0.000 ↓ 0.0 0

Index Scan using pk__feature on feature f_2 (cost=0.42..0.54 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) AND CASE WHEN (get_bit(B'00000000000000000000000
54. 0.000 0.000 ↓ 0.0 0

Index Scan using good_pkey on good g_2 (cost=0.42..1.67 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) AND CASE WHEN (get_
55. 12.312 12.312 ↑ 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.003..0.003 rows=1 loops=4,104)

  • Index Cond: (g.parent_id = id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
56. 0.020 0.060 ↓ 17.0 17 1

Sort (cost=6.04..6.04 rows=1 width=104) (actual time=0.054..0.060 rows=17 loops=1)

  • Sort Key: featurefavorite.consignment_id
  • Sort Method: quicksort Memory: 27kB
57. 0.040 0.040 ↓ 17.0 17 1

Seq Scan on assortmentfavorite featurefavorite (cost=0.00..6.03 rows=1 width=104) (actual time=0.026..0.040 rows=17 loops=1)

  • Filter: ((account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid) AND (retailstore_id = 'ca3e93a6-dec1-11e8-9ff4-34e8000ae1e1'::uuid))
  • Rows Removed by Filter: 185
58. 41.040 98.496 ↑ 1.0 1 4,104

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

59. 12.880 57.456 ↑ 1.0 1 4,104

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

60. 24.624 24.624 ↑ 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.006 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.012..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. 32.832 98.496 ↑ 1.0 1 4,104

Aggregate (cost=8.53..8.54 rows=1 width=96) (actual time=0.024..0.024 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. 12.312 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. 4.104 36.936 ↑ 1.0 1 4,104

Nested Loop (cost=0.57..6.14 rows=1 width=67) (actual time=0.009..0.009 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 175,839.984 ↑ 1.0 1 4,104

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

76. 20.520 175,827.672 ↓ 0.0 0 4,104

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

  • Merge Cond: (bc.goodpack_id = gp.id)
77. 175,741.488 175,741.488 ↑ 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=42.822..42.822 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 : 112.559 ms
Execution time : 176,516.178 ms