explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uClQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.057 1,250.832 ↑ 883.5 13 1

GroupAggregate (cost=1,217,605.26..1,221,476.59 rows=11,486 width=572) (actual time=1,250.811..1,250.832 rows=13 loops=1)

  • Group Key: t.user_bo_id, (CASE WHEN (p.shop_id > 100) THEN s.id ELSE 1 END), (date(t.date_end)), (sum(CASE WHEN ((store.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((box.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((e.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((inst.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((m2.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((m3.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((m4.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((bhl.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((top2.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((zz.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((pik1.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((pik2.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((mez.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((g_1.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((gold.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((shelf.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((yv1.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((yv2.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((yv3.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((shoes.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((mez3.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((mez4.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (count(box.id)), (count(e.id)), (count(inst.id)), (count(m2.id)), (count(m3.id)), (count(m4.id)), (count(bhl.id)), (count(top2.id)), (count(zz.id)), (count(pik1.id)), (count(pik2.id)), (count(mez.id)), (count(g_1.id)), (count(gold.id)), (count(shelf.id)), (count(yv1.id)), (count(yv2.id)), (count(yv3.id)), (count(shoes.id)), (count(mez3.id)), (count(mez4.id)), (count(store.id)), (count(DISTINCT box.id)), (count(DISTINCT e.id)), (count(DISTINCT inst.id)), (count(DISTINCT m2.id)), (count(DISTINCT m3.id)), (count(DISTINCT m4.id)), (count(DISTINCT bhl.id)), (count(DISTINCT top2.id)), (count(DISTINCT zz.id)), (count(DISTINCT pik1.id)), (count(DISTINCT pik2.id)), (count(DISTINCT mez.id)), (count(DISTINCT g_1.id)), (count(DISTINCT gold.id)), (count(DISTINCT shelf.id)), (count(DISTINCT yv1.id)), (count(DISTINCT yv2.id)), (count(DISTINCT yv3.id)), (count(DISTINCT shoes.id)), (count(DISTINCT mez3.id)), (count(DISTINCT mez4.id)), (count(DISTINCT store.id))
2. 0.064 1,250.775 ↑ 1,498.6 13 1

Sort (cost=1,217,605.26..1,217,653.97 rows=19,482 width=554) (actual time=1,250.774..1,250.775 rows=13 loops=1)

  • Sort Key: t.user_bo_id, (CASE WHEN (p.shop_id > 100) THEN s.id ELSE 1 END), (date(t.date_end)), (sum(CASE WHEN ((store.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((box.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((e.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((inst.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((m2.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((m3.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((m4.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((bhl.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((top2.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((zz.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((pik1.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((pik2.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((mez.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((g_1.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((gold.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((shelf.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((yv1.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((yv2.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((yv3.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((shoes.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((mez3.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (sum(CASE WHEN ((mez4.id IS NOT NULL) AND (fl.flag_id IS NULL)) THEN t.cnt ELSE 0 END)), (count(box.id)), (count(e.id)), (count(inst.id)), (count(m2.id)), (count(m3.id)), (count(m4.id)), (count(bhl.id)), (count(top2.id)), (count(zz.id)), (count(pik1.id)), (count(pik2.id)), (count(mez.id)), (count(g_1.id)), (count(gold.id)), (count(shelf.id)), (count(yv1.id)), (count(yv2.id)), (count(yv3.id)), (count(shoes.id)), (count(mez3.id)), (count(mez4.id)), (count(store.id)), (count(DISTINCT box.id)), (count(DISTINCT e.id)), (count(DISTINCT inst.id)), (count(DISTINCT m2.id)), (count(DISTINCT m3.id)), (count(DISTINCT m4.id)), (count(DISTINCT bhl.id)), (count(DISTINCT top2.id)), (count(DISTINCT zz.id)), (count(DISTINCT pik1.id)), (count(DISTINCT pik2.id)), (count(DISTINCT mez.id)), (count(DISTINCT g_1.id)), (count(DISTINCT gold.id)), (count(DISTINCT shelf.id)), (count(DISTINCT yv1.id)), (count(DISTINCT yv2.id)), (count(DISTINCT yv3.id)), (count(DISTINCT shoes.id)), (count(DISTINCT mez3.id)), (count(DISTINCT mez4.id)), (count(DISTINCT store.id))
  • Sort Method: quicksort Memory: 38kB
3. 0.051 1,250.711 ↑ 1,498.6 13 1

Hash Join (cost=1,192,332.69..1,216,217.18 rows=19,482 width=554) (actual time=1,244.927..1,250.711 rows=13 loops=1)

  • Hash Cond: (t.user_bo_id = ubo.id)
4. 5.835 1,224.767 ↑ 8,835.3 13 1

GroupAggregate (cost=1,188,663.22..1,210,773.58 rows=114,859 width=548) (actual time=1,219.006..1,224.767 rows=13 loops=1)

  • Group Key: t.user_bo_id, (date(t.date_end)), p.shop_id, s.id
5. 1.436 1,218.932 ↑ 24.5 4,692 1

Sort (cost=1,188,663.22..1,188,950.37 rows=114,859 width=112) (actual time=1,218.655..1,218.932 rows=4,692 loops=1)

  • Sort Key: t.user_bo_id, (date(t.date_end)), p.shop_id, s.id
  • Sort Method: quicksort Memory: 559kB
6. 16.663 1,217.496 ↑ 24.5 4,692 1

Gather (cost=899,464.37..1,179,009.60 rows=114,859 width=112) (actual time=1,178.792..1,217.496 rows=4,692 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
7. 1.994 1,200.833 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,464.37..1,116,580.10 rows=19,143 width=112) (actual time=1,164.220..1,200.833 rows=670 loops=7)

8. 1.654 1,198.837 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,463.95..1,105,528.77 rows=19,143 width=116) (actual time=1,164.201..1,198.837 rows=670 loops=7)

9. 1.675 1,197.181 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,463.53..1,094,979.80 rows=19,143 width=112) (actual time=1,164.187..1,197.181 rows=670 loops=7)

10. 1.671 1,195.504 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,463.11..1,084,430.83 rows=19,143 width=108) (actual time=1,164.174..1,195.504 rows=670 loops=7)

11. 1.662 1,193.831 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,462.69..1,073,881.99 rows=19,143 width=104) (actual time=1,164.160..1,193.831 rows=670 loops=7)

12. 1.649 1,192.167 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,462.27..1,063,333.16 rows=19,143 width=100) (actual time=1,164.144..1,192.167 rows=670 loops=7)

13. 1.669 1,190.516 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,461.85..1,052,784.32 rows=19,143 width=96) (actual time=1,164.132..1,190.516 rows=670 loops=7)

14. 1.641 1,188.845 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,461.43..1,042,235.49 rows=19,143 width=92) (actual time=1,164.114..1,188.845 rows=670 loops=7)

15. 1.678 1,187.202 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,461.01..1,031,686.65 rows=19,143 width=88) (actual time=1,164.102..1,187.202 rows=670 loops=7)

16. 1.659 1,185.522 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,460.59..1,021,137.82 rows=19,143 width=84) (actual time=1,164.089..1,185.522 rows=670 loops=7)

17. 1.658 1,183.861 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,460.17..1,010,588.98 rows=19,143 width=80) (actual time=1,164.077..1,183.861 rows=670 loops=7)

18. 1.698 1,182.201 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,459.75..1,000,040.15 rows=19,143 width=76) (actual time=1,164.065..1,182.201 rows=670 loops=7)

19. 1.691 1,180.501 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,459.33..989,491.31 rows=19,143 width=72) (actual time=1,164.048..1,180.501 rows=670 loops=7)

20. 1.660 1,178.808 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,458.91..978,942.48 rows=19,143 width=68) (actual time=1,164.035..1,178.808 rows=670 loops=7)

21. 1.648 1,177.146 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,458.49..968,393.64 rows=19,143 width=64) (actual time=1,164.023..1,177.146 rows=670 loops=7)

22. 1.658 1,175.496 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,458.07..957,844.81 rows=19,143 width=60) (actual time=1,164.010..1,175.496 rows=670 loops=7)

23. 1.662 1,173.836 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,457.65..947,295.97 rows=19,143 width=56) (actual time=1,163.997..1,173.836 rows=670 loops=7)

24. 1.653 1,172.172 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,457.23..936,747.14 rows=19,143 width=52) (actual time=1,163.985..1,172.172 rows=670 loops=7)

25. 1.672 1,170.517 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,456.81..926,198.30 rows=19,143 width=48) (actual time=1,163.966..1,170.517 rows=670 loops=7)

26. 1.759 1,168.843 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,456.39..915,649.47 rows=19,143 width=44) (actual time=1,163.954..1,168.843 rows=670 loops=7)

27. 2.788 1,167.082 ↑ 28.6 670 7

Nested Loop Left Join (cost=894,455.97..905,100.63 rows=19,143 width=40) (actual time=1,163.937..1,167.082 rows=670 loops=7)

28. 0.211 1,164.290 ↑ 28.6 670 7

Merge Left Join (cost=894,455.55..894,551.80 rows=19,143 width=36) (actual time=1,163.905..1,164.290 rows=670 loops=7)

  • Merge Cond: (t.cell_from_id = m4.id)
29. 0.526 1,101.694 ↑ 28.6 670 7

Sort (cost=880,438.88..880,486.74 rows=19,143 width=32) (actual time=1,101.510..1,101.694 rows=670 loops=7)

  • Sort Key: t.cell_from_id
  • Sort Method: quicksort Memory: 77kB
  • Worker 0: Sort Method: quicksort Memory: 80kB
  • Worker 1: Sort Method: quicksort Memory: 76kB
  • Worker 2: Sort Method: quicksort Memory: 75kB
  • Worker 3: Sort Method: quicksort Memory: 74kB
  • Worker 4: Sort Method: quicksort Memory: 78kB
  • Worker 5: Sort Method: quicksort Memory: 77kB
30. 0.328 1,101.168 ↑ 28.6 670 7

Parallel Hash Left Join (cost=5,203.35..879,077.38 rows=19,143 width=32) (actual time=1,070.471..1,101.168 rows=670 loops=7)

  • Hash Cond: (t.product_id = fl.prod_id)
31. 0.338 1,099.479 ↑ 28.6 670 7

Hash Left Join (cost=393.97..874,195.75 rows=19,143 width=32) (actual time=1,068.978..1,099.479 rows=670 loops=7)

  • Hash Cond: ((p.shop_id)::text = s.catpro_p)
32. 3.767 1,098.569 ↑ 28.6 670 7

Nested Loop (cost=0.42..873,275.77 rows=19,143 width=28) (actual time=1,068.320..1,098.569 rows=670 loops=7)

33. 1,094.797 1,094.797 ↑ 28.6 670 7

Parallel Seq Scan on tbl_store_tasks t (cost=0.00..826,687.72 rows=19,143 width=24) (actual time=1,068.286..1,094.797 rows=670 loops=7)

  • Filter: ((user_bo_id IS NOT NULL) AND (category_id = 2) AND (status_id = 4) AND (date(date_end) >= '2019-06-30'::date) AND (date(date_end) <= '2019-06-30'::date))
  • Rows Removed by Filter: 4998238
34. 0.000 0.005 ↑ 2.0 1 4,692

Append (cost=0.42..2.41 rows=2 width=8) (actual time=0.003..0.005 rows=1 loops=4,692)

35. 0.003 0.003 ↑ 1.0 1 4,692

Index Scan using tbl_products_pkey on tbl_products p (cost=0.42..1.06 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=4,692)

  • Index Cond: (id = t.product_id)
36. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_products_int_pkey on tbl_products_int p_1 (cost=0.43..1.35 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.product_id)
37. 0.087 0.572 ↑ 5.2 444 7

Hash (cost=364.66..364.66 rows=2,311 width=10) (actual time=0.571..0.572 rows=444 loops=7)

  • Buckets: 4096 Batches: 1 Memory Usage: 51kB
38. 0.485 0.485 ↑ 5.2 444 7

Index Scan using tbl_suppliers_catpro_p_idx on tbl_suppliers s (cost=0.28..364.66 rows=2,311 width=10) (actual time=0.015..0.485 rows=444 loops=7)

39. 0.000 1.361 ↑ 2.0 53 7

Parallel Hash (cost=4,808.07..4,808.07 rows=105 width=8) (actual time=1.361..1.361 rows=53 loops=7)

  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
40. 0.000 3.098 ↓ 1.2 123 3

Parallel Append (cost=0.42..4,808.07 rows=105 width=8) (actual time=0.177..3.098 rows=123 loops=3)

41. 1.704 1.704 ↓ 1.2 119 3

Parallel Index Only Scan using bnd_prod_flags_idx on bnd_prod_flags fl (cost=0.42..2,485.26 rows=101 width=8) (actual time=0.084..1.704 rows=119 loops=3)

  • Index Cond: (flag_id = 3)
  • Heap Fetches: 227
42. 4.138 4.138 ↓ 3.2 13 1

Parallel Index Only Scan using bnd_prod_flags_int_idx on bnd_prod_flags_int fl_1 (cost=0.42..2,322.29 rows=4 width=8) (actual time=0.320..4.138 rows=13 loops=1)

  • Index Cond: (flag_id = 3)
  • Heap Fetches: 0
43. 0.039 62.385 ↑ 1.6 59 7

Sort (cost=14,016.66..14,016.91 rows=97 width=4) (actual time=62.380..62.385 rows=59 loops=7)

  • Sort Key: m4.id
  • Sort Method: quicksort Memory: 27kB
  • Worker 0: Sort Method: quicksort Memory: 27kB
  • Worker 1: Sort Method: quicksort Memory: 27kB
  • Worker 2: Sort Method: quicksort Memory: 27kB
  • Worker 3: Sort Method: quicksort Memory: 27kB
  • Worker 4: Sort Method: quicksort Memory: 27kB
  • Worker 5: Sort Method: quicksort Memory: 27kB
44. 62.346 62.346 ↑ 1.6 59 7

Seq Scan on tbl_store_cells m4 (cost=0.00..14,013.46 rows=97 width=4) (actual time=0.133..62.346 rows=59 loops=7)

  • Filter: (gathering_group = 'wms_priority_m4'::text)
  • Rows Removed by Filter: 196120
45. 0.004 0.004 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells box (cost=0.42..0.55 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_box'::text)
  • Rows Removed by Filter: 1
46. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells e (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_e'::text)
  • Rows Removed by Filter: 1
47. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells inst (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_inst'::text)
  • Rows Removed by Filter: 1
48. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells m2 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_m2'::text)
  • Rows Removed by Filter: 1
49. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells m3 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_m3'::text)
  • Rows Removed by Filter: 1
50. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells bhl (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_terminal_bhl'::text)
  • Rows Removed by Filter: 1
51. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells top2 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_terminal_top'::text)
  • Rows Removed by Filter: 1
52. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells zz (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_terminal_z'::text)
  • Rows Removed by Filter: 1
53. 0.002 0.002 ↑ 1.0 1 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells pik1 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_pik1'::text)
  • Rows Removed by Filter: 0
54. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells pik2 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_pik2'::text)
  • Rows Removed by Filter: 1
55. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells mez (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_mezonin'::text)
  • Rows Removed by Filter: 1
56. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells g_1 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_g'::text)
  • Rows Removed by Filter: 1
57. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells gold (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_gold'::text)
  • Rows Removed by Filter: 1
58. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells shelf (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_shelf'::text)
  • Rows Removed by Filter: 1
59. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells yv1 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_yv1'::text)
  • Rows Removed by Filter: 1
60. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells mez3 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_mezonin3'::text)
  • Rows Removed by Filter: 1
61. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells mez4 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_mezonin4'::text)
  • Rows Removed by Filter: 1
62. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells shoes (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_shoes'::text)
  • Rows Removed by Filter: 1
63. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells yv2 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_yv2'::text)
  • Rows Removed by Filter: 1
64. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells yv3 (cost=0.42..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: (gathering_group = 'wms_priority_yv3'::text)
  • Rows Removed by Filter: 1
65. 0.002 0.002 ↓ 0.0 0 4,692

Index Scan using tbl_store_cells_pkey on tbl_store_cells store (cost=0.42..0.57 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,692)

  • Index Cond: (id = t.cell_from_id)
  • Filter: ((gathering_group <> ALL ('{wms_priority_box,wms_priority_e,wms_priority_inst,wms_priority_m2,wms_priority_m3,wms_priority_m4,wms_terminal_bhl,wms_terminal_top,wms_terminal_z,wms_priority_pik1,wms_priority_pik2,wms_priority_mezonin,wms_priority_g,wms_priority_gold,wms_priority_shelf,wms_priority_yv1,wms_priority_yv2,wms_priority_yv3,wms_priority_mezonin3,wms_priority_mezonin4,wms_priority_shoes}'::text[])) OR ((gathering_group IS NULL) AND (id IS NOT NULL)))
  • Rows Removed by Filter: 1
66. 0.872 25.893 ↑ 1.0 4,069 1

Hash (cost=3,618.61..3,618.61 rows=4,069 width=18) (actual time=25.892..25.893 rows=4,069 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 218kB
67. 12.121 25.021 ↑ 1.0 4,069 1

Nested Loop Left Join (cost=0.28..3,618.61 rows=4,069 width=18) (actual time=0.192..25.021 rows=4,069 loops=1)

  • Join Filter: (g.key = ANY (ubo.groups))
  • Rows Removed by Join Filter: 48920
68. 8.831 8.831 ↑ 1.0 4,069 1

Seq Scan on tbl_user_bo ubo (cost=0.00..2,285.75 rows=4,069 width=108) (actual time=0.111..8.831 rows=4,069 loops=1)

  • Filter: ('sm_store'::text = ANY (groups))
  • Rows Removed by Filter: 19920
69. 3.979 4.069 ↑ 1.0 13 4,069

Materialize (cost=0.28..10.47 rows=13 width=14) (actual time=0.000..0.001 rows=13 loops=4,069)

70. 0.090 0.090 ↑ 1.0 13 1

Index Only Scan using lst_user_bo_groups_key_key on lst_user_bo_groups g (cost=0.28..10.40 rows=13 width=14) (actual time=0.050..0.090 rows=13 loops=1)

  • Index Cond: (key = ANY ('{wms_vls,wms_autlog,wms_gvardiya,wms_ekc,wms_inklin_service,wms_liderteam,wms_our_staff,wms_patriot,wms_staff_plus,wms_staff_plus_serv,wms_resource,wms_fresh,wms_shtat}'::text[]))
  • Heap Fetches: 0
Planning time : 1,023,047.498 ms
Execution time : 1,252.503 ms