explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l44O

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 94.335 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,721.29..1,794.99 rows=1 width=1,435) (actual time=94.331..94.335 rows=1 loops=1)

  • Join Filter: (__t13_2.id = __t13.id)
2. 0.001 94.306 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,703.93..1,777.51 rows=1 width=1,539) (actual time=94.303..94.306 rows=1 loops=1)

3. 0.015 94.292 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,703.65..1,774.96 rows=1 width=1,541) (actual time=94.288..94.292 rows=1 loops=1)

  • Join Filter: (__t13.id = __t43.id)
  • Rows Removed by Join Filter: 67
4. 0.030 92.072 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,660.45..1,731.68 rows=1 width=1,509) (actual time=92.068..92.072 rows=1 loops=1)

  • Join Filter: (__t13.id = __t37.id)
  • Rows Removed by Join Filter: 176
5. 0.002 87.371 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,567.11..1,638.25 rows=1 width=1,477) (actual time=87.368..87.371 rows=1 loops=1)

  • Join Filter: (((__t11.dtype)::text = 'Kit'::text) AND (__t28.kit_id = __t11.id))
6. 0.039 87.342 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,495.34..1,566.40 rows=1 width=1,461) (actual time=87.339..87.342 rows=1 loops=1)

  • Join Filter: (((__t11.dtype)::text = 'Good'::text) AND (__t13.id = __t22.id))
  • Rows Removed by Join Filter: 121
7. 0.003 83.704 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,292.26..1,363.23 rows=1 width=1,429) (actual time=83.702..83.704 rows=1 loops=1)

  • Join Filter: (__t14_3.id = __t13.id)
8. 0.373 83.680 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,279.81..1,350.73 rows=1 width=1,397) (actual time=83.678..83.680 rows=1 loops=1)

  • Join Filter: (__t14_2.id = __t13.id)
  • Rows Removed by Join Filter: 2196
9. 0.311 56.630 ↑ 1.0 1 1

Nested Loop Left Join (cost=49.37..120.24 rows=1 width=1,365) (actual time=56.628..56.630 rows=1 loops=1)

  • Join Filter: (__t13_1.id = __t13.id)
  • Rows Removed by Join Filter: 2196
10. 0.001 0.064 ↑ 1.0 1 1

Nested Loop Left Join (cost=13.41..84.22 rows=1 width=1,333) (actual time=0.063..0.064 rows=1 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.001 0.059 ↑ 1.0 1 1

Limit (cost=13.12..81.65 rows=1 width=1,341) (actual time=0.057..0.059 rows=1 loops=1)

12. 0.003 0.058 ↑ 1.0 1 1

Result (cost=13.12..81.65 rows=1 width=1,341) (actual time=0.057..0.058 rows=1 loops=1)

13. 0.007 0.042 ↑ 1.0 1 1

Sort (cost=13.12..13.12 rows=1 width=1,362) (actual time=0.041..0.042 rows=1 loops=1)

  • Sort Key: __t13.id
  • Sort Method: quicksort Memory: 25kB
14. 0.003 0.035 ↑ 1.0 1 1

Nested Loop (cost=1.72..13.11 rows=1 width=1,362) (actual time=0.034..0.035 rows=1 loops=1)

  • Join Filter: (__t11.id = __t14.parent_id)
15. 0.002 0.030 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.29..10.39 rows=1 width=728) (actual time=0.030..0.030 rows=1 loops=1)

16. 0.002 0.028 ↑ 1.0 1 1

Nested Loop (cost=0.86..5.42 rows=1 width=707) (actual time=0.028..0.028 rows=1 loops=1)

17. 0.020 0.020 ↑ 1.0 1 1

Index Scan using i__good__evotor_id_new on good __t11 (cost=0.43..2.70 rows=1 width=433) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((evotor_id_new IS NOT NULL) AND ((evotor_id_new)::text = '00006218-2548-4eca-a1da-001639a2efac'::text))
  • Filter: ((deleted IS NULL) AND (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid) 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. 0.006 0.006 ↑ 1.0 1 1

Index Scan using u__feature__default on feature __t13 (cost=0.43..2.70 rows=1 width=274) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (parent_id = __t11.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)
19. 0.000 0.000 ↓ 0.0 0 1

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

  • 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)
20. 0.002 0.002 ↑ 1.0 1 1

Index Scan using u__feature__default on feature __t14 (cost=0.43..2.69 rows=1 width=77) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (parent_id = __t13.parent_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)
21.          

SubPlan (for Result)

22. 0.000 0.013 ↓ 0.0 0 1

Limit (cost=68.49..68.50 rows=1 width=49) (actual time=0.013..0.013 rows=0 loops=1)

23. 0.003 0.013 ↓ 0.0 0 1

Sort (cost=68.49..68.50 rows=1 width=49) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: __t15.path DESC
  • Sort Method: quicksort Memory: 25kB
24. 0.002 0.010 ↓ 0.0 0 1

Hash Join (cost=64.84..68.48 rows=1 width=49) (actual time=0.010..0.010 rows=0 loops=1)

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

HashAggregate (cost=48.15..50.15 rows=200 width=16) (never executed)

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

Result (cost=0.43..35.65 rows=1,000 width=16) (never executed)

27. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.43..5.65 rows=1,000 width=32) (never executed)

28. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.43..0.52 rows=10 width=32) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.43..0.45 rows=1 width=16) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Index Only Scan using i__good__account_id on good __t15_1 (cost=0.43..12.20 rows=484 width=16) (never executed)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
32. 0.007 0.007 ↓ 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.007..0.007 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. 0.004 0.004 ↑ 1.0 1 1

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

  • 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.864 56.255 ↓ 2,197.0 2,197 1

GroupAggregate (cost=35.96..36.00 rows=1 width=48) (actual time=49.228..56.255 rows=2,197 loops=1)

  • Group Key: __t13_1.id
35. 1.477 49.391 ↓ 2,198.0 2,198 1

Sort (cost=35.96..35.97 rows=1 width=80) (actual time=49.206..49.391 rows=2,198 loops=1)

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

Nested Loop Left Join (cost=18.77..35.95 rows=1 width=80) (actual time=0.415..47.914 rows=3,453 loops=1)

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

Nested Loop Left Join (cost=18.48..33.39 rows=1 width=88) (actual time=0.412..41.963 rows=3,453 loops=1)

38. 0.360 23.476 ↓ 3,453.0 3,453 1

Nested Loop (cost=17.64..27.99 rows=1 width=56) (actual time=0.389..23.476 rows=3,453 loops=1)

39. 0.775 12.757 ↓ 3,453.0 3,453 1

Nested Loop (cost=17.21..20.66 rows=1 width=56) (actual time=0.382..12.757 rows=3,453 loops=1)

40. 1.304 1.623 ↓ 3,453.0 3,453 1

Bitmap Heap Scan on price __t18 (cost=16.78..17.94 rows=1 width=56) (actual time=0.357..1.623 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.006 0.319 ↓ 0.0 0 1

BitmapAnd (cost=16.78..16.78 rows=1 width=0) (actual time=0.319..0.319 rows=0 loops=1)

42. 0.149 0.149 ↓ 5.7 3,453 1

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

  • Index Cond: (pricetype_id = '509ca405-bf54-11e9-9109-f8fc0012cfcd'::uuid)
43. 0.164 0.164 ↓ 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.164..0.164 rows=3,453 loops=1)

  • Index Cond: (account_id = '5063e49a-bf54-11e9-9109-f8fc00000ffb'::uuid)
44. 10.359 10.359 ↑ 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.003..0.003 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. 10.359 10.359 ↑ 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.003..0.003 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 17.265 ↑ 1.0 1 3,453

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

  • Join Filter: (__t17.id = __t16.currency_id)
47. 10.359 10.359 ↑ 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.003..0.003 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. 3.453 3.453 ↑ 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.001..0.001 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. 3.453 3.453 ↑ 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.001..0.001 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. 4.600 26.677 ↓ 2,197.0 2,197 1

GroupAggregate (cost=1,230.44..1,230.47 rows=1 width=48) (actual time=21.836..26.677 rows=2,197 loops=1)

  • Group Key: __t14_2.id
51. 1.993 22.077 ↓ 2,198.0 2,198 1

Sort (cost=1,230.44..1,230.45 rows=1 width=29) (actual time=21.821..22.077 rows=2,198 loops=1)

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

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

53. 1.656 6.054 ↓ 3,453.0 3,453 1

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

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

Bitmap Heap Scan on barcode __t4 (cost=6.47..583.66 rows=252 width=29) (actual time=0.191..1.909 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.166 0.166 ↓ 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.166..0.166 rows=3,453 loops=1)

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

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

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 248kB
57. 1.744 1.744 ↓ 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.011..1.744 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. 0.001 0.021 ↓ 0.0 0 1

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

  • Group Key: __t14_3.id
60. 0.007 0.020 ↓ 0.0 0 1

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

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

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

62. 0.000 0.012 ↓ 0.0 0 1

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

63. 0.012 0.012 ↓ 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.012..0.012 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. 0.495 3.599 ↓ 121.0 121 1

GroupAggregate (cost=203.08..203.14 rows=1 width=48) (actual time=2.952..3.599 rows=121 loops=1)

  • Group Key: __t22.id
67. 0.182 3.104 ↓ 121.0 121 1

GroupAggregate (cost=203.08..203.12 rows=1 width=64) (actual time=2.927..3.104 rows=121 loops=1)

  • 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. 0.096 2.922 ↓ 121.0 121 1

Sort (cost=203.08..203.09 rows=1 width=37) (actual time=2.911..2.922 rows=121 loops=1)

  • 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.183 2.826 ↓ 121.0 121 1

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

70. 0.130 2.038 ↓ 121.0 121 1

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

71. 0.132 1.424 ↓ 121.0 121 1

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

72. 0.044 0.808 ↓ 121.0 121 1

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

73. 0.280 0.280 ↓ 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.034..0.280 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.484 0.484 ↑ 1.0 1 121

Index Scan using place_pkey on place __t24 (cost=0.29..2.35 rows=1 width=23) (actual time=0.004..0.004 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.484 0.484 ↑ 1.0 1 121

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

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

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

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

Index Scan using good_pkey on good __t26 (cost=0.43..1.24 rows=1 width=16) (actual time=0.005..0.005 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. 0.000 0.027 ↓ 0.0 0 1

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

  • Group Key: __t28.kit_id
79. 0.001 0.027 ↓ 0.0 0 1

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

  • Group Key: __t28.kit_id, __t28.root_store_id
80. 0.011 0.026 ↓ 0.0 0 1

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

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

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

82. 0.001 0.015 ↓ 0.0 0 1

GroupAggregate (cost=71.69..71.74 rows=1 width=85) (actual time=0.015..0.015 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.014 ↓ 0.0 0 1

Sort (cost=71.69..71.70 rows=1 width=64) (actual time=0.014..0.014 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.010 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.31..71.68 rows=1 width=64) (actual time=0.010..0.010 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.009 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.76..68.80 rows=1 width=174) (actual time=0.009..0.009 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.009 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.21..65.94 rows=1 width=171) (actual time=0.009..0.009 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.009 ↓ 0.0 0 1

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

88. 0.000 0.008 ↓ 0.0 0 1

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

89. 0.000 0.008 ↓ 0.0 0 1

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

90. 0.001 0.008 ↓ 0.0 0 1

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

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

Bitmap Index Scan on index_kitelement_account_id (cost=0.00..1.50 rows=15 width=0) (actual time=0.007..0.007 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. 0.666 4.671 ↓ 176.0 176 1

GroupAggregate (cost=93.34..93.41 rows=1 width=48) (actual time=3.823..4.671 rows=176 loops=1)

  • Group Key: __t37.id
99. 0.202 4.005 ↓ 176.0 176 1

GroupAggregate (cost=93.34..93.38 rows=1 width=64) (actual time=3.798..4.005 rows=176 loops=1)

  • 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. 0.119 3.803 ↓ 176.0 176 1

Sort (cost=93.34..93.35 rows=1 width=35) (actual time=3.784..3.803 rows=176 loops=1)

  • 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.320 3.684 ↓ 176.0 176 1

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

102. 0.124 2.660 ↓ 176.0 176 1

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

103. 0.134 1.832 ↓ 176.0 176 1

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

104. 0.113 0.994 ↓ 176.0 176 1

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

105. 0.353 0.353 ↓ 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.019..0.353 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.528 0.528 ↑ 1.0 1 176

Index Scan using place_pkey on place __t39 (cost=0.29..2.51 rows=1 width=23) (actual time=0.003..0.003 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.704 0.704 ↑ 1.0 1 176

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

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

Index Scan using pk__feature on feature __t37 (cost=0.43..0.63 rows=1 width=32) (actual time=0.004..0.004 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. 0.268 2.205 ↓ 67.0 67 1

GroupAggregate (cost=43.19..43.26 rows=1 width=48) (actual time=1.880..2.205 rows=67 loops=1)

  • Group Key: __t43.id
111. 0.089 1.937 ↓ 67.0 67 1

GroupAggregate (cost=43.19..43.23 rows=1 width=64) (actual time=1.857..1.937 rows=67 loops=1)

  • 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. 0.063 1.848 ↓ 67.0 67 1

Sort (cost=43.19..43.20 rows=1 width=35) (actual time=1.840..1.848 rows=67 loops=1)

  • 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.086 1.785 ↓ 67.0 67 1

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

114. 0.085 1.364 ↓ 67.0 67 1

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

115. 0.078 1.011 ↓ 67.0 67 1

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

116. 0.042 0.665 ↓ 67.0 67 1

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

117. 0.355 0.355 ↓ 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.022..0.355 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.268 0.268 ↑ 1.0 1 67

Index Scan using place_pkey on place __t45 (cost=0.29..2.56 rows=1 width=23) (actual time=0.004..0.004 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.268 0.268 ↑ 1.0 1 67

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

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

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

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

Index Scan using good_pkey on good __t47 (cost=0.43..0.69 rows=1 width=16) (actual time=0.005..0.005 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. 0.013 0.013 ↑ 1.0 1 1

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)

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

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

  • Group Key: __t13_2.id
124. 0.007 0.017 ↓ 0.0 0 1

Sort (cost=17.37..17.37 rows=1 width=90) (actual time=0.017..0.017 rows=0 loops=1)

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

Nested Loop Left Join (cost=1.85..17.36 rows=1 width=90) (actual time=0.010..0.010 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.000 0.009 ↓ 0.0 0 1

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

127. 0.000 0.009 ↓ 0.0 0 1

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

128. 0.001 0.009 ↓ 0.0 0 1

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

  • Join Filter: (__t49.id = __t50.attribute_id)
129. 0.008 0.008 ↓ 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.008..0.008 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 : 36.035 ms
Execution time : 95.277 ms