explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kk8C

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (__t3.id = __t11.uom_id)
2. 0.000 0.000 ↓ 0.0

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

3. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) OR (account_id IS NULL))
4. 0.000 0.000 ↓ 0.0

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

5. 0.000 0.000 ↓ 0.0

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

  • Merge Cond: (__t13.id = __t13_2.id)
6. 0.000 0.000 ↓ 0.0

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

7. 0.000 0.000 ↓ 0.0

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

8. 0.000 0.000 ↓ 0.0

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

9. 0.000 0.000 ↓ 0.0

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

  • Merge Cond: (__t13.id = __t43.id)
  • Index Cond: (account_id IS NULL)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Group Key: __t13_2.id
10. 0.000 0.000 ↓ 0.0

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

11. 0.000 0.000 ↓ 0.0

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

12. 0.000 0.000 ↓ 0.0

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

  • Sort Key: __t13_2.id
  • Merge Cond: (__t13.id = __t37.id)
  • Group Key: __t43.id
13. 0.000 0.000 ↓ 0.0

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

14. 0.000 0.000 ↓ 0.0

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

15. 0.000 0.000 ↓ 0.0

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

16. 0.000 0.000 ↓ 0.0

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

  • Merge Cond: (__t13.id = __t22.id)
  • Join Filter: ((__t11.dtype)::text = 'Good'::text)
  • Hash Cond: ((__t13_2.id = __t51.parent_id) AND (__t49.attribute_metadata_id = __t51.metadata_id))
  • 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)
  • Group Key: __t37.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)))
17. 0.000 0.000 ↓ 0.0

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

18. 0.000 0.000 ↓ 0.0

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

19. 0.000 0.000 ↓ 0.0

Materialize (cost=771,212.06..771,250.54 rows=200 width=48) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

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

21. 0.000 0.000 ↓ 0.0

Hash (cost=422.92..422.92 rows=305 width=42) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

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

  • 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)
  • Merge Cond: (__t13.id = __t14_3.id)
  • Hash Cond: (__t49.id = __t50.attribute_id)
  • 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)
23. 0.000 0.000 ↓ 0.0

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

24. 0.000 0.000 ↓ 0.0

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

25. 0.000 0.000 ↓ 0.0

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

26. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=90.66..887.44 rows=1 width=85) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

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

28. 0.000 0.000 ↓ 0.0

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

29. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=771,212.06..771,248.04 rows=200 width=48) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

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

  • 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)
  • Merge Cond: (__t13.id = __t14_2.id)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Hash Cond: (__t47.id = __t43.parent_id)
  • Hash Cond: (__t13_2.parent_id = __t14_4.parent_id)
  • Group Key: __t22.id
  • Group Key: __t14_3.id
31. 0.000 0.000 ↓ 0.0

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

32. 0.000 0.000 ↓ 0.0

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

33. 0.000 0.000 ↓ 0.0

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

34. 0.000 0.000 ↓ 0.0

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

35. 0.000 0.000 ↓ 0.0

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

36. 0.000 0.000 ↓ 0.0

Hash (cost=81.66..81.66 rows=1 width=85) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

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

38. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=771,212.06..771,241.27 rows=285 width=64) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

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

40. 0.000 0.000 ↓ 0.0

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

  • Sort Key: __t14_3.id
  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Merge Cond: (__t13.id = __t13_1.id)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Hash Cond: (__t41.id = __t37.parent_id)
  • 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)
  • Group Key: __t14_2.id
  • Filter: (NOT isdefault)
  • 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)
41. 0.000 0.000 ↓ 0.0

Sort (cost=771,212.06..771,212.77 rows=285 width=37) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

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

43. 0.000 0.000 ↓ 0.0

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

44. 0.000 0.000 ↓ 0.0

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

45. 0.000 0.000 ↓ 0.0

Merge Join (cost=0.71..81.66 rows=1 width=85) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

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

47. 0.000 0.000 ↓ 0.0

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

48. 0.000 0.000 ↓ 0.0

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

49. 0.000 0.000 ↓ 0.0

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

50. 0.000 0.000 ↓ 0.0

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

  • 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 Key: __t14_2.id
  • Sort Key: __t13.id
  • Merge Cond: ((__t49.evotor_group_id_new)::text = (__t14_4.evotor_id_new)::text)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Hash Cond: (__t43.id = __t46.feature_id)
  • Hash Cond: (__t20_1.feature_id = __t14_3.id)
  • Group Key: __t13_1.id
  • 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)
51. 0.000 0.000 ↓ 0.0

Sort (cost=2,353.90..2,353.91 rows=1 width=80) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

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

53. 0.000 0.000 ↓ 0.0

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

54. 0.000 0.000 ↓ 0.0

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

55. 0.000 0.000 ↓ 0.0

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

56. 0.000 0.000 ↓ 0.0

Hash Join (cost=618,734.16..771,200.44 rows=285 width=37) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

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

58. 0.000 0.000 ↓ 0.0

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

59. 0.000 0.000 ↓ 0.0

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

60. 0.000 0.000 ↓ 0.0

Hash (cost=831.26..831.26 rows=270 width=16) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

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

  • Sort Key: __t13_1.id
  • Join Filter: ((__t11.dtype)::text = 'Kit'::text)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Hash Cond: (__t37.id = __t40.feature_id)
  • Hash Cond: (__t22.parent_id = __t26.id)
  • Hash Cond: (__t20_1.good_id = __t2.good_id)
  • Hash Cond: (__t20.id = __t4.consignment_id)
  • Hash Cond: (__t11.id = __t7.good_id)
  • Filter: isdefault
62. 0.000 0.000 ↓ 0.0

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

63. 0.000 0.000 ↓ 0.0

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

64. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,530.61..2,353.89 rows=1 width=80) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Hash Join (cost=843.86..1,703.36 rows=1 width=32) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

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

67. 0.000 0.000 ↓ 0.0

Hash Join (cost=261,975.84..414,412.01 rows=579 width=60) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Hash (cost=794.32..794.32 rows=261 width=29) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Hash (cost=339,965.64..339,965.64 rows=1,343,414 width=16) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

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

71. 0.000 0.000 ↓ 0.0

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

72. 0.000 0.000 ↓ 0.0

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

73. 0.000 0.000 ↓ 0.0

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

74. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Hash Cond: (__t46.id = __t44.consignment_id)
  • Hash Cond: (__t22.id = __t25.feature_id)
  • Hash Cond: (__t20.feature_id = __t14_2.id)
  • Hash Cond: (__t16.currency_id = __t17.id)
  • Hash Cond: ((CASE WHEN ((NOT __t13.isdefault) AND (__t13.buycurrency_id IS NULL)) THEN __t14.buycurrency_id ELSE __t13.buycurrency_id END) = __t5.id)
  • 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)
  • 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)
75. 0.000 0.000 ↓ 0.0

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

76. 0.000 0.000 ↓ 0.0

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

77. 0.000 0.000 ↓ 0.0

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

78. 0.000 0.000 ↓ 0.0

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

79. 0.000 0.000 ↓ 0.0

Limit (cost=1,763.15..1,837.33 rows=1 width=1,340) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

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

81. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,527.25..2,350.51 rows=1 width=88) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

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

83. 0.000 0.000 ↓ 0.0

Hash (cost=831.26..831.26 rows=270 width=16) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

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

85. 0.000 0.000 ↓ 0.0

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

86. 0.000 0.000 ↓ 0.0

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

87. 0.000 0.000 ↓ 0.0

Hash (cost=261,968.61..261,968.61 rows=579 width=44) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

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

89. 0.000 0.000 ↓ 0.0

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

90. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on consignment __t20 (cost=9.22..865.17 rows=282 width=32) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on barcode __t4 (cost=8.92..794.32 rows=261 width=29) (actual rows= loops=)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Hash Cond: (__t40.id = __t38.consignment_id)
  • Hash Cond: (__t13_1.id = __t16.parent_id)
  • 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
  • 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)
  • 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)
92. 0.000 0.000 ↓ 0.0

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

93. 0.000 0.000 ↓ 0.0

Result (cost=1,763.15..1,837.33 rows=1 width=1,340) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

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

95. 0.000 0.000 ↓ 0.0

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

96. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,186.83..2,010.08 rows=1 width=48) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

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

98. 0.000 0.000 ↓ 0.0

Hash Join (cost=200,707.10..261,968.61 rows=579 width=44) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

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

100. 0.000 0.000 ↓ 0.0

Hash (cost=340.33..340.33 rows=7 width=56) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

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

102. 0.000 0.000 ↓ 0.0

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

103. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on i__barcode__account_id (cost=0.00..8.85 rows=523 width=0) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on feature __t14_2 (cost=9.05..831.26 rows=270 width=16) (actual rows= loops=)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Hash Cond: (__t45.id = __t44.store_id)
  • Hash Cond: (__t23.consignment_id = __t25.id)
  • Hash Cond: (__t18.currency_id = __t19.id)
  • Group Key: __t28.kit_id
  • 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
  • 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
  • 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)
105. 0.000 0.000 ↓ 0.0

Sort (cost=1,763.15..1,763.15 rows=1 width=1,361) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

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

107. 0.000 0.000 ↓ 0.0

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

108. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,945.08..53,022.28 rows=579 width=44) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,183.47..2,006.70 rows=1 width=56) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Hash (cost=50.13..50.13 rows=2 width=35) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

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

112. 0.000 0.000 ↓ 0.0

Hash (cost=131,724.23..131,724.23 rows=2,949,823 width=32) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=10,000,056,193.59..10,000,056,193.63 rows=1 width=64) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

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

115. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on price __t16 (cost=316.96..340.33 rows=7 width=56) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Limit (cost=74.15..74.15 rows=1 width=49) (actual rows= loops=)

  • Sort Key: __t13.id
  • 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))
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Hash Cond: (__t39.id = __t38.store_id)
  • Hash Cond: (__t23.store_id = __t24.id)
  • Hash Cond: (__t13_1.parent_id = __t14_1.parent_id)
  • Group Key: __t28.kit_id, __t28.root_store_id
  • 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
  • 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)))
117. 0.000 0.000 ↓ 0.0

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

118. 0.000 0.000 ↓ 0.0

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

119. 0.000 0.000 ↓ 0.0

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

120. 0.000 0.000 ↓ 0.0

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

121. 0.000 0.000 ↓ 0.0

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

122. 0.000 0.000 ↓ 0.0

Hash Join (cost=939.88..1,763.14 rows=1 width=1,361) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Hash (cost=5,264.96..5,264.96 rows=620 width=23) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Hash (cost=50.13..50.13 rows=24 width=35) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Hash (cost=1,174.41..1,174.41 rows=1 width=56) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

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

127. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on feature __t13_1 (cost=9.05..831.26 rows=270 width=32) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

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

129. 0.000 0.000 ↓ 0.0

Sort (cost=74.15..74.15 rows=1 width=49) (actual rows= loops=)

  • Sort Key: __t28.kit_id, __t28.root_store_id
  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Recheck Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Hash Cond: (__t13.parent_id = __t11.id)
  • Filter: isdefault
  • 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
  • Filter: (isvalid AND (reservetype = 0))
  • 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)))
  • Filter: ((initialcost_id IS NULL) AND (motion_id IS NOT NULL) AND isvalid AND (stock <> '0'::numeric))
  • 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)
130. 0.000 0.000 ↓ 0.0

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

131. 0.000 0.000 ↓ 0.0

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

132. 0.000 0.000 ↓ 0.0

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

133. 0.000 0.000 ↓ 0.0

Hash Join (cost=349.45..1,174.41 rows=1 width=56) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Hash (cost=930.82..930.82 rows=1 width=537) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

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

136. 0.000 0.000 ↓ 0.0

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

137. 0.000 0.000 ↓ 0.0

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

138. 0.000 0.000 ↓ 0.0

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

139. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on feature __t13 (cost=9.05..831.26 rows=270 width=260) (actual rows= loops=)

  • Sort Key: __t15.path DESC
140. 0.000 0.000 ↓ 0.0

Hash Join (cost=70.50..74.14 rows=1 width=49) (actual rows= loops=)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • 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[]))
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Hash Cond: (__t14_1.id = __t18.parent_id)
  • Filter: (isvalid AND (reservetype = 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)))
  • 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)
141. 0.000 0.000 ↓ 0.0

Hash Join (cost=107.70..930.82 rows=1 width=537) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Hash (cost=340.33..340.33 rows=7 width=56) (actual rows= loops=)

143. 0.000 0.000 ↓ 0.0

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

144. 0.000 0.000 ↓ 0.0

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

145. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on feature __t14_1 (cost=9.04..831.25 rows=243 width=32) (actual rows= loops=)

  • Hash Cond: (((btrim(((json_array_elements(to_json((regexp_matches((__t11.path)::text, '([^/]+)/'::text, 'g'::text))))))::text, '"'::text))::uuid) = __t15.id)
146. 0.000 0.000 ↓ 0.0

HashAggregate (cost=48.15..50.15 rows=200 width=16) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Hash Cond: (__t14.parent_id = __t11.id)
  • 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)
  • 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)
148. 0.000 0.000 ↓ 0.0

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

149. 0.000 0.000 ↓ 0.0

Hash (cost=98.37..98.37 rows=23 width=460) (actual rows= loops=)

150. 0.000 0.000 ↓ 0.0

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

151. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on price __t18 (cost=316.96..340.33 rows=7 width=56) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on feature __t14 (cost=9.04..831.25 rows=242 width=77) (actual rows= loops=)

  • Group Key: (btrim(((json_array_elements(to_json((regexp_matches((__t11.path)::text, '([^/]+)/'::text, 'g'::text))))))::text, '"'::text))::uuid
153. 0.000 0.000 ↓ 0.0

Result (cost=0.43..35.65 rows=1,000 width=16) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

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

  • 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)
  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • 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))
  • 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
  • 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)
155. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=22.75..98.37 rows=23 width=460) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

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

157. 0.000 0.000 ↓ 0.0

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

158. 0.000 0.000 ↓ 0.0

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

  • 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)
159. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.43..5.65 rows=1,000 width=32) (actual rows= loops=)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Hash Cond: (__t35.id = __t34.good_id)
  • Hash Cond: (__t11.parent_id = __t12.id)
160. 0.000 0.000 ↓ 0.0

Index Scan using i__account_good__evotor_id_new on good __t11 (cost=0.43..75.76 rows=23 width=439) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

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

162. 0.000 0.000 ↓ 0.0

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

163. 0.000 0.000 ↓ 0.0

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

164. 0.000 0.000 ↓ 0.0

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

165. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on good __t35 (cost=8.76..744.34 rows=492 width=32) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.43..0.53 rows=10 width=32) (actual rows= loops=)

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • 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[]))
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (evotor_id_new IS NOT NULL))
  • Filter: ((dtype)::text <> 'Service'::text)
  • 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)
167. 0.000 0.000 ↓ 0.0

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

168. 0.000 0.000 ↓ 0.0

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

169. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on i__good__account_id (cost=0.00..8.63 rows=494 width=0) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

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

  • 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)
  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND ((dtype)::text = 'GoodFolder'::text))
  • Hash Cond: ((__t30.account_id = __t34.account_id) AND (__t30.consignment_id = __t34.id) AND (__t30.store_id = __t33.id))
  • 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)
171. 0.000 0.000 ↓ 0.0

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

172. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cost __t30 (cost=6,672.99..47,297.58 rows=31,924 width=53) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

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

  • 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)
174. 0.000 0.000 ↓ 0.0

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

175. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • 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)
  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
176. 0.000 0.000 ↓ 0.0

Sort (cost=50.14..50.14 rows=2 width=51) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

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

  • Sort Key: __t32.store_id, __t32.consignment_id
  • 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)
178. 0.000 0.000 ↓ 0.0

Sort (cost=50.68..50.74 rows=24 width=51) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

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

180. 0.000 0.000 ↓ 0.0

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

  • Sort Key: __t33.id, __t34.id
  • Sort Key: __t31.store_id, __t31.consignment_id
  • 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))
181. 0.000 0.000 ↓ 0.0

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

182. 0.000 0.000 ↓ 0.0

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

  • 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))
183. 0.000 0.000 ↓ 0.0

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

184. 0.000 0.000 ↓ 0.0

Hash Join (cost=865.16..1,537.85 rows=1 width=122) (actual rows= loops=)

  • Hash Cond: (__t29.element_id = __t34.feature_id)
  • 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)))
185. 0.000 0.000 ↓ 0.0

Hash (cost=838.50..838.50 rows=563 width=101) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

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

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

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

188. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on consignment __t34 (cost=9.29..838.50 rows=563 width=101) (actual rows= loops=)

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

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

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)