explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LasX9

Settings
# exclusive inclusive rows x rows loops node
1. 27.827 175,651.141 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,163.52..1,166.33 rows=1 width=1,444) (actual time=317.821..175,651.141 rows=4,104 loops=1)

2. 9.636 550.778 ↓ 4,104.0 4,104 1

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

3. 9.298 446.750 ↓ 4,104.0 4,104 1

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

4. 12.089 388.204 ↓ 4,104.0 4,104 1

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

5. 9.323 285.827 ↓ 4,104.0 4,104 1

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

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

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

  • Sort Key: c.id
  • Sort Method: quicksort Memory: 2,310kB
7. 4.767 268.507 ↓ 4,104.0 4,104 1

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

8. 3.783 255.532 ↓ 4,104.0 4,104 1

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

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

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

10. 3.263 242.406 ↓ 4,104.0 4,104 1

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

11. 1.388 239.143 ↓ 4,104.0 4,104 1

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

12. 0.684 225.443 ↓ 4,104.0 4,104 1

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

13. 7.081 212.447 ↓ 4,104.0 4,104 1

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

  • -> 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 (...)
14. 0.540 205.366 ↓ 4,104.0 4,104 1

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

  • Index Cond: ((consignment_id = defgoodconsignment.id) AND (retailstore_id = 'ca3e93a6-dec1-11e8-9ff4-34e8000ae1e1'::uuid))
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
15. 4.147 192.514 ↓ 4,104.0 4,104 1

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

16. 1.051 180.159 ↓ 4,104.0 4,104 1

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

17. 0.482 166.796 ↓ 4,104.0 4,104 1

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

18.          

Initplan (for Limit)

19. 0.004 0.022 ↑ 1.0 1 1

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

20. 0.012 0.012 ↑ 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.010..0.012 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'0000000000000000000000000010100000000001000000000000000000 (...)
  • Rows Removed by Filter: 1
21. 0.006 0.006 ↑ 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.006..0.006 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'00000000000000000000000000101000000000010000000000 (...)
22. 4.727 166.292 ↓ 4,104.0 4,104 1

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

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

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

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

Nested Loop Left Join (cost=1.97..1,046.20 rows=1 width=41) (actual time=0.105..158.052 rows=4,104 loops=1)

  • Filter: (((cost.account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid) AND (cost.momentto = 'infinity'::timestamp without time zone) AND (...)
  • Rows Removed by Filter: 11,878
25. 57.872 120.925 ↓ 15,982.0 15,982 1

Nested Loop Left Join (cost=1.70..1,045.88 rows=1 width=130) (actual time=0.065..120.925 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': (...)
  • Rows Removed by Filter: 6,903
  • -> 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 (...)
26. 39.374 63.053 ↓ 10,224.0 10,224 1

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

  • -> 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.003 ro (...)
  • Index Cond: (c_1.id = consignment_id)
27. 23.679 23.679 ↓ 10,224.0 10,224 1

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

  • -> Index Scan using i__good__account_id on good g_1 (cost=0.42..1001.65 rows=4 width=21) (actual time=0.028..3.663 rows= (...)
  • 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 ~~ '/ (...)
  • Rows Removed by Filter: 143
  • -> Index Scan using i__feature__parent_id on feature f_1 (cost=0.42..3.86 rows=1 width=32) (actual time=0.004..0.011 row (...)
  • 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'000 (...)
  • Index Cond: (feature_id = f_1.id)
  • Filter: (isdefault AND (id > '00000000-0000-0000-0000-000000000000'::uuid) AND (account_id = '01733d5f-0e6b-11e8-7a69-9711 (...)
28. 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)
29. 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)
30. 8.208 8.208 ↑ 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.002..0.002 rows=1 loops=4,104)

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

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

  • Index Cond: (feature_id = f.id)
  • Filter: (isdefault AND (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid))
33. 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)
34. 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)
35. 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))
36. 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
37.          

Initplan (for GroupAggregate)

38. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..5.72 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.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'0000000000000000000000000010100000000001000000000000000000000000000000000000000000000000000000000000000000 (...)
40. 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'00000000000000000000000000101000000000010000000000000000000000000000000000000000000000000000000000 (...)
41. 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
42. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=2.09..62.28 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.60 rows=1 width=35) (actual time=0.006..0.006 rows=0 loops=1)

44. 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)

45. 0.001 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)

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.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'000000000000000000000000001010000000000100000000000000000000000000000 (...)
50. 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_bit(B'0000000000000000000000000010100000000001 (...)
51. 8.208 8.208 ↑ 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.002..0.002 rows=1 loops=4,104)

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

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

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

Seq Scan on assortmentfavorite featurefavorite (cost=0.00..6.03 rows=1 width=104) (actual time=0.024..0.037 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
54. 36.936 90.288 ↑ 1.0 1 4,104

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

55. 8.776 53.352 ↑ 1.0 1 4,104

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

56. 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))
57. 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)
58. 20.520 49.248 ↑ 1.0 1 4,104

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

59. 0.000 28.728 ↓ 0.0 0 4,104

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

  • Join Filter: (p_2.account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
60. 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)
61. 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
62. 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)
63. 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)
64. 32.832 94.392 ↑ 1.0 1 4,104

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

65. 4.104 61.560 ↑ 1.0 1 4,104

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

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

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

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

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

  • Join Filter: (p_3.pricetype_id = pt_1.id)
68. 16.416 16.416 ↑ 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.004 rows=1 loops=4,104)

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

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

72. 20.520 175,006.872 ↓ 0.0 0 4,104

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

  • Merge Cond: (bc.goodpack_id = gp.id)
73. 174,924.792 174,924.792 ↑ 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.623..42.623 rows=1 loops=4,104)

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

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

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

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

76. 20.520 20.520 ↓ 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.005..0.005 rows=0 loops=4,104)

  • Index Cond: (good_id = g.id)
  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
77. 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)
78.          

SubPlan (for Nested Loop Left Join)

79. 32.832 57.456 ↑ 1.0 1 4,104

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

80. 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 : 91.405 ms
Execution time : 175,654.012 ms