explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8fmO

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 163.871 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,842.81..1,916.51 rows=1 width=1,435) (actual time=163.865..163.871 rows=1 loops=1)

  • Join Filter: (__t13_2.id = __t13.id)
2. 0.003 163.846 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,825.45..1,899.02 rows=1 width=1,539) (actual time=163.841..163.846 rows=1 loops=1)

3. 0.015 163.835 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,825.17..1,896.48 rows=1 width=1,541) (actual time=163.830..163.835 rows=1 loops=1)

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

Nested Loop Left Join (cost=1,781.97..1,853.20 rows=1 width=1,509) (actual time=161.960..161.965 rows=1 loops=1)

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

Nested Loop Left Join (cost=1,688.63..1,759.77 rows=1 width=1,477) (actual time=157.564..157.569 rows=1 loops=1)

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

Nested Loop Left Join (cost=1,616.86..1,687.92 rows=1 width=1,461) (actual time=157.542..157.546 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 154.527 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,413.78..1,484.75 rows=1 width=1,429) (actual time=154.523..154.527 rows=1 loops=1)

  • Join Filter: (__t14_3.id = __t13.id)
8. 0.364 154.505 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,401.33..1,472.25 rows=1 width=1,397) (actual time=154.502..154.505 rows=1 loops=1)

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

Nested Loop Left Join (cost=170.89..241.76 rows=1 width=1,365) (actual time=127.928..127.931 rows=1 loops=1)

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

Nested Loop Left Join (cost=134.92..205.74 rows=1 width=1,333) (actual time=38.475..38.477 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.002 38.468 ↑ 1.0 1 1

Limit (cost=134.64..203.16 rows=1 width=1,341) (actual time=38.467..38.468 rows=1 loops=1)

12. 0.007 38.466 ↑ 1.0 1 1

Result (cost=134.64..203.16 rows=1 width=1,341) (actual time=38.465..38.466 rows=1 loops=1)

13. 0.012 38.430 ↑ 1.0 1 1

Sort (cost=134.64..134.64 rows=1 width=1,362) (actual time=38.429..38.430 rows=1 loops=1)

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

Nested Loop Left Join (cost=1.72..134.63 rows=1 width=1,362) (actual time=0.057..38.418 rows=1 loops=1)

15. 2.238 38.413 ↑ 1.0 1 1

Nested Loop (cost=1.29..129.64 rows=1 width=752) (actual time=0.053..38.413 rows=1 loops=1)

  • Join Filter: ((__t11.id = __t13.parent_id) AND ((((__t11.evotor_id_new)::text = '00006218-2548-4eca-a1da-001639a2efac'::text) AND __t13.isdefault) OR ((__t13.evotor_id_new)::text = '00006218-2548-4eca-a1da-001639a2efac'::text)))
  • Rows Removed by Join Filter: 3452
16. 3.529 22.363 ↓ 3,453.0 3,453 1

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

17. 5.022 5.022 ↓ 143.9 3,453 1

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

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

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

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

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

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

Index Scan using good_pkey on good __t12 (cost=0.43..2.70 rows=1 width=53) (actual time=0.001..0.001 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)
21.          

SubPlan (for Result)

22. 0.001 0.029 ↓ 0.0 0 1

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

23. 0.010 0.028 ↓ 0.0 0 1

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

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

Hash Join (cost=64.84..68.48 rows=1 width=49) (actual time=0.018..0.018 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.000 0.012 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
32. 0.012 0.012 ↓ 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.012..0.012 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.006 0.006 ↑ 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.006..0.006 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. 9.849 89.057 ↓ 2,197.0 2,197 1

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

  • Group Key: __t13_1.id
35. 2.319 79.208 ↓ 2,198.0 2,198 1

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

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

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

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

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

38. 3.129 36.795 ↓ 3,453.0 3,453 1

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

39. 3.368 19.854 ↓ 3,453.0 3,453 1

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

40. 2.190 2.674 ↓ 3,453.0 3,453 1

Bitmap Heap Scan on price __t18 (cost=16.78..17.94 rows=1 width=56) (actual time=0.511..2.674 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.012 0.484 ↓ 0.0 0 1

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

42. 0.224 0.224 ↓ 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.224..0.224 rows=3,453 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Group Key: __t14_2.id
51. 1.736 22.440 ↓ 2,198.0 2,198 1

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

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

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

53. 1.695 6.893 ↓ 3,453.0 3,453 1

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

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

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

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

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

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 248kB
57. 2.285 2.285 ↓ 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.016..2.285 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.000 0.019 ↓ 0.0 0 1

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

  • Group Key: __t14_3.id
60. 0.008 0.019 ↓ 0.0 0 1

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

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

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

62. 0.000 0.010 ↓ 0.0 0 1

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

63. 0.010 0.010 ↓ 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.010..0.010 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.419 2.981 ↓ 121.0 121 1

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

  • Group Key: __t22.id
67. 0.118 2.562 ↓ 121.0 121 1

GroupAggregate (cost=203.08..203.12 rows=1 width=64) (actual time=2.438..2.562 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.070 2.444 ↓ 121.0 121 1

Sort (cost=203.08..203.09 rows=1 width=37) (actual time=2.432..2.444 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.174 2.374 ↓ 121.0 121 1

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

70. 0.053 1.716 ↓ 121.0 121 1

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

71. 0.051 1.179 ↓ 121.0 121 1

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

72. 0.057 0.644 ↓ 121.0 121 1

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

73. 0.224 0.224 ↓ 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.020..0.224 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.363 0.363 ↑ 1.0 1 121

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

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

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

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

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

  • Group Key: __t28.kit_id, __t28.root_store_id
80. 0.006 0.019 ↓ 0.0 0 1

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

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

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

82. 0.001 0.013 ↓ 0.0 0 1

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

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

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

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

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

  • Group Key: __t37.id
99. 0.161 3.790 ↓ 176.0 176 1

GroupAggregate (cost=93.34..93.38 rows=1 width=64) (actual time=3.621..3.790 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.101 3.629 ↓ 176.0 176 1

Sort (cost=93.34..93.35 rows=1 width=35) (actual time=3.613..3.629 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.296 3.528 ↓ 176.0 176 1

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

102. 0.077 2.528 ↓ 176.0 176 1

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

103. 0.060 1.747 ↓ 176.0 176 1

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

104. 0.096 0.983 ↓ 176.0 176 1

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

105. 0.359 0.359 ↓ 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.017..0.359 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.232 1.855 ↓ 67.0 67 1

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

  • Group Key: __t43.id
111. 0.066 1.623 ↓ 67.0 67 1

GroupAggregate (cost=43.19..43.23 rows=1 width=64) (actual time=1.559..1.623 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.042 1.557 ↓ 67.0 67 1

Sort (cost=43.19..43.20 rows=1 width=35) (actual time=1.551..1.557 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.114 1.515 ↓ 67.0 67 1

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

114. 0.040 1.133 ↓ 67.0 67 1

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

115. 0.031 0.825 ↓ 67.0 67 1

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

116. 0.028 0.526 ↓ 67.0 67 1

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

117. 0.297 0.297 ↓ 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.019..0.297 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.201 0.201 ↑ 1.0 1 67

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

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

Index Scan using uom_pkey on uom __t3 (cost=0.28..2.50 rows=1 width=30) (actual time=0.008..0.008 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.000 0.010 ↓ 0.0 0 1

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

  • Group Key: __t13_2.id
124. 0.004 0.010 ↓ 0.0 0 1

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

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

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

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

127. 0.000 0.005 ↓ 0.0 0 1

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

128. 0.001 0.005 ↓ 0.0 0 1

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

  • Join Filter: (__t49.id = __t50.attribute_id)
129. 0.004 0.004 ↓ 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.004..0.004 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 : 57.982 ms
Execution time : 165.378 ms