explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uyqk

Settings
# exclusive inclusive rows x rows loops node
1. 9.235 12,483.586 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=1,912.42..1,987.20 rows=1 width=1,435) (actual time=194.328..12,483.586 rows=1,000 loops=1)

  • Join Filter: (__t13_2.id = __t13.id)
2. 4.782 12,474.351 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=1,895.05..1,969.72 rows=1 width=1,539) (actual time=194.304..12,474.351 rows=1,000 loops=1)

3. 12.651 12,456.569 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=1,894.77..1,967.17 rows=1 width=1,541) (actual time=194.294..12,456.569 rows=1,000 loops=1)

  • Join Filter: (__t13.id = __t43.id)
  • Rows Removed by Join Filter: 65,727
4. 28.184 12,143.918 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=1,851.58..1,923.89 rows=1 width=1,509) (actual time=192.845..12,143.918 rows=1,000 loops=1)

  • Join Filter: (__t13.id = __t37.id)
  • Rows Removed by Join Filter: 166,591
5. 2.666 11,351.734 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=1,758.23..1,830.47 rows=1 width=1,477) (actual time=189.113..11,351.734 rows=1,000 loops=1)

  • Join Filter: (((__t11.dtype)::text = 'Kit'::text) AND (__t28.kit_id = __t11.id))
6. 38.146 11,348.068 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=1,686.47..1,758.62 rows=1 width=1,461) (actual time=189.093..11,348.068 rows=1,000 loops=1)

  • Join Filter: (((__t11.dtype)::text = 'Good'::text) AND (__t13.id = __t22.id))
  • Rows Removed by Join Filter: 116,936
7. 1.770 10,750.922 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=1,483.39..1,555.45 rows=1 width=1,429) (actual time=186.692..10,750.922 rows=1,000 loops=1)

  • Join Filter: (__t14_3.id = __t13.id)
8. 240.560 10,748.152 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=1,470.94..1,542.95 rows=1 width=1,397) (actual time=186.675..10,748.152 rows=1,000 loops=1)

  • Join Filter: (__t14_2.id = __t13.id)
  • Rows Removed by Join Filter: 1,499,500
9. 260.970 7,489.592 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=240.49..312.46 rows=1 width=1,365) (actual time=157.254..7,489.592 rows=1,000 loops=1)

  • Join Filter: (__t13_1.id = __t13.id)
  • Rows Removed by Join Filter: 1,499,500
10. 2.169 132.622 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=204.54..276.44 rows=1 width=1,333) (actual time=74.824..132.622 rows=1,000 loops=1)

  • Join Filter: (__t5.id = (CASE WHEN ((NOT __t13.isdefault) AND (__t13.buycurrency_id IS NULL)) THEN __t14.buycurrency_id ELSE __t13.buycurrency_id END))
11. 0.693 123.453 ↓ 1,000.0 1,000 1

Limit (cost=204.25..273.87 rows=1 width=1,341) (actual time=74.792..123.453 rows=1,000 loops=1)

12. 5.555 122.760 ↓ 2,000.0 2,000 1

Result (cost=134.63..204.25 rows=1 width=1,341) (actual time=50.726..122.760 rows=2,000 loops=1)

13. 6.076 51.370 ↓ 2,000.0 2,000 1

Sort (cost=134.63..134.64 rows=1 width=1,362) (actual time=50.686..51.370 rows=2,000 loops=1)

  • Sort Key: __t13.id
  • Sort Method: quicksort Memory: 1,554kB
14. 4.333 45.294 ↓ 3,453.0 3,453 1

Nested Loop Left Join (cost=1.72..134.62 rows=1 width=1,362) (actual time=0.071..45.294 rows=3,453 loops=1)

15. 3.241 40.961 ↓ 3,453.0 3,453 1

Nested Loop (cost=1.29..129.63 rows=1 width=752) (actual time=0.058..40.961 rows=3,453 loops=1)

  • Join Filter: (__t11.id = __t13.parent_id)
16. 1.211 23.908 ↓ 3,453.0 3,453 1

Nested Loop (cost=0.86..122.30 rows=1 width=510) (actual time=0.046..23.908 rows=3,453 loops=1)

17. 5.432 5.432 ↓ 143.9 3,453 1

Index Scan using i__account_good__evotor_id_new on good __t11 (cost=0.43..57.54 rows=24 width=433) (actual time=0.031..5.432 rows=3,453 loops=1)

  • Index Cond: ((account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND (evotor_id_new IS NOT NULL))
  • Filter: ((deleted IS NULL) AND ((dtype)::text = ANY ('{Good,Kit,Service}'::text[])) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
18. 17.265 17.265 ↑ 1.0 1 3,453

Index Scan using u__feature__default on feature __t14 (cost=0.43..2.70 rows=1 width=77) (actual time=0.005..0.005 rows=1 loops=3,453)

  • Index Cond: (parent_id = __t11.id)
  • Filter: ((deleted IS NULL) AND (NOT archived) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
19. 13.812 13.812 ↑ 1.0 1 3,453

Index Scan using i__feature__parent_id on feature __t13 (cost=0.43..7.33 rows=1 width=274) (actual time=0.004..0.004 rows=1 loops=3,453)

  • Index Cond: (parent_id = __t14.parent_id)
  • Filter: ((deleted IS NULL) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
20. 0.000 0.000 ↓ 0.0 0 3,453

Index Scan using good_pkey on good __t12 (cost=0.43..2.70 rows=1 width=53) (actual time=0.000..0.000 rows=0 loops=3,453)

  • Index Cond: (id = __t11.parent_id)
  • Filter: ((evotor_id_new IS NOT NULL) AND (deleted IS NULL) AND ((dtype)::text = 'GoodFolder'::text) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
21.          

SubPlan (for Result)

22. 1.995 65.835 ↓ 0.0 0 1,995

Limit (cost=69.58..69.59 rows=1 width=49) (actual time=0.033..0.033 rows=0 loops=1,995)

23. 9.975 63.840 ↓ 0.0 0 1,995

Sort (cost=69.58..69.59 rows=1 width=49) (actual time=0.032..0.032 rows=0 loops=1,995)

  • Sort Key: __t15.path DESC
  • Sort Method: quicksort Memory: 25kB
24. 2.002 53.865 ↓ 0.0 0 1,995

Hash Join (cost=65.93..69.57 rows=1 width=49) (actual time=0.027..0.027 rows=0 loops=1,995)

  • Hash Cond: (((btrim(((json_array_elements(to_json((regexp_matches((__t11.path)::text, '([^/]+)/'::text, 'g'::text))))))::text, '"'::text))::uuid) = __t15.id)
25. 3.988 51.844 ↓ 0.0 0 1,994

HashAggregate (cost=49.24..51.24 rows=200 width=16) (actual time=0.026..0.026 rows=0 loops=1,994)

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

Result (cost=0.43..36.74 rows=1,000 width=16) (actual time=0.024..0.024 rows=0 loops=1,994)

27. 1.994 47.856 ↓ 0.0 0 1,994

ProjectSet (cost=0.43..6.74 rows=1,000 width=32) (actual time=0.024..0.024 rows=0 loops=1,994)

28. 9.970 45.862 ↓ 0.0 0 1,994

ProjectSet (cost=0.43..1.61 rows=10 width=32) (actual time=0.023..0.023 rows=0 loops=1,994)

29. 0.000 35.892 ↑ 1.0 1 1,994

Limit (cost=0.43..1.54 rows=1 width=16) (actual time=0.018..0.018 rows=1 loops=1,994)

30. 35.892 35.892 ↑ 485.0 1 1,994

Index Only Scan using i__good__account_id on good __t15_1 (cost=0.43..540.78 rows=485 width=16) (actual time=0.018..0.018 rows=1 loops=1,994)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
  • Heap Fetches: 1,994
31. 0.000 0.019 ↓ 0.0 0 1

Hash (cost=16.68..16.68 rows=1 width=65) (actual time=0.019..0.019 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
32. 0.019 0.019 ↓ 0.0 0 1

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

  • Index Cond: ((account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::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'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
33. 7.000 7.000 ↑ 1.0 1 1,000

Index Scan using i__currency__account_id on currency __t5 (cost=0.29..2.55 rows=1 width=24) (actual time=0.007..0.007 rows=1 loops=1,000)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
  • Filter: CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END
34. 6,848.000 7,096.000 ↓ 1,500.0 1,500 1,000

GroupAggregate (cost=35.96..35.99 rows=1 width=48) (actual time=0.089..7.096 rows=1,500 loops=1,000)

  • Group Key: __t13_1.id
35. 175.019 248.000 ↓ 1,502.0 1,502 1,000

Sort (cost=35.96..35.96 rows=1 width=80) (actual time=0.076..0.248 rows=1,502 loops=1,000)

  • Sort Key: __t13_1.id
  • Sort Method: quicksort Memory: 582kB
36. 2.553 72.981 ↓ 3,453.0 3,453 1

Nested Loop Left Join (cost=18.76..35.95 rows=1 width=80) (actual time=0.568..72.981 rows=3,453 loops=1)

  • Join Filter: (__t19.id = __t18.currency_id)
37. 0.625 63.522 ↓ 3,453.0 3,453 1

Nested Loop Left Join (cost=18.47..33.38 rows=1 width=88) (actual time=0.558..63.522 rows=3,453 loops=1)

38. 2.144 35.273 ↓ 3,453.0 3,453 1

Nested Loop (cost=17.63..27.99 rows=1 width=56) (actual time=0.535..35.273 rows=3,453 loops=1)

39. 3.001 19.317 ↓ 3,453.0 3,453 1

Nested Loop (cost=17.20..20.65 rows=1 width=56) (actual time=0.524..19.317 rows=3,453 loops=1)

40. 2.014 2.504 ↓ 3,453.0 3,453 1

Bitmap Heap Scan on price __t18 (cost=16.77..17.93 rows=1 width=56) (actual time=0.512..2.504 rows=3,453 loops=1)

  • Recheck Cond: ((pricetype_id = '509ca405-bf54-11e9-9109-f8fc0012cfcd'::uuid) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid))
  • Filter: CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END
  • Heap Blocks: exact=191
41. 0.010 0.490 ↓ 0.0 0 1

BitmapAnd (cost=16.77..16.77 rows=1 width=0) (actual time=0.490..0.490 rows=0 loops=1)

42. 0.240 0.240 ↓ 5.7 3,453 1

Bitmap Index Scan on i__price__pricetype_id (cost=0.00..8.24 rows=601 width=0) (actual time=0.240..0.240 rows=3,453 loops=1)

  • Index Cond: (pricetype_id = '509ca405-bf54-11e9-9109-f8fc0012cfcd'::uuid)
43. 0.240 0.240 ↓ 5.7 3,453 1

Bitmap Index Scan on i__price__account_id (cost=0.00..8.28 rows=607 width=0) (actual time=0.240..0.240 rows=3,453 loops=1)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
44. 13.812 13.812 ↑ 1.0 1 3,453

Index Scan using pk__feature on feature __t14_1 (cost=0.43..2.70 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=3,453)

  • Index Cond: (id = __t18.parent_id)
  • Filter: (isdefault AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
45. 13.812 13.812 ↑ 1.0 1 3,453

Index Scan using i__feature__parent_id on feature __t13_1 (cost=0.43..7.33 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=3,453)

  • Index Cond: (parent_id = __t14_1.parent_id)
  • Filter: ((deleted IS NULL) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
46. 3.453 27.624 ↑ 1.0 1 3,453

Nested Loop Left Join (cost=0.84..5.39 rows=1 width=48) (actual time=0.007..0.008 rows=1 loops=3,453)

  • Join Filter: (__t17.id = __t16.currency_id)
47. 17.265 17.265 ↑ 1.0 1 3,453

Index Scan using u__price__parent_id__pricetype_id on price __t16 (cost=0.56..2.82 rows=1 width=56) (actual time=0.004..0.005 rows=1 loops=3,453)

  • Index Cond: ((parent_id = __t13_1.id) AND (pricetype_id = '509ca405-bf54-11e9-9109-f8fc0012cfcd'::uuid))
  • Filter: ((account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
48. 6.906 6.906 ↑ 1.0 1 3,453

Index Scan using i__currency__account_id on currency __t17 (cost=0.29..2.55 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=3,453)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
  • Filter: CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END
49. 6.906 6.906 ↑ 1.0 1 3,453

Index Scan using i__currency__account_id on currency __t19 (cost=0.29..2.55 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=3,453)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
  • Filter: CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END
50. 2,832.000 3,018.000 ↓ 1,500.0 1,500 1,000

GroupAggregate (cost=1,230.44..1,230.47 rows=1 width=48) (actual time=0.036..3.018 rows=1,500 loops=1,000)

  • Group Key: __t14_2.id
51. 160.529 186.000 ↓ 1,502.0 1,502 1,000

Sort (cost=1,230.44..1,230.45 rows=1 width=29) (actual time=0.028..0.186 rows=1,502 loops=1,000)

  • Sort Key: __t14_2.id
  • Sort Method: quicksort Memory: 366kB
52. 2.832 25.471 ↓ 3,453.0 3,453 1

Nested Loop (cost=647.79..1,230.43 rows=1 width=29) (actual time=4.457..25.471 rows=3,453 loops=1)

53. 2.454 8.827 ↓ 3,453.0 3,453 1

Hash Join (cost=647.36..1,227.73 rows=1 width=29) (actual time=4.436..8.827 rows=3,453 loops=1)

  • Hash Cond: (__t4.consignment_id = __t20.id)
54. 1.987 2.309 ↓ 13.7 3,453 1

Bitmap Heap Scan on barcode __t4 (cost=6.47..583.66 rows=252 width=29) (actual time=0.357..2.309 rows=3,453 loops=1)

  • Recheck Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
  • Filter: CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END
  • Heap Blocks: exact=299
55. 0.322 0.322 ↓ 6.9 3,453 1

Bitmap Index Scan on i__barcode__account_id (cost=0.00..6.41 rows=504 width=0) (actual time=0.322..0.322 rows=3,453 loops=1)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
56. 1.192 4.064 ↓ 12.6 3,453 1

Hash (cost=637.47..637.47 rows=273 width=32) (actual time=4.064..4.064 rows=3,453 loops=1)

  • Buckets: 4,096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 248kB
57. 2.872 2.872 ↓ 12.6 3,453 1

Index Scan using i__consignment__account_id on consignment __t20 (cost=0.43..637.47 rows=273 width=32) (actual time=0.022..2.872 rows=3,453 loops=1)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
  • Filter: ((deleted IS NULL) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
58. 13.812 13.812 ↑ 1.0 1 3,453

Index Scan using pk__feature on feature __t14_2 (cost=0.43..2.69 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=3,453)

  • Index Cond: (id = __t20.feature_id)
  • Filter: ((deleted IS NULL) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
59. 1.000 1.000 ↓ 0.0 0 1,000

GroupAggregate (cost=12.45..12.48 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1,000)

  • Group Key: __t14_3.id
60. 0.000 0.000 ↓ 0.0 0 1,000

Sort (cost=12.45..12.46 rows=1 width=35) (actual time=0.000..0.000 rows=0 loops=1,000)

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

Nested Loop (cost=1.00..12.44 rows=1 width=35) (actual time=0.008..0.008 rows=0 loops=1)

62. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.57..9.74 rows=1 width=35) (actual time=0.008..0.008 rows=0 loops=1)

63. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using consignment_good_index on consignment __t20_1 (cost=0.43..7.37 rows=1 width=32) (never executed)

  • Index Cond: (good_id = __t2.good_id)
  • Filter: ((deleted IS NULL) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
65. 0.000 0.000 ↓ 0.0 0

Index Scan using pk__feature on feature __t14_3 (cost=0.43..2.69 rows=1 width=16) (never executed)

  • Index Cond: (id = __t20_1.feature_id)
  • Filter: ((deleted IS NULL) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
66. 421.000 559.000 ↓ 117.0 117 1,000

GroupAggregate (cost=203.08..203.14 rows=1 width=48) (actual time=0.020..0.559 rows=117 loops=1,000)

  • Group Key: __t22.id
67. 123.000 138.000 ↓ 117.0 117 1,000

GroupAggregate (cost=203.08..203.12 rows=1 width=64) (actual time=0.006..0.138 rows=117 loops=1,000)

  • Group Key: __t22.id, (CASE WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) THEN '50993e07-bf54-11e9-9109-f8fc0012cfc7'::uuid ELSE NULL::uuid END)
68. 13.119 15.000 ↓ 117.0 117 1,000

Sort (cost=203.08..203.09 rows=1 width=37) (actual time=0.002..0.015 rows=117 loops=1,000)

  • Sort Key: __t22.id, (CASE WHEN (((__t24.path)::text || (__t24.id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) THEN '50993e07-bf54-11e9-9109-f8fc0012cfc7'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 34kB
69. 0.128 1.881 ↓ 121.0 121 1

Nested Loop (cost=2.13..203.07 rows=1 width=37) (actual time=0.081..1.881 rows=121 loops=1)

70. 0.060 1.390 ↓ 121.0 121 1

Nested Loop (cost=1.70..201.82 rows=1 width=60) (actual time=0.068..1.390 rows=121 loops=1)

71. 0.093 0.967 ↓ 121.0 121 1

Nested Loop (cost=1.27..200.63 rows=1 width=44) (actual time=0.060..0.967 rows=121 loops=1)

72. 0.085 0.511 ↓ 121.0 121 1

Nested Loop (cost=0.84..197.99 rows=1 width=44) (actual time=0.049..0.511 rows=121 loops=1)

73. 0.184 0.184 ↓ 2.3 121 1

Index Scan using i__cost_momentto on cost __t23 (cost=0.56..73.12 rows=53 width=37) (actual time=0.033..0.184 rows=121 loops=1)

  • Index Cond: ((account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: ((initialcost_id IS NULL) AND (motion_id IS NOT NULL) AND isvalid AND (stock <> '0'::numeric))
  • Rows Removed by Filter: 54
74. 0.242 0.242 ↑ 1.0 1 121

Index Scan using place_pkey on place __t24 (cost=0.29..2.35 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=121)

  • Index Cond: (id = __t23.store_id)
  • Filter: ((((path)::text || (id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
75. 0.363 0.363 ↑ 1.0 1 121

Index Scan using consignment_pkey on consignment __t25 (cost=0.43..2.65 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=121)

  • Index Cond: (id = __t23.consignment_id)
  • Filter: isdefault
76. 0.363 0.363 ↑ 1.0 1 121

Index Scan using pk__feature on feature __t22 (cost=0.43..1.19 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=121)

  • Index Cond: (id = __t25.feature_id)
77. 0.363 0.363 ↑ 1.0 1 121

Index Scan using good_pkey on good __t26 (cost=0.43..1.24 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=121)

  • Index Cond: (id = __t22.parent_id)
  • Filter: ((NOT archived) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
78. 1.000 1.000 ↓ 0.0 0 1,000

GroupAggregate (cost=71.76..71.82 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1,000)

  • Group Key: __t28.kit_id
79. 0.000 0.000 ↓ 0.0 0 1,000

GroupAggregate (cost=71.76..71.80 rows=1 width=64) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Group Key: __t28.kit_id, __t28.root_store_id
80. 0.000 0.000 ↓ 0.0 0 1,000

Sort (cost=71.76..71.77 rows=1 width=69) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Sort Key: __t28.kit_id, __t28.root_store_id
  • Sort Method: quicksort Memory: 25kB
81. 0.000 0.011 ↓ 0.0 0 1

Subquery Scan on __t28 (cost=71.69..71.75 rows=1 width=69) (actual time=0.011..0.011 rows=0 loops=1)

82. 0.000 0.011 ↓ 0.0 0 1

GroupAggregate (cost=71.69..71.74 rows=1 width=85) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: __t29.id, (CASE WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) THEN '50993e07-bf54-11e9-9109-f8fc0012cfc7'::uuid ELSE NULL::uuid END)
83. 0.004 0.011 ↓ 0.0 0 1

Sort (cost=71.69..71.70 rows=1 width=64) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: __t29.id, (CASE WHEN (((__t33.path)::text || (__t33.id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) THEN '50993e07-bf54-11e9-9109-f8fc0012cfc7'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 25kB
84. 0.001 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.31..71.68 rows=1 width=64) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: ((__t33.id = __t32.store_id) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", __t34.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN (NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t34.shared) ELSE false END AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", __t33.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN (NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t33.shared) ELSE false END)
85. 0.000 0.006 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.76..68.80 rows=1 width=174) (actual time=0.006..0.006 rows=0 loops=1)

  • Join Filter: ((__t33.id = __t31.store_id) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", __t34.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN (NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t34.shared) ELSE false END AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", __t33.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN (NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t33.shared) ELSE false END)
86. 0.000 0.006 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.21..65.94 rows=1 width=171) (actual time=0.006..0.006 rows=0 loops=1)

  • Join Filter: ((__t33.id = __t30.store_id) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", __t34.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN (NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t34.shared) ELSE false END AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", __t33.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN (NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR __t33.shared) ELSE false END)
87. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=2.65..63.05 rows=1 width=166) (actual time=0.006..0.006 rows=0 loops=1)

88. 0.000 0.005 ↓ 0.0 0 1

Nested Loop (cost=2.36..60.48 rows=1 width=106) (actual time=0.005..0.005 rows=0 loops=1)

89. 0.000 0.005 ↓ 0.0 0 1

Nested Loop (cost=1.93..57.85 rows=1 width=122) (actual time=0.005..0.005 rows=0 loops=1)

90. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on kitelement __t29 (cost=1.50..17.95 rows=15 width=69) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
91. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on index_kitelement_account_id (cost=0.00..1.50 rows=15 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using i_consignment_feature_id on consignment __t34 (cost=0.43..2.65 rows=1 width=101) (never executed)

  • Index Cond: (feature_id = __t29.element_id)
  • Filter: (isdefault AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid))
93. 0.000 0.000 ↓ 0.0 0

Index Scan using good_pkey on good __t35 (cost=0.43..2.62 rows=1 width=32) (never executed)

  • Index Cond: (id = __t34.good_id)
  • Filter: (((dtype)::text <> 'Service'::text) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid))
94. 0.000 0.000 ↓ 0.0 0

Index Scan using i__place__account_id on place __t33 (cost=0.29..2.56 rows=1 width=60) (never executed)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
  • Filter: ((((path)::text || (id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
95. 0.000 0.000 ↓ 0.0 0

Index Scan using cost_cons_moment on cost __t30 (cost=0.56..2.78 rows=1 width=53) (never executed)

  • Index Cond: ((__t34.account_id = account_id) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND (__t34.id = consignment_id))
  • Filter: ((initialcost_id IS NULL) AND (motion_id IS NOT NULL) AND isvalid AND (momentto = 'infinity'::timestamp without time zone))
96. 0.000 0.000 ↓ 0.0 0

Index Scan using i__reserve_momentto on reserve __t31 (cost=0.55..2.76 rows=1 width=51) (never executed)

  • Index Cond: ((account_id = __t34.account_id) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND (__t34.id = consignment_id) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: ((motion_id IS NOT NULL) AND isvalid AND (reservetype = 1))
97. 0.000 0.000 ↓ 0.0 0

Index Scan using i__reserve_momentto on reserve __t32 (cost=0.55..2.76 rows=1 width=51) (never executed)

  • Index Cond: ((account_id = __t34.account_id) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND (__t34.id = consignment_id) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: ((motion_id IS NOT NULL) AND isvalid AND (reservetype = 0))
98. 580.000 764.000 ↓ 167.0 167 1,000

GroupAggregate (cost=93.34..93.41 rows=1 width=48) (actual time=0.012..0.764 rows=167 loops=1,000)

  • Group Key: __t37.id
99. 163.000 184.000 ↓ 167.0 167 1,000

GroupAggregate (cost=93.34..93.38 rows=1 width=64) (actual time=0.006..0.184 rows=167 loops=1,000)

  • Group Key: __t37.id, (CASE WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) THEN '50993e07-bf54-11e9-9109-f8fc0012cfc7'::uuid ELSE NULL::uuid END)
100. 18.067 21.000 ↓ 167.0 167 1,000

Sort (cost=93.34..93.35 rows=1 width=35) (actual time=0.003..0.021 rows=167 loops=1,000)

  • Sort Key: __t37.id, (CASE WHEN (((__t39.path)::text || (__t39.id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) THEN '50993e07-bf54-11e9-9109-f8fc0012cfc7'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 38kB
101. 0.199 2.933 ↓ 176.0 176 1

Nested Loop (cost=2.13..93.33 rows=1 width=35) (actual time=0.057..2.933 rows=176 loops=1)

102. 0.125 2.030 ↓ 176.0 176 1

Nested Loop (cost=1.70..92.63 rows=1 width=58) (actual time=0.045..2.030 rows=176 loops=1)

103. 0.061 1.377 ↓ 176.0 176 1

Nested Loop (cost=1.27..92.01 rows=1 width=42) (actual time=0.038..1.377 rows=176 loops=1)

104. 0.137 0.788 ↓ 176.0 176 1

Nested Loop (cost=0.84..89.36 rows=1 width=42) (actual time=0.028..0.788 rows=176 loops=1)

105. 0.299 0.299 ↓ 8.0 176 1

Index Scan using i__reserve_momentto on reserve __t38 (cost=0.55..34.03 rows=22 width=35) (actual time=0.015..0.299 rows=176 loops=1)

  • Index Cond: ((account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: (isvalid AND (reservetype = 1))
  • Rows Removed by Filter: 67
106. 0.352 0.352 ↑ 1.0 1 176

Index Scan using place_pkey on place __t39 (cost=0.29..2.51 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=176)

  • Index Cond: (id = __t38.store_id)
  • Filter: ((((path)::text || (id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
107. 0.528 0.528 ↑ 1.0 1 176

Index Scan using consignment_pkey on consignment __t40 (cost=0.43..2.65 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=176)

  • Index Cond: (id = __t38.consignment_id)
108. 0.528 0.528 ↑ 1.0 1 176

Index Scan using pk__feature on feature __t37 (cost=0.43..0.63 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=176)

  • Index Cond: (id = __t40.feature_id)
109. 0.704 0.704 ↑ 1.0 1 176

Index Scan using good_pkey on good __t41 (cost=0.43..0.69 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=176)

  • Index Cond: (id = __t37.parent_id)
  • Filter: ((NOT archived) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
110. 227.000 300.000 ↓ 66.0 66 1,000

GroupAggregate (cost=43.19..43.26 rows=1 width=48) (actual time=0.010..0.300 rows=66 loops=1,000)

  • Group Key: __t43.id
111. 65.000 73.000 ↓ 66.0 66 1,000

GroupAggregate (cost=43.19..43.23 rows=1 width=64) (actual time=0.003..0.073 rows=66 loops=1,000)

  • Group Key: __t43.id, (CASE WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) THEN '50993e07-bf54-11e9-9109-f8fc0012cfc7'::uuid ELSE NULL::uuid END)
112. 6.829 8.000 ↓ 66.0 66 1,000

Sort (cost=43.19..43.20 rows=1 width=35) (actual time=0.001..0.008 rows=66 loops=1,000)

  • Sort Key: __t43.id, (CASE WHEN (((__t45.path)::text || (__t45.id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) THEN '50993e07-bf54-11e9-9109-f8fc0012cfc7'::uuid ELSE NULL::uuid END)
  • Sort Method: quicksort Memory: 30kB
113. 0.078 1.171 ↓ 67.0 67 1

Nested Loop (cost=2.13..43.18 rows=1 width=35) (actual time=0.053..1.171 rows=67 loops=1)

114. 0.031 0.892 ↓ 67.0 67 1

Nested Loop (cost=1.70..42.48 rows=1 width=58) (actual time=0.043..0.892 rows=67 loops=1)

115. 0.036 0.660 ↓ 67.0 67 1

Nested Loop (cost=1.27..41.86 rows=1 width=42) (actual time=0.036..0.660 rows=67 loops=1)

116. 0.062 0.423 ↓ 67.0 67 1

Nested Loop (cost=0.84..39.21 rows=1 width=42) (actual time=0.027..0.423 rows=67 loops=1)

117. 0.227 0.227 ↓ 33.5 67 1

Index Scan using i__reserve_momentto on reserve __t44 (cost=0.55..34.03 rows=2 width=35) (actual time=0.015..0.227 rows=67 loops=1)

  • Index Cond: ((account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: (isvalid AND (reservetype = 0))
  • Rows Removed by Filter: 176
118. 0.134 0.134 ↑ 1.0 1 67

Index Scan using place_pkey on place __t45 (cost=0.29..2.56 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=67)

  • Index Cond: (id = __t44.store_id)
  • Filter: ((((path)::text || (id)::text) ~~ '/50993e07-bf54-11e9-9109-f8fc0012cfc7%'::text) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
119. 0.201 0.201 ↑ 1.0 1 67

Index Scan using consignment_pkey on consignment __t46 (cost=0.43..2.65 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=67)

  • Index Cond: (id = __t44.consignment_id)
120. 0.201 0.201 ↑ 1.0 1 67

Index Scan using pk__feature on feature __t43 (cost=0.43..0.63 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=67)

  • Index Cond: (id = __t46.feature_id)
121. 0.201 0.201 ↑ 1.0 1 67

Index Scan using good_pkey on good __t47 (cost=0.43..0.69 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=67)

  • Index Cond: (id = __t43.parent_id)
  • Filter: ((NOT archived) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '6419f2bf-bf54-11e9-912f-f3d4000fec83'::uuid)) OR (NOT (group_id IS DISTINCT FROM '506460d9-bf54-11e9-9109-f8fc00000ffc'::uuid)) OR shared) ELSE false END)
122. 13.000 13.000 ↑ 1.0 1 1,000

Index Scan using uom_pkey on uom __t3 (cost=0.28..2.50 rows=1 width=30) (actual time=0.013..0.013 rows=1 loops=1,000)

  • Index Cond: (id = __t11.uom_id)
  • Filter: ((account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) OR (account_id IS NULL))
123. 0.000 0.000 ↓ 0.0 0 1,000

GroupAggregate (cost=17.37..17.39 rows=1 width=48) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Group Key: __t13_2.id
124. 0.000 0.000 ↓ 0.0 0 1,000

Sort (cost=17.37..17.37 rows=1 width=90) (actual time=0.000..0.000 rows=0 loops=1,000)

  • Sort Key: __t13_2.id
  • Sort Method: quicksort Memory: 25kB
125. 0.000 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.85..17.36 rows=1 width=90) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: (__t51.metadata_id = __t49.attribute_metadata_id)
  • Filter: (((__t51.valuestring)::text = (__t50.name)::text) OR ((__t51.valuestring IS NULL) AND ((__t50.evotor_id_new)::text = (__t49.evotor_attribute_id_new)::text)))
126. 0.001 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.43..14.70 rows=1 width=111) (actual time=0.007..0.007 rows=0 loops=1)

127. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.00..7.64 rows=1 width=111) (actual time=0.006..0.006 rows=0 loops=1)

128. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=0.57..4.98 rows=1 width=132) (actual time=0.006..0.006 rows=0 loops=1)

  • Join Filter: (__t49.id = __t50.attribute_id)
129. 0.006 0.006 ↓ 0.0 0 1

Index Scan using ui__account_evotorattribute__evotor_id_new on evotorattribute __t49 (cost=0.28..2.47 rows=1 width=106) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
130. 0.000 0.000 ↓ 0.0 0

Index Scan using i__evotorchoice__account_id on evotorchoice __t50 (cost=0.29..2.50 rows=1 width=58) (never executed)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
131. 0.000 0.000 ↓ 0.0 0

Index Scan using i__feature__evotor_id_new on feature __t14_4 (cost=0.43..2.65 rows=1 width=53) (never executed)

  • Index Cond: ((evotor_id_new)::text = (__t49.evotor_group_id_new)::text)
  • Filter: (isdefault AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid))
132. 0.000 0.000 ↓ 0.0 0

Index Scan using i__feature__parent_id on feature __t13_2 (cost=0.43..7.04 rows=1 width=32) (never executed)

  • Index Cond: (parent_id = __t14_4.parent_id)
  • Filter: ((NOT isdefault) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid))
133. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) AND (parent_id = __t13_2.id))
Planning time : 47.815 ms
Execution time : 12,486.167 ms