explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Knba

Settings
# exclusive inclusive rows x rows loops node
1. 38.413 201,171.427 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,499.71..1,502.51 rows=1 width=1,444) (actual time=349.475..201,171.427 rows=4,104 loops=1)

2. 8.920 574.638 ↓ 4,104.0 4,104 1

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

3. 8.882 467.222 ↓ 4,104.0 4,104 1

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

4. 10.624 404.988 ↓ 4,104.0 4,104 1

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

5. 10.092 295.868 ↓ 4,104.0 4,104 1

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

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

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

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

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

8. 3.925 263.525 ↓ 4,104.0 4,104 1

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

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

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

10. 3.332 249.700 ↓ 4,104.0 4,104 1

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

11. 1.695 246.368 ↓ 4,104.0 4,104 1

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

12. 1.046 232.361 ↓ 4,104.0 4,104 1

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

13. 7.430 219.003 ↓ 4,104.0 4,104 1

Nested Loop Left Join (cost=1,053.47..1,056.84 rows=1 width=240) (actual time=165.524..219.003 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. 1.027 211.573 ↓ 4,104.0 4,104 1

Nested Loop (cost=1,053.20..1,056.53 rows=1 width=152) (actual time=165.519..211.573 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. 0.457 198.234 ↓ 4,104.0 4,104 1

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

16. 1.749 185.465 ↓ 4,104.0 4,104 1

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

17. 0.505 171.404 ↓ 4,104.0 4,104 1

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

18.          

Initplan (for Limit)

19. 0.005 0.023 ↑ 1.0 1 1

Nested Loop (cost=0.42..5.72 rows=1 width=32) (actual time=0.020..0.023 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.815 170.876 ↓ 4,104.0 4,104 1

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

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

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

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

Nested Loop Left Join (cost=1.97..1,046.20 rows=1 width=41) (actual time=0.108..162.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 (...)
  • Rows Removed by Filter: 11,878
25. 59.081 124.425 ↓ 15,982.0 15,982 1

Nested Loop Left Join (cost=1.70..1,045.88 rows=1 width=130) (actual time=0.067..124.425 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. 40.950 65.344 ↓ 10,224.0 10,224 1

Nested Loop (cost=1.27..1,018.79 rows=1 width=37) (actual time=0.054..65.344 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. 24.394 24.394 ↓ 10,224.0 10,224 1

Nested Loop (cost=0.84..1,017.11 rows=1 width=21) (actual time=0.042..24.394 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.029..3.632 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.005..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. 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)
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.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)

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

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

46. 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))
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.019 0.058 ↓ 17.0 17 1

Sort (cost=6.04..6.04 rows=1 width=104) (actual time=0.052..0.058 rows=17 loops=1)

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

Seq Scan on assortmentfavorite featurefavorite (cost=0.00..6.03 rows=1 width=104) (actual time=0.026..0.039 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. 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)

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

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

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

65. 8.208 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)
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.014..0.014 rows=1 loops=4,104)

  • Join Filter: (p_3.account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
67. 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)
68. 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)
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,228.520 200,476.296 ↑ 1.0 1 4,104

Aggregate (cost=342.49..342.50 rows=1 width=128) (actual time=48.849..48.849 rows=1 loops=4,104)

72. 7,103.817 192,247.776 ↑ 1.0 4,989 4,104

Hash Left Join (cost=17.28..292.59 rows=4,989 width=44) (actual time=41.708..46.844 rows=4,989 loops=4,104)

  • Hash Cond: (gp.uom_id = uom_1.id)
73. 4,502.088 185,143.752 ↑ 1.0 4,989 4,104

Merge Left Join (cost=0.70..213.15 rows=4,989 width=53) (actual time=41.705..45.113 rows=4,989 loops=4,104)

  • Merge Cond: (gp.id = bc.goodpack_id)
  • Join Filter: ((gp.good_id = g.id) AND (gp.account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid))
74. 9,517.176 9,517.176 ↑ 1.0 4,989 4,104

Index Scan using goodpack_pkey on goodpack gp (cost=0.28..199.42 rows=4,989 width=72) (actual time=0.006..2.319 rows=4,989 loops=4,104)

75. 171,124.488 171,124.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=41.697..41.697 rows=1 loops=4,104)

  • Filter: (account_id = '01733d5f-0e6b-11e8-7a69-9711001d1ead'::uuid)
  • Rows Removed by Filter: 227,351
76. 0.103 0.207 ↑ 1.0 381 1

Hash (cost=11.81..11.81 rows=381 width=23) (actual time=0.207..0.207 rows=381 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 29kB
77. 0.104 0.104 ↑ 1.0 381 1

Seq Scan on uom uom_1 (cost=0.00..11.81 rows=381 width=23) (actual time=0.012..0.104 rows=381 loops=1)

78.          

SubPlan (for Nested Loop Left Join)

79. 49.248 82.080 ↑ 1.0 1 4,104

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

80. 32.832 32.832 ↑ 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.008..0.008 rows=1 loops=4,104)

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