explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nn5H

Settings
# exclusive inclusive rows x rows loops node
1. 3.912 9,048.049 ↓ 1,000.0 1,000 1

Hash Right Join (cost=10,002,128,261.93..10,002,128,322.30 rows=1 width=1,674) (actual time=9,042.951..9,048.049 rows=1,000 loops=1)

  • Hash Cond: (__t3.id = __t11.uom_id)
2. 1.420 1.893 ↑ 1.0 95 1

Bitmap Heap Scan on uom __t3 (cost=4.32..63.91 rows=95 width=30) (actual time=0.641..1.893 rows=95 loops=1)

  • Recheck Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) OR (account_id IS NULL))
  • Heap Blocks: exact=13
3. 0.002 0.473 ↓ 0.0 0 1

BitmapOr (cost=4.32..4.32 rows=95 width=0) (actual time=0.473..0.473 rows=0 loops=1)

4. 0.043 0.043 ↑ 1.0 2 1

Bitmap Index Scan on i__uom__account_id (cost=0.00..1.79 rows=2 width=0) (actual time=0.043..0.043 rows=2 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
5. 0.428 0.428 ↑ 1.0 93 1

Bitmap Index Scan on i__uom__account_id (cost=0.00..2.48 rows=93 width=0) (actual time=0.428..0.428 rows=93 loops=1)

  • Index Cond: (account_id IS NULL)
6. 1.161 9,042.244 ↓ 1,000.0 1,000 1

Hash (cost=10,002,128,257.60..10,002,128,257.60 rows=1 width=1,556) (actual time=9,042.244..9,042.244 rows=1,000 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 629kB
7. 0.241 9,041.083 ↓ 1,000.0 1,000 1

Merge Left Join (cost=10,002,128,218.06..10,002,128,257.60 rows=1 width=1,556) (actual time=9,006.379..9,041.083 rows=1,000 loops=1)

  • Merge Cond: (__t13.id = __t13_2.id)
8. 0.222 9,040.679 ↓ 1,000.0 1,000 1

Merge Left Join (cost=10,002,126,899.66..10,002,126,939.14 rows=1 width=1,540) (actual time=9,006.213..9,040.679 rows=1,000 loops=1)

  • Merge Cond: (__t13.id = __t43.id)
9. 0.240 8,989.875 ↓ 1,000.0 1,000 1

Merge Left Join (cost=10,001,481,361.36..10,001,481,400.69 rows=1 width=1,508) (actual time=8,955.628..8,989.875 rows=1,000 loops=1)

  • Merge Cond: (__t13.id = __t37.id)
10. 0.474 8,937.569 ↓ 1,000.0 1,000 1

Merge Left Join (cost=10,000,835,805.74..10,000,835,844.91 rows=1 width=1,476) (actual time=8,903.557..8,937.569 rows=1,000 loops=1)

  • Merge Cond: (__t13.id = __t22.id)
  • Join Filter: ((__t11.dtype)::text = 'Good'::text)
11. 0.233 1,302.246 ↓ 1,000.0 1,000 1

Merge Left Join (cost=10,000,064,593.68..10,000,064,593.85 rows=1 width=1,444) (actual time=1,271.197..1,302.246 rows=1,000 loops=1)

  • Merge Cond: (__t13.id = __t14_3.id)
12. 0.417 1,301.963 ↓ 1,000.0 1,000 1

Merge Left Join (cost=10,000,062,889.61..10,000,062,889.73 rows=1 width=1,412) (actual time=1,271.144..1,301.963 rows=1,000 loops=1)

  • Merge Cond: (__t13.id = __t14_2.id)
13. 0.692 1,176.087 ↓ 1,000.0 1,000 1

Merge Left Join (cost=10,000,060,388.32..10,000,060,388.39 rows=1 width=1,380) (actual time=1,146.927..1,176.087 rows=1,000 loops=1)

  • Merge Cond: (__t13.id = __t13_1.id)
14. 0.919 959.812 ↓ 1,000.0 1,000 1

Sort (cost=10,000,058,034.42..10,000,058,034.42 rows=1 width=1,348) (actual time=959.722..959.812 rows=1,000 loops=1)

  • Sort Key: __t13.id
  • Sort Method: quicksort Memory: 515kB
15. 0.363 958.893 ↓ 1,000.0 1,000 1

Hash Left Join (cost=10,000,057,960.19..10,000,058,034.41 rows=1 width=1,348) (actual time=934.263..958.893 rows=1,000 loops=1)

  • Hash Cond: (__t11.id = __t7.good_id)
  • Join Filter: ((__t11.dtype)::text = 'Kit'::text)
16. 0.329 298.227 ↓ 1,000.0 1,000 1

Hash Left Join (cost=1,766.51..1,840.72 rows=1 width=1,332) (actual time=273.937..298.227 rows=1,000 loops=1)

  • Hash Cond: ((CASE WHEN ((NOT __t13.isdefault) AND (__t13.buycurrency_id IS NULL)) THEN __t14.buycurrency_id ELSE __t13.buycurrency_id END) = __t5.id)
17. 0.103 297.155 ↓ 1,000.0 1,000 1

Limit (cost=1,763.15..1,837.33 rows=1 width=1,340) (actual time=273.180..297.155 rows=1,000 loops=1)

18. 1.092 297.052 ↓ 1,000.0 1,000 1

Result (cost=1,763.15..1,837.33 rows=1 width=1,340) (actual time=273.179..297.052 rows=1,000 loops=1)

19. 2.767 273.121 ↓ 1,000.0 1,000 1

Sort (cost=1,763.15..1,763.15 rows=1 width=1,361) (actual time=272.985..273.121 rows=1,000 loops=1)

  • Sort Key: __t13.id
  • Sort Method: top-N heapsort Memory: 924kB
20. 1.251 270.354 ↓ 2,034.0 2,034 1

Hash Join (cost=939.88..1,763.14 rows=1 width=1,361) (actual time=266.924..270.354 rows=2,034 loops=1)

  • Hash Cond: (__t13.parent_id = __t11.id)
21. 2.928 6.782 ↓ 7.5 2,034 1

Bitmap Heap Scan on feature __t13 (cost=9.05..831.26 rows=270 width=260) (actual time=4.591..6.782 rows=2,034 loops=1)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: ((deleted IS NULL) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Heap Blocks: exact=1,314
22. 3.854 3.854 ↓ 3.8 2,035 1

Bitmap Index Scan on i__feature__account_id (cost=0.00..8.98 rows=540 width=0) (actual time=3.854..3.854 rows=2,035 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
23. 4.372 262.321 ↓ 2,034.0 2,034 1

Hash (cost=930.82..930.82 rows=1 width=537) (actual time=262.321..262.321 rows=2,034 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 777kB
24. 2.165 257.949 ↓ 2,034.0 2,034 1

Hash Join (cost=107.70..930.82 rows=1 width=537) (actual time=126.876..257.949 rows=2,034 loops=1)

  • Hash Cond: (__t14.parent_id = __t11.id)
25. 129.054 129.348 ↓ 8.4 2,034 1

Bitmap Heap Scan on feature __t14 (cost=9.04..831.25 rows=242 width=77) (actual time=0.433..129.348 rows=2,034 loops=1)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: (isdefault AND (deleted IS NULL) AND (NOT archived) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Heap Blocks: exact=1,314
26. 0.294 0.294 ↓ 3.8 2,035 1

Bitmap Index Scan on i__feature__account_id (cost=0.00..8.98 rows=540 width=0) (actual time=0.294..0.294 rows=2,035 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
27. 4.201 126.436 ↓ 88.4 2,034 1

Hash (cost=98.37..98.37 rows=23 width=460) (actual time=126.436..126.436 rows=2,034 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 627kB
28. 1.364 122.235 ↓ 88.4 2,034 1

Hash Left Join (cost=22.75..98.37 rows=23 width=460) (actual time=11.492..122.235 rows=2,034 loops=1)

  • Hash Cond: (__t11.parent_id = __t12.id)
29. 109.981 109.981 ↓ 88.4 2,034 1

Index Scan using i__account_good__evotor_id_new on good __t11 (cost=0.43..75.76 rows=23 width=439) (actual time=0.596..109.981 rows=2,034 loops=1)

  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (evotor_id_new IS NOT NULL))
  • Filter: ((deleted IS NULL) AND ((dtype)::text = ANY ('{Good,Kit,Service}'::text[])) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 108
30. 0.098 10.890 ↓ 108.0 108 1

Hash (cost=22.30..22.30 rows=1 width=53) (actual time=10.890..10.890 rows=108 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
31. 10.792 10.792 ↓ 108.0 108 1

Index Scan using good_account_dtype_index on good __t12 (cost=0.43..22.30 rows=1 width=53) (actual time=0.357..10.792 rows=108 loops=1)

  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND ((dtype)::text = 'GoodFolder'::text))
  • Filter: ((evotor_id_new IS NOT NULL) AND (deleted IS NULL) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
32.          

SubPlan (for Result)

33. 0.000 22.839 ↓ 0.0 0 993

Limit (cost=74.15..74.15 rows=1 width=49) (actual time=0.023..0.023 rows=0 loops=993)

34. 0.993 22.839 ↓ 0.0 0 993

Sort (cost=74.15..74.15 rows=1 width=49) (actual time=0.023..0.023 rows=0 loops=993)

  • Sort Key: __t15.path DESC
  • Sort Method: quicksort Memory: 25kB
35. 0.861 21.846 ↓ 0.0 0 993

Hash Join (cost=70.50..74.14 rows=1 width=49) (actual time=0.022..0.022 rows=0 loops=993)

  • Hash Cond: (((btrim(((json_array_elements(to_json((regexp_matches((__t11.path)::text, '([^/]+)/'::text, 'g'::text))))))::text, '"'::text))::uuid) = __t15.id)
36. 0.992 20.832 ↑ 100.0 2 992

HashAggregate (cost=48.15..50.15 rows=200 width=16) (actual time=0.021..0.021 rows=2 loops=992)

  • Group Key: (btrim(((json_array_elements(to_json((regexp_matches((__t11.path)::text, '([^/]+)/'::text, 'g'::text))))))::text, '"'::text))::uuid
37. 1.984 19.840 ↑ 500.0 2 992

Result (cost=0.43..35.65 rows=1,000 width=16) (actual time=0.016..0.020 rows=2 loops=992)

38. 3.968 17.856 ↑ 500.0 2 992

ProjectSet (cost=0.43..5.65 rows=1,000 width=32) (actual time=0.015..0.018 rows=2 loops=992)

39. 7.936 13.888 ↑ 5.0 2 992

ProjectSet (cost=0.43..0.53 rows=10 width=32) (actual time=0.013..0.014 rows=2 loops=992)

40. 0.000 5.952 ↑ 1.0 1 992

Limit (cost=0.43..0.46 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=992)

41. 5.952 5.952 ↑ 494.0 1 992

Index Only Scan using i__good__account_id on good __t15_1 (cost=0.43..15.07 rows=494 width=16) (actual time=0.006..0.006 rows=1 loops=992)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Heap Fetches: 992
42. 0.001 0.153 ↓ 0.0 0 1

Hash (cost=22.34..22.34 rows=1 width=65) (actual time=0.153..0.153 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
43. 0.152 0.152 ↓ 0.0 0 1

Index Scan using good_account_dtype_index on good __t15 (cost=0.43..22.34 rows=1 width=65) (actual time=0.152..0.152 rows=0 loops=1)

  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND ((dtype)::text = 'GoodFolder'::text))
  • Filter: ((evotor_id_new IS NOT NULL) AND (deleted IS NULL) AND (vat > '0'::numeric) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 108
44. 0.006 0.743 ↑ 1.0 1 1

Hash (cost=3.35..3.35 rows=1 width=24) (actual time=0.743..0.743 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
45. 0.737 0.737 ↑ 1.0 1 1

Index Scan using i__currency__account_id on currency __t5 (cost=0.29..3.35 rows=1 width=24) (actual time=0.736..0.737 rows=1 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END
46. 0.208 660.303 ↓ 669.0 669 1

Hash (cost=10,000,056,193.66..10,000,056,193.66 rows=1 width=48) (actual time=660.303..660.303 rows=669 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 316kB
47. 0.071 660.095 ↓ 669.0 669 1

Subquery Scan on __t7 (cost=10,000,056,193.59..10,000,056,193.66 rows=1 width=48) (actual time=649.322..660.095 rows=669 loops=1)

48. 5.819 660.024 ↓ 669.0 669 1

GroupAggregate (cost=10,000,056,193.59..10,000,056,193.65 rows=1 width=48) (actual time=649.320..660.024 rows=669 loops=1)

  • Group Key: __t28.kit_id
49. 4.347 654.205 ↓ 5,352.0 5,352 1

GroupAggregate (cost=10,000,056,193.59..10,000,056,193.63 rows=1 width=64) (actual time=649.254..654.205 rows=5,352 loops=1)

  • Group Key: __t28.kit_id, __t28.root_store_id
50. 5.489 649.858 ↓ 10,600.0 10,600 1

Sort (cost=10,000,056,193.59..10,000,056,193.60 rows=1 width=69) (actual time=649.245..649.858 rows=10,600 loops=1)

  • Sort Key: __t28.kit_id, __t28.root_store_id
  • Sort Method: quicksort Memory: 1,213kB
51. 0.963 644.369 ↓ 10,600.0 10,600 1

Subquery Scan on __t28 (cost=10,000,056,193.45..10,000,056,193.58 rows=1 width=69) (actual time=635.269..644.369 rows=10,600 loops=1)

52. 7.407 643.406 ↓ 10,600.0 10,600 1

GroupAggregate (cost=10,000,056,193.45..10,000,056,193.57 rows=1 width=85) (actual time=635.268..643.406 rows=10,600 loops=1)

  • Group Key: __t29.id, (CASE WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) THEN '1c6fa6fb-bad0-11e9-912f-f3d40009d2bb'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) THEN '9d66330f-c7e0-11e9-912f-f3d4002d4da0'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) THEN 'ba655159-466d-11ea-0a80-0483005adb24'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) THEN 'e85c73bb-c7df-11e9-912f-f3d4002d3cd0'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) THEN 'ba5edd07-466d-11ea-0a80-0483005adb20'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) THEN '9d61e568-c7e0-11e9-912f-f3d4002d4d9c'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) THEN 'e857ea15-c7df-11e9-912f-f3d4002d3ccd'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text) THEN 'a90a8c26-d1b7-11e9-0a80-006d001af28a'::uuid ELSE NULL::uuid END)
53. 7.521 635.999 ↓ 10,600.0 10,600 1

Sort (cost=10,000,056,193.45..10,000,056,193.46 rows=1 width=64) (actual time=635.245..635.999 rows=10,600 loops=1)

  • Sort Key: __t29.id, (CASE WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) THEN '1c6fa6fb-bad0-11e9-912f-f3d40009d2bb'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) THEN '9d66330f-c7e0-11e9-912f-f3d4002d4da0'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) THEN 'ba655159-466d-11ea-0a80-0483005adb24'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) THEN 'e85c73bb-c7df-11e9-912f-f3d4002d3cd0'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) THEN 'ba5edd07-466d-11ea-0a80-0483005adb20'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) THEN '9d61e568-c7e0-11e9-912f-f3d4002d4d9c'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) THEN 'e857ea15-c7df-11e9-912f-f3d4002d3ccd'::uuid WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text) THEN 'a90a8c26-d1b7-11e9-0a80-006d001af28a'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 1,875kB
54. 13.570 628.478 ↓ 10,600.0 10,600 1

Hash Join (cost=10,000,055,455.93..10,000,056,193.44 rows=1 width=64) (actual time=612.713..628.478 rows=10,600 loops=1)

  • Hash Cond: (__t35.id = __t34.good_id)
55. 2.411 4.180 ↓ 4.4 2,142 1

Bitmap Heap Scan on good __t35 (cost=8.76..744.34 rows=492 width=32) (actual time=1.930..4.180 rows=2,142 loops=1)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: ((dtype)::text <> 'Service'::text)
  • Heap Blocks: exact=1,295
56. 1.769 1.769 ↓ 4.3 2,143 1

Bitmap Index Scan on i__good__account_id (cost=0.00..8.63 rows=494 width=0) (actual time=1.769..1.769 rows=2,143 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
57. 3.504 610.728 ↓ 10,600.0 10,600 1

Hash (cost=10,000,055,447.16..10,000,055,447.16 rows=1 width=103) (actual time=610.728..610.728 rows=10,600 loops=1)

  • Buckets: 16,384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1,476kB
58. 5.727 607.224 ↓ 10,600.0 10,600 1

Hash Right Join (cost=10,000,014,463.31..10,000,055,447.16 rows=1 width=103) (actual time=351.422..607.224 rows=10,600 loops=1)

  • Hash Cond: ((__t30.account_id = __t34.account_id) AND (__t30.consignment_id = __t34.id) AND (__t30.store_id = __t33.id))
  • Join Filter: (CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", __t34.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN (NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t34.shared) ELSE false END AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", __t33.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN (NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t33.shared) ELSE false END)
59. 257.355 380.222 ↑ 7.6 4,194 1

Bitmap Heap Scan on cost __t30 (cost=6,672.99..47,297.58 rows=31,924 width=53) (actual time=123.386..380.222 rows=4,194 loops=1)

  • Recheck Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: ((initialcost_id IS NULL) AND (motion_id IS NOT NULL) AND isvalid)
  • Heap Blocks: exact=2,853
60. 122.867 122.867 ↑ 7.1 4,542 1

Bitmap Index Scan on i__cost_momentto (cost=0.00..6,665.01 rows=32,383 width=0) (actual time=122.867..122.867 rows=4,542 loops=1)

  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
61. 5.832 221.275 ↓ 10,600.0 10,600 1

Hash (cost=10,000,007,790.30..10,000,007,790.30 rows=1 width=188) (actual time=221.275..221.275 rows=10,600 loops=1)

  • Buckets: 16,384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2,416kB
62. 1.655 215.443 ↓ 10,600.0 10,600 1

Merge Left Join (cost=10,000,007,789.89..10,000,007,790.30 rows=1 width=188) (actual time=210.668..215.443 rows=10,600 loops=1)

  • Merge Cond: ((__t33.id = __t32.store_id) AND (__t34.id = __t32.consignment_id))
  • Join Filter: ((__t32.account_id = __t34.account_id) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", __t34.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN (NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t34.shared) ELSE false END AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", __t33.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN (NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t33.shared) ELSE false END)
63. 2.321 213.779 ↓ 10,600.0 10,600 1

Merge Left Join (cost=10,000,007,739.75..10,000,007,740.04 rows=1 width=185) (actual time=210.656..213.779 rows=10,600 loops=1)

  • Merge Cond: ((__t33.id = __t31.store_id) AND (__t34.id = __t31.consignment_id))
  • Join Filter: ((__t31.account_id = __t34.account_id) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", __t34.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN (NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t34.shared) ELSE false END AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", __t33.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN (NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t33.shared) ELSE false END)
64. 17.460 210.754 ↓ 10,600.0 10,600 1

Sort (cost=10,000,007,689.07..10,000,007,689.08 rows=1 width=182) (actual time=209.947..210.754 rows=10,600 loops=1)

  • Sort Key: __t33.id, __t34.id
  • Sort Method: quicksort Memory: 3,200kB
65. 1.363 193.294 ↓ 10,600.0 10,600 1

Nested Loop (cost=10,000,000,865.45..10,000,007,689.06 rows=1 width=182) (actual time=150.197..193.294 rows=10,600 loops=1)

66. 45.715 45.715 ↓ 8.0 8 1

Index Scan using place_pkey on place __t33 (cost=0.29..6,151.20 rows=1 width=60) (actual time=25.385..45.715 rows=8 loops=1)

  • Filter: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END AND ((((path)::text || (id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) OR (((path)::text || (id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) OR (((path)::text || (id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) OR (((path)::text || (id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) OR (((path)::text || (id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) OR (((path)::text || (id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) OR (((path)::text || (id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) OR (((path)::text || (id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text)))
  • Rows Removed by Filter: 31,526
67. 3.272 146.216 ↓ 1,325.0 1,325 8

Hash Join (cost=865.16..1,537.85 rows=1 width=122) (actual time=15.668..18.277 rows=1,325 loops=8)

  • Hash Cond: (__t29.element_id = __t34.feature_id)
68. 17.920 18.872 ↑ 1.0 1,325 8

Bitmap Heap Scan on kitelement __t29 (cost=19.63..687.30 rows=1,334 width=69) (actual time=0.155..2.359 rows=1,325 loops=8)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Heap Blocks: exact=1,736
69. 0.952 0.952 ↑ 1.0 1,325 8

Bitmap Index Scan on index_kitelement_account_id (cost=0.00..19.29 rows=1,334 width=0) (actual time=0.119..0.119 rows=1,325 loops=8)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
70. 2.090 124.072 ↓ 3.6 2,034 1

Hash (cost=838.50..838.50 rows=563 width=101) (actual time=124.072..124.072 rows=2,034 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 281kB
71. 119.928 121.982 ↓ 3.6 2,034 1

Bitmap Heap Scan on consignment __t34 (cost=9.29..838.50 rows=563 width=101) (actual time=2.393..121.982 rows=2,034 loops=1)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: isdefault
  • Heap Blocks: exact=1,452
72. 2.054 2.054 ↓ 3.6 2,035 1

Bitmap Index Scan on i__consignment__account_id (cost=0.00..9.15 rows=563 width=0) (actual time=2.054..2.054 rows=2,035 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
73. 0.009 0.704 ↓ 0.0 0 1

Sort (cost=50.68..50.74 rows=24 width=51) (actual time=0.704..0.704 rows=0 loops=1)

  • Sort Key: __t31.store_id, __t31.consignment_id
  • Sort Method: quicksort Memory: 25kB
74. 0.695 0.695 ↓ 0.0 0 1

Index Scan using i__reserve_momentto on reserve __t31 (cost=0.56..50.13 rows=24 width=51) (actual time=0.695..0.695 rows=0 loops=1)

  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: ((motion_id IS NOT NULL) AND isvalid AND (reservetype = 1))
75. 0.005 0.009 ↓ 0.0 0 1

Sort (cost=50.14..50.14 rows=2 width=51) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: __t32.store_id, __t32.consignment_id
  • Sort Method: quicksort Memory: 25kB
76. 0.004 0.004 ↓ 0.0 0 1

Index Scan using i__reserve_momentto on reserve __t32 (cost=0.56..50.13 rows=2 width=51) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: ((motion_id IS NOT NULL) AND isvalid AND (reservetype = 0))
77. 27.105 215.583 ↓ 1,000.0 1,000 1

GroupAggregate (cost=2,353.90..2,353.94 rows=1 width=48) (actual time=187.201..215.583 rows=1,000 loops=1)

  • Group Key: __t13_1.id
78. 15.796 188.478 ↓ 15,994.0 15,994 1

Sort (cost=2,353.90..2,353.91 rows=1 width=80) (actual time=187.129..188.478 rows=15,994 loops=1)

  • Sort Key: __t13_1.id
  • Sort Method: quicksort Memory: 5,344kB
79. 6.096 172.682 ↓ 32,537.0 32,537 1

Hash Left Join (cost=1,530.61..2,353.89 rows=1 width=80) (actual time=155.677..172.682 rows=32,537 loops=1)

  • Hash Cond: (__t16.currency_id = __t17.id)
80. 5.784 166.561 ↓ 32,537.0 32,537 1

Hash Left Join (cost=1,527.25..2,350.51 rows=1 width=88) (actual time=155.632..166.561 rows=32,537 loops=1)

  • Hash Cond: (__t13_1.id = __t16.parent_id)
81. 1.837 153.609 ↓ 8,135.0 8,135 1

Hash Left Join (cost=1,186.83..2,010.08 rows=1 width=48) (actual time=147.955..153.609 rows=8,135 loops=1)

  • Hash Cond: (__t18.currency_id = __t19.id)
82. 1.428 151.747 ↓ 8,135.0 8,135 1

Hash Join (cost=1,183.47..2,006.70 rows=1 width=56) (actual time=147.904..151.747 rows=8,135 loops=1)

  • Hash Cond: (__t13_1.parent_id = __t14_1.parent_id)
83. 2.550 2.806 ↓ 7.5 2,034 1

Bitmap Heap Scan on feature __t13_1 (cost=9.05..831.26 rows=270 width=32) (actual time=0.384..2.806 rows=2,034 loops=1)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: ((deleted IS NULL) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Heap Blocks: exact=1,314
84. 0.256 0.256 ↓ 3.8 2,035 1

Bitmap Index Scan on i__feature__account_id (cost=0.00..8.98 rows=540 width=0) (actual time=0.256..0.256 rows=2,035 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
85. 1.779 147.513 ↓ 8,135.0 8,135 1

Hash (cost=1,174.41..1,174.41 rows=1 width=56) (actual time=147.513..147.513 rows=8,135 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 764kB
86. 1.526 145.734 ↓ 8,135.0 8,135 1

Hash Join (cost=349.45..1,174.41 rows=1 width=56) (actual time=142.173..145.734 rows=8,135 loops=1)

  • Hash Cond: (__t14_1.id = __t18.parent_id)
87. 2.167 2.407 ↓ 8.4 2,034 1

Bitmap Heap Scan on feature __t14_1 (cost=9.04..831.25 rows=243 width=32) (actual time=0.363..2.407 rows=2,034 loops=1)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: (isdefault AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Heap Blocks: exact=1,314
88. 0.240 0.240 ↓ 3.8 2,035 1

Bitmap Index Scan on i__feature__account_id (cost=0.00..8.98 rows=540 width=0) (actual time=0.240..0.240 rows=2,035 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
89. 3.514 141.801 ↓ 1,162.1 8,135 1

Hash (cost=340.33..340.33 rows=7 width=56) (actual time=141.801..141.801 rows=8,135 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 764kB
90. 128.717 138.287 ↓ 1,162.1 8,135 1

Bitmap Heap Scan on price __t18 (cost=316.96..340.33 rows=7 width=56) (actual time=10.176..138.287 rows=8,135 loops=1)

  • Recheck Cond: ((pricetype_id = ANY ('{b04d1a17-343d-11ea-0a80-044a000102ee,91689409-c7e7-11e9-9109-f8fc0019d39e,1c7181b4-bad0-11e9-912f-f3d40009d2c1,d73e1c7e-3615-11ea-0a80-01b5001729e2}'::uuid[])) AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid))
  • Filter: CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END
  • Heap Blocks: exact=1,754
91. 0.087 9.570 ↓ 0.0 0 1

BitmapAnd (cost=316.96..316.96 rows=15 width=0) (actual time=9.570..9.570 rows=0 loops=1)

92. 5.229 5.229 ↓ 3.3 8,135 1

Bitmap Index Scan on i__price__pricetype_id (cost=0.00..38.29 rows=2,475 width=0) (actual time=5.229..5.229 rows=8,135 loops=1)

  • Index Cond: (pricetype_id = ANY ('{b04d1a17-343d-11ea-0a80-044a000102ee,91689409-c7e7-11e9-9109-f8fc0019d39e,1c7181b4-bad0-11e9-912f-f3d40009d2c1,d73e1c7e-3615-11ea-0a80-01b5001729e2}'::uuid[]))
93. 4.254 4.254 ↓ 1.0 20,338 1

Bitmap Index Scan on i__price__account_id (cost=0.00..278.42 rows=19,865 width=0) (actual time=4.254..4.254 rows=20,338 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
94. 0.011 0.025 ↑ 1.0 1 1

Hash (cost=3.35..3.35 rows=1 width=24) (actual time=0.025..0.025 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
95. 0.014 0.014 ↑ 1.0 1 1

Index Scan using i__currency__account_id on currency __t19 (cost=0.29..3.35 rows=1 width=24) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END
96. 1.623 7.168 ↓ 1,162.1 8,135 1

Hash (cost=340.33..340.33 rows=7 width=56) (actual time=7.168..7.168 rows=8,135 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 764kB
97. 3.649 5.545 ↓ 1,162.1 8,135 1

Bitmap Heap Scan on price __t16 (cost=316.96..340.33 rows=7 width=56) (actual time=2.107..5.545 rows=8,135 loops=1)

  • Recheck Cond: ((pricetype_id = ANY ('{b04d1a17-343d-11ea-0a80-044a000102ee,91689409-c7e7-11e9-9109-f8fc0019d39e,1c7181b4-bad0-11e9-912f-f3d40009d2c1,d73e1c7e-3615-11ea-0a80-01b5001729e2}'::uuid[])) AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid))
  • Filter: CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END
  • Heap Blocks: exact=1,754
98. 0.072 1.896 ↓ 0.0 0 1

BitmapAnd (cost=316.96..316.96 rows=15 width=0) (actual time=1.896..1.896 rows=0 loops=1)

99. 0.736 0.736 ↓ 3.3 8,135 1

Bitmap Index Scan on i__price__pricetype_id (cost=0.00..38.29 rows=2,475 width=0) (actual time=0.736..0.736 rows=8,135 loops=1)

  • Index Cond: (pricetype_id = ANY ('{b04d1a17-343d-11ea-0a80-044a000102ee,91689409-c7e7-11e9-9109-f8fc0019d39e,1c7181b4-bad0-11e9-912f-f3d40009d2c1,d73e1c7e-3615-11ea-0a80-01b5001729e2}'::uuid[]))
100. 1.088 1.088 ↓ 1.0 20,338 1

Bitmap Index Scan on i__price__account_id (cost=0.00..278.42 rows=19,865 width=0) (actual time=1.088..1.088 rows=20,338 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
101. 0.004 0.025 ↑ 1.0 1 1

Hash (cost=3.35..3.35 rows=1 width=24) (actual time=0.025..0.025 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
102. 0.021 0.021 ↑ 1.0 1 1

Index Scan using i__currency__account_id on currency __t17 (cost=0.29..3.35 rows=1 width=24) (actual time=0.020..0.021 rows=1 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END
103. 1.168 125.459 ↓ 654.0 654 1

GroupAggregate (cost=2,501.29..2,501.32 rows=1 width=48) (actual time=124.213..125.459 rows=654 loops=1)

  • Group Key: __t14_2.id
104. 0.750 124.291 ↓ 902.0 902 1

Sort (cost=2,501.29..2,501.30 rows=1 width=29) (actual time=124.182..124.291 rows=902 loops=1)

  • Sort Key: __t14_2.id
  • Sort Method: quicksort Memory: 189kB
105. 0.550 123.541 ↓ 1,795.0 1,795 1

Hash Join (cost=1,641.44..2,501.28 rows=1 width=29) (actual time=120.344..123.541 rows=1,795 loops=1)

  • Hash Cond: (__t20.id = __t4.consignment_id)
106. 0.460 5.478 ↓ 2,034.0 2,034 1

Hash Join (cost=843.86..1,703.36 rows=1 width=32) (actual time=2.825..5.478 rows=2,034 loops=1)

  • Hash Cond: (__t20.feature_id = __t14_2.id)
107. 2.375 2.610 ↓ 7.2 2,034 1

Bitmap Heap Scan on consignment __t20 (cost=9.22..865.17 rows=282 width=32) (actual time=0.406..2.610 rows=2,034 loops=1)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: ((deleted IS NULL) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Heap Blocks: exact=1,452
108. 0.235 0.235 ↓ 3.6 2,035 1

Bitmap Index Scan on i__consignment__account_id (cost=0.00..9.15 rows=563 width=0) (actual time=0.235..0.235 rows=2,035 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
109. 0.272 2.408 ↓ 7.5 2,034 1

Hash (cost=831.26..831.26 rows=270 width=16) (actual time=2.408..2.408 rows=2,034 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 112kB
110. 1.933 2.136 ↓ 7.5 2,034 1

Bitmap Heap Scan on feature __t14_2 (cost=9.05..831.26 rows=270 width=16) (actual time=0.341..2.136 rows=2,034 loops=1)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: ((deleted IS NULL) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Heap Blocks: exact=1,314
111. 0.203 0.203 ↓ 3.8 2,035 1

Bitmap Index Scan on i__feature__account_id (cost=0.00..8.98 rows=540 width=0) (actual time=0.203..0.203 rows=2,035 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
112. 0.784 117.513 ↓ 6.9 1,795 1

Hash (cost=794.32..794.32 rows=261 width=29) (actual time=117.513..117.513 rows=1,795 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 124kB
113. 115.307 116.729 ↓ 6.9 1,795 1

Bitmap Heap Scan on barcode __t4 (cost=8.92..794.32 rows=261 width=29) (actual time=2.204..116.729 rows=1,795 loops=1)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END
  • Heap Blocks: exact=708
114. 1.422 1.422 ↓ 3.4 1,795 1

Bitmap Index Scan on i__barcode__account_id (cost=0.00..8.85 rows=523 width=0) (actual time=1.422..1.422 rows=1,795 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
115. 0.001 0.050 ↓ 0.0 0 1

GroupAggregate (cost=1,704.07..1,704.09 rows=1 width=48) (actual time=0.050..0.050 rows=0 loops=1)

  • Group Key: __t14_3.id
116. 0.005 0.049 ↓ 0.0 0 1

Sort (cost=1,704.07..1,704.07 rows=1 width=35) (actual time=0.049..0.049 rows=0 loops=1)

  • Sort Key: __t14_3.id
  • Sort Method: quicksort Memory: 25kB
117. 0.000 0.044 ↓ 0.0 0 1

Hash Join (cost=847.03..1,704.06 rows=1 width=35) (actual time=0.044..0.044 rows=0 loops=1)

  • Hash Cond: (__t20_1.feature_id = __t14_3.id)
118. 0.016 0.044 ↓ 0.0 0 1

Hash Join (cost=12.40..869.41 rows=1 width=35) (actual time=0.044..0.044 rows=0 loops=1)

  • Hash Cond: (__t20_1.good_id = __t2.good_id)
119. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on consignment __t20_1 (cost=9.22..865.17 rows=282 width=32) (never executed)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: ((deleted IS NULL) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
120. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on i__consignment__account_id (cost=0.00..9.15 rows=563 width=0) (never executed)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
121. 0.001 0.028 ↓ 0.0 0 1

Hash (cost=3.16..3.16 rows=1 width=35) (actual time=0.028..0.028 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
122. 0.027 0.027 ↓ 0.0 0 1

Index Scan using i__alcocode__account_id on alcocode __t2 (cost=0.14..3.16 rows=1 width=35) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
123. 0.000 0.000 ↓ 0.0 0

Hash (cost=831.26..831.26 rows=270 width=16) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on feature __t14_3 (cost=9.05..831.26 rows=270 width=16) (never executed)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: ((deleted IS NULL) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
125. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on i__feature__account_id (cost=0.00..8.98 rows=540 width=0) (never executed)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
126. 0.091 7,634.849 ↓ 1.9 386 1

Materialize (cost=771,212.06..771,250.54 rows=200 width=48) (actual time=7,632.356..7,634.849 rows=386 loops=1)

127. 1.670 7,634.758 ↓ 1.9 386 1

GroupAggregate (cost=771,212.06..771,248.04 rows=200 width=48) (actual time=7,632.351..7,634.758 rows=386 loops=1)

  • Group Key: __t22.id
128. 0.661 7,633.088 ↓ 4.0 1,153 1

GroupAggregate (cost=771,212.06..771,241.27 rows=285 width=64) (actual time=7,632.318..7,633.088 rows=1,153 loops=1)

  • Group Key: __t22.id, (CASE WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) THEN '1c6fa6fb-bad0-11e9-912f-f3d40009d2bb'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) THEN '9d66330f-c7e0-11e9-912f-f3d4002d4da0'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) THEN 'ba655159-466d-11ea-0a80-0483005adb24'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) THEN 'e85c73bb-c7df-11e9-912f-f3d4002d3cd0'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) THEN 'ba5edd07-466d-11ea-0a80-0483005adb20'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) THEN '9d61e568-c7e0-11e9-912f-f3d4002d4d9c'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) THEN 'e857ea15-c7df-11e9-912f-f3d4002d3ccd'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text) THEN 'a90a8c26-d1b7-11e9-0a80-006d001af28a'::uuid ELSE NULL::uuid END)
129. 0.955 7,632.427 ↓ 4.0 1,154 1

Sort (cost=771,212.06..771,212.77 rows=285 width=37) (actual time=7,632.308..7,632.427 rows=1,154 loops=1)

  • Sort Key: __t22.id, (CASE WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) THEN '1c6fa6fb-bad0-11e9-912f-f3d40009d2bb'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) THEN '9d66330f-c7e0-11e9-912f-f3d4002d4da0'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) THEN 'ba655159-466d-11ea-0a80-0483005adb24'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) THEN 'e85c73bb-c7df-11e9-912f-f3d4002d3cd0'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) THEN 'ba5edd07-466d-11ea-0a80-0483005adb20'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) THEN '9d61e568-c7e0-11e9-912f-f3d4002d4d9c'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) THEN 'e857ea15-c7df-11e9-912f-f3d4002d3ccd'::uuid WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text) THEN 'a90a8c26-d1b7-11e9-0a80-006d001af28a'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 177kB
130. 225.495 7,631.472 ↓ 5.8 1,642 1

Hash Join (cost=618,734.16..771,200.44 rows=285 width=37) (actual time=5,928.695..7,631.472 rows=1,642 loops=1)

  • Hash Cond: (__t22.parent_id = __t26.id)
131. 382.685 4,145.521 ↓ 2.9 1,651 1

Hash Join (cost=261,975.84..414,412.01 rows=579 width=60) (actual time=2,655.964..4,145.521 rows=1,651 loops=1)

  • Hash Cond: (__t22.id = __t25.feature_id)
132. 1,133.429 1,133.429 ↓ 1.0 2,950,263 1

Seq Scan on feature __t22 (cost=0.00..141,426.84 rows=2,934,284 width=32) (actual time=0.665..1,133.429 rows=2,950,263 loops=1)

133. 0.428 2,629.407 ↓ 2.9 1,651 1

Hash (cost=261,968.61..261,968.61 rows=579 width=44) (actual time=2,629.407..2,629.407 rows=1,651 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 132kB
134. 271.738 2,628.979 ↓ 2.9 1,651 1

Hash Join (cost=200,707.10..261,968.61 rows=579 width=44) (actual time=2,359.575..2,628.979 rows=1,651 loops=1)

  • Hash Cond: (__t23.consignment_id = __t25.id)
135. 0.379 80.052 ↓ 2.9 1,651 1

Hash Join (cost=11,945.08..53,022.28 rows=579 width=44) (actual time=75.189..80.052 rows=1,651 loops=1)

  • Hash Cond: (__t23.store_id = __t24.id)
136. 4.799 16.946 ↑ 17.5 1,682 1

Bitmap Heap Scan on cost __t23 (cost=6,672.37..47,377.92 rows=29,438 width=37) (actual time=12.449..16.946 rows=1,682 loops=1)

  • Recheck Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: ((initialcost_id IS NULL) AND (motion_id IS NOT NULL) AND isvalid AND (stock <> '0'::numeric))
  • Rows Removed by Filter: 2,512
  • Heap Blocks: exact=2,853
137. 12.147 12.147 ↑ 7.1 4,542 1

Bitmap Index Scan on i__cost_momentto (cost=0.00..6,665.01 rows=32,383 width=0) (actual time=12.147..12.147 rows=4,542 loops=1)

  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
138. 0.012 62.727 ↑ 77.5 8 1

Hash (cost=5,264.96..5,264.96 rows=620 width=23) (actual time=62.727..62.727 rows=8 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
139. 62.715 62.715 ↑ 77.5 8 1

Seq Scan on place __t24 (cost=0.00..5,264.96 rows=620 width=23) (actual time=50.347..62.715 rows=8 loops=1)

  • Filter: (CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END AND ((((path)::text || (id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) OR (((path)::text || (id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) OR (((path)::text || (id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) OR (((path)::text || (id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) OR (((path)::text || (id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) OR (((path)::text || (id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) OR (((path)::text || (id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) OR (((path)::text || (id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text)))
  • Rows Removed by Filter: 31,526
140. 948.322 2,277.189 ↓ 1.0 2,950,263 1

Hash (cost=131,724.23..131,724.23 rows=2,949,823 width=32) (actual time=2,277.189..2,277.189 rows=2,950,263 loops=1)

  • Buckets: 2,097,152 Batches: 2 Memory Usage: 108,633kB
141. 1,328.867 1,328.867 ↓ 1.0 2,950,263 1

Seq Scan on consignment __t25 (cost=0.00..131,724.23 rows=2,949,823 width=32) (actual time=0.534..1,328.867 rows=2,950,263 loops=1)

  • Filter: isdefault
142. 1,096.268 3,260.456 ↓ 2.0 2,685,903 1

Hash (cost=339,965.64..339,965.64 rows=1,343,414 width=16) (actual time=3,260.456..3,260.456 rows=2,685,903 loops=1)

  • Buckets: 4,194,304 (originally 2097152) Batches: 2 (originally 1) Memory Usage: 98,305kB
143. 2,164.188 2,164.188 ↓ 2.0 2,685,903 1

Seq Scan on good __t26 (cost=0.00..339,965.64 rows=1,343,414 width=16) (actual time=0.745..2,164.188 rows=2,685,903 loops=1)

  • Filter: ((NOT archived) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 43,464
144. 0.001 52.066 ↓ 0.0 0 1

GroupAggregate (cost=645,555.62..645,555.76 rows=1 width=48) (actual time=52.066..52.066 rows=0 loops=1)

  • Group Key: __t37.id
145. 0.001 52.065 ↓ 0.0 0 1

GroupAggregate (cost=645,555.62..645,555.73 rows=1 width=64) (actual time=52.065..52.065 rows=0 loops=1)

  • Group Key: __t37.id, (CASE WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) THEN '1c6fa6fb-bad0-11e9-912f-f3d40009d2bb'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) THEN '9d66330f-c7e0-11e9-912f-f3d4002d4da0'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) THEN 'ba655159-466d-11ea-0a80-0483005adb24'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) THEN 'e85c73bb-c7df-11e9-912f-f3d4002d3cd0'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) THEN 'ba5edd07-466d-11ea-0a80-0483005adb20'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) THEN '9d61e568-c7e0-11e9-912f-f3d4002d4d9c'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) THEN 'e857ea15-c7df-11e9-912f-f3d4002d3ccd'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text) THEN 'a90a8c26-d1b7-11e9-0a80-006d001af28a'::uuid ELSE NULL::uuid END)
146. 0.012 52.064 ↓ 0.0 0 1

Sort (cost=645,555.62..645,555.63 rows=1 width=35) (actual time=52.064..52.064 rows=0 loops=1)

  • Sort Key: __t37.id, (CASE WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) THEN '1c6fa6fb-bad0-11e9-912f-f3d40009d2bb'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) THEN '9d66330f-c7e0-11e9-912f-f3d4002d4da0'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) THEN 'ba655159-466d-11ea-0a80-0483005adb24'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) THEN 'e85c73bb-c7df-11e9-912f-f3d4002d3cd0'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) THEN 'ba5edd07-466d-11ea-0a80-0483005adb20'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) THEN '9d61e568-c7e0-11e9-912f-f3d4002d4d9c'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) THEN 'e857ea15-c7df-11e9-912f-f3d4002d3ccd'::uuid WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text) THEN 'a90a8c26-d1b7-11e9-0a80-006d001af28a'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 25kB
147. 0.017 52.052 ↓ 0.0 0 1

Hash Join (cost=300,552.08..645,555.61 rows=1 width=35) (actual time=52.052..52.052 rows=0 loops=1)

  • Hash Cond: (__t41.id = __t37.parent_id)
148. 0.040 0.040 ↑ 1,343,414.0 1 1

Seq Scan on good __t41 (cost=0.00..339,965.64 rows=1,343,414 width=16) (actual time=0.040..0.040 rows=1 loops=1)

  • Filter: ((NOT archived) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
149. 0.001 51.995 ↓ 0.0 0 1

Hash (cost=300,552.07..300,552.07 rows=1 width=58) (actual time=51.995..51.995 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
150. 0.013 51.994 ↓ 0.0 0 1

Hash Join (cost=148,121.65..300,552.07 rows=1 width=58) (actual time=51.994..51.994 rows=0 loops=1)

  • Hash Cond: (__t37.id = __t40.feature_id)
151. 0.024 0.024 ↑ 2,934,284.0 1 1

Seq Scan on feature __t37 (cost=0.00..141,426.84 rows=2,934,284 width=32) (actual time=0.024..0.024 rows=1 loops=1)

152. 0.001 51.957 ↓ 0.0 0 1

Hash (cost=148,121.64..148,121.64 rows=1 width=42) (actual time=51.957..51.957 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
153. 0.014 51.956 ↓ 0.0 0 1

Hash Join (cost=5,335.56..148,121.64 rows=1 width=42) (actual time=51.956..51.956 rows=0 loops=1)

  • Hash Cond: (__t40.id = __t38.consignment_id)
154. 0.033 0.033 ↑ 2,949,823.0 1 1

Seq Scan on consignment __t40 (cost=0.00..131,724.23 rows=2,949,823 width=32) (actual time=0.033..0.033 rows=1 loops=1)

155. 0.000 51.909 ↓ 0.0 0 1

Hash (cost=5,335.55..5,335.55 rows=1 width=42) (actual time=51.909..51.909 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
156. 0.029 51.909 ↓ 0.0 0 1

Hash Join (cost=50.43..5,335.55 rows=1 width=42) (actual time=51.909..51.909 rows=0 loops=1)

  • Hash Cond: (__t39.id = __t38.store_id)
157. 51.859 51.859 ↑ 620.0 1 1

Seq Scan on place __t39 (cost=0.00..5,264.96 rows=620 width=23) (actual time=51.859..51.859 rows=1 loops=1)

  • Filter: (CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END AND ((((path)::text || (id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) OR (((path)::text || (id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) OR (((path)::text || (id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) OR (((path)::text || (id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) OR (((path)::text || (id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) OR (((path)::text || (id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) OR (((path)::text || (id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) OR (((path)::text || (id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text)))
  • Rows Removed by Filter: 25,166
158. 0.001 0.021 ↓ 0.0 0 1

Hash (cost=50.13..50.13 rows=24 width=35) (actual time=0.021..0.021 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
159. 0.020 0.020 ↓ 0.0 0 1

Index Scan using i__reserve_momentto on reserve __t38 (cost=0.56..50.13 rows=24 width=35) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: (isvalid AND (reservetype = 1))
160. 0.000 50.582 ↓ 0.0 0 1

GroupAggregate (cost=645,538.30..645,538.43 rows=1 width=48) (actual time=50.582..50.582 rows=0 loops=1)

  • Group Key: __t43.id
161. 0.001 50.582 ↓ 0.0 0 1

GroupAggregate (cost=645,538.30..645,538.40 rows=1 width=64) (actual time=50.582..50.582 rows=0 loops=1)

  • Group Key: __t43.id, (CASE WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) THEN '1c6fa6fb-bad0-11e9-912f-f3d40009d2bb'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) THEN '9d66330f-c7e0-11e9-912f-f3d4002d4da0'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) THEN 'ba655159-466d-11ea-0a80-0483005adb24'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) THEN 'e85c73bb-c7df-11e9-912f-f3d4002d3cd0'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) THEN 'ba5edd07-466d-11ea-0a80-0483005adb20'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) THEN '9d61e568-c7e0-11e9-912f-f3d4002d4d9c'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) THEN 'e857ea15-c7df-11e9-912f-f3d4002d3ccd'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text) THEN 'a90a8c26-d1b7-11e9-0a80-006d001af28a'::uuid ELSE NULL::uuid END)
162. 0.016 50.581 ↓ 0.0 0 1

Sort (cost=645,538.30..645,538.30 rows=1 width=35) (actual time=50.581..50.581 rows=0 loops=1)

  • Sort Key: __t43.id, (CASE WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) THEN '1c6fa6fb-bad0-11e9-912f-f3d40009d2bb'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) THEN '9d66330f-c7e0-11e9-912f-f3d4002d4da0'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) THEN 'ba655159-466d-11ea-0a80-0483005adb24'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) THEN 'e85c73bb-c7df-11e9-912f-f3d4002d3cd0'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) THEN 'ba5edd07-466d-11ea-0a80-0483005adb20'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) THEN '9d61e568-c7e0-11e9-912f-f3d4002d4d9c'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) THEN 'e857ea15-c7df-11e9-912f-f3d4002d3ccd'::uuid WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text) THEN 'a90a8c26-d1b7-11e9-0a80-006d001af28a'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 25kB
163. 0.015 50.565 ↓ 0.0 0 1

Hash Join (cost=300,534.75..645,538.29 rows=1 width=35) (actual time=50.565..50.565 rows=0 loops=1)

  • Hash Cond: (__t47.id = __t43.parent_id)
164. 0.009 0.009 ↑ 1,343,414.0 1 1

Seq Scan on good __t47 (cost=0.00..339,965.64 rows=1,343,414 width=16) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: ((NOT archived) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
165. 0.001 50.541 ↓ 0.0 0 1

Hash (cost=300,534.74..300,534.74 rows=1 width=58) (actual time=50.541..50.541 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
166. 0.016 50.540 ↓ 0.0 0 1

Hash Join (cost=148,104.33..300,534.74 rows=1 width=58) (actual time=50.540..50.540 rows=0 loops=1)

  • Hash Cond: (__t43.id = __t46.feature_id)
167. 0.004 0.004 ↑ 2,934,284.0 1 1

Seq Scan on feature __t43 (cost=0.00..141,426.84 rows=2,934,284 width=32) (actual time=0.004..0.004 rows=1 loops=1)

168. 0.000 50.520 ↓ 0.0 0 1

Hash (cost=148,104.31..148,104.31 rows=1 width=42) (actual time=50.520..50.520 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
169. 0.014 50.520 ↓ 0.0 0 1

Hash Join (cost=5,318.24..148,104.31 rows=1 width=42) (actual time=50.520..50.520 rows=0 loops=1)

  • Hash Cond: (__t46.id = __t44.consignment_id)
170. 0.005 0.005 ↑ 2,949,823.0 1 1

Seq Scan on consignment __t46 (cost=0.00..131,724.23 rows=2,949,823 width=32) (actual time=0.005..0.005 rows=1 loops=1)

171. 0.000 50.501 ↓ 0.0 0 1

Hash (cost=5,318.22..5,318.22 rows=1 width=42) (actual time=50.501..50.501 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
172. 0.016 50.501 ↓ 0.0 0 1

Hash Join (cost=50.15..5,318.22 rows=1 width=42) (actual time=50.501..50.501 rows=0 loops=1)

  • Hash Cond: (__t45.id = __t44.store_id)
173. 50.469 50.469 ↑ 620.0 1 1

Seq Scan on place __t45 (cost=0.00..5,264.96 rows=620 width=23) (actual time=50.469..50.469 rows=1 loops=1)

  • Filter: (CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END AND ((((path)::text || (id)::text) ~~ '/1c6fa6fb-bad0-11e9-912f-f3d40009d2bb%'::text) OR (((path)::text || (id)::text) ~~ '/9d66330f-c7e0-11e9-912f-f3d4002d4da0%'::text) OR (((path)::text || (id)::text) ~~ '/ba655159-466d-11ea-0a80-0483005adb24%'::text) OR (((path)::text || (id)::text) ~~ '/e85c73bb-c7df-11e9-912f-f3d4002d3cd0%'::text) OR (((path)::text || (id)::text) ~~ '/ba5edd07-466d-11ea-0a80-0483005adb20%'::text) OR (((path)::text || (id)::text) ~~ '/9d61e568-c7e0-11e9-912f-f3d4002d4d9c%'::text) OR (((path)::text || (id)::text) ~~ '/e857ea15-c7df-11e9-912f-f3d4002d3ccd%'::text) OR (((path)::text || (id)::text) ~~ '/a90a8c26-d1b7-11e9-0a80-006d001af28a%'::text)))
  • Rows Removed by Filter: 25,166
174. 0.000 0.016 ↓ 0.0 0 1

Hash (cost=50.13..50.13 rows=2 width=35) (actual time=0.016..0.016 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
175. 0.016 0.016 ↓ 0.0 0 1

Index Scan using i__reserve_momentto on reserve __t44 (cost=0.56..50.13 rows=2 width=35) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: (isvalid AND (reservetype = 0))
176. 0.001 0.163 ↓ 0.0 0 1

GroupAggregate (cost=1,318.41..1,318.43 rows=1 width=48) (actual time=0.163..0.163 rows=0 loops=1)

  • Group Key: __t13_2.id
177. 0.024 0.162 ↓ 0.0 0 1

Sort (cost=1,318.41..1,318.41 rows=1 width=90) (actual time=0.162..0.162 rows=0 loops=1)

  • Sort Key: __t13_2.id
  • Sort Method: quicksort Memory: 25kB
178. 0.001 0.138 ↓ 0.0 0 1

Hash Left Join (cost=521.37..1,318.40 rows=1 width=90) (actual time=0.138..0.138 rows=0 loops=1)

  • Hash Cond: ((__t13_2.id = __t51.parent_id) AND (__t49.attribute_metadata_id = __t51.metadata_id))
  • Filter: (((__t51.valuestring)::text = (__t50.name)::text) OR ((__t51.valuestring IS NULL) AND ((__t50.evotor_id_new)::text = (__t49.evotor_attribute_id_new)::text)))
179. 0.013 0.137 ↓ 0.0 0 1

Hash Join (cost=93.87..890.66 rows=1 width=111) (actual time=0.137..0.137 rows=0 loops=1)

  • Hash Cond: (__t49.id = __t50.attribute_id)
180. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=90.66..887.44 rows=1 width=85) (never executed)

  • Hash Cond: (__t13_2.parent_id = __t14_4.parent_id)
181. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on feature __t13_2 (cost=8.99..805.55 rows=55 width=32) (never executed)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: (NOT isdefault)
182. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on i__feature__account_id (cost=0.00..8.98 rows=540 width=0) (never executed)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
183. 0.000 0.000 ↓ 0.0 0

Hash (cost=81.66..81.66 rows=1 width=85) (never executed)

184. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=0.71..81.66 rows=1 width=85) (never executed)

  • Merge Cond: ((__t49.evotor_group_id_new)::text = (__t14_4.evotor_id_new)::text)
185. 0.000 0.000 ↓ 0.0 0

Index Scan using ui__account_evotorattribute__evotor_id_new on evotorattribute __t49 (cost=0.28..3.27 rows=1 width=106) (never executed)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
186. 0.000 0.000 ↓ 0.0 0

Index Scan using i__account_feature__evotor_id_new on feature __t14_4 (cost=0.43..821.01 rows=485 width=53) (never executed)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Filter: isdefault
187. 0.000 0.124 ↓ 0.0 0 1

Hash (cost=3.20..3.20 rows=1 width=58) (actual time=0.124..0.124 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
188. 0.124 0.124 ↓ 0.0 0 1

Index Scan using i__evotorchoice__account_id on evotorchoice __t50 (cost=0.29..3.20 rows=1 width=58) (actual time=0.124..0.124 rows=0 loops=1)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
189. 0.000 0.000 ↓ 0.0 0

Hash (cost=422.92..422.92 rows=305 width=42) (never executed)

190. 0.000 0.000 ↓ 0.0 0

Index Scan using u_featureattributevalue_account_feature_metadata on featureattributevalue __t51 (cost=0.42..422.92 rows=305 width=42) (never executed)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
Planning time : 46.113 ms
Execution time : 9,053.543 ms