explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xeP

Settings
# exclusive inclusive rows x rows loops node
1. 9.033 133,871.437 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=59,162.32..59,207.74 rows=1 width=1,674) (actual time=124,481.160..133,871.437 rows=1,000 loops=1)

2. 52.272 133,857.404 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=59,162.04..59,203.96 rows=1 width=1,556) (actual time=124,481.085..133,857.404 rows=1,000 loops=1)

  • Join Filter: (((__t11.dtype)::text = 'Kit'::text) AND (__t28.kit_id = __t11.id))
  • Rows Removed by Join Filter: 566,656
3. 0.404 16,365.132 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=57,587.05..57,628.88 rows=1 width=1,540) (actual time=16,356.059..16,365.132 rows=1,000 loops=1)

  • Join Filter: (__t5.id = (CASE WHEN ((NOT __t13.isdefault) AND (__t13.buycurrency_id IS NULL)) THEN __t14.buycurrency_id ELSE __t13.buycurrency_id END))
  • Rows Removed by Join Filter: 176
4. 1.418 16,361.728 ↓ 1,000.0 1,000 1

Hash Right Join (cost=57,586.76..57,625.51 rows=1 width=1,548) (actual time=16,356.036..16,361.728 rows=1,000 loops=1)

  • Hash Cond: (__t22.id = __t13.id)
  • Join Filter: ((__t11.dtype)::text = 'Good'::text)
5. 2.673 230.702 ↓ 3.1 615 1

GroupAggregate (cost=55,046.61..55,082.60 rows=200 width=48) (actual time=226.419..230.702 rows=615 loops=1)

  • Group Key: __t22.id
6. 1.394 228.029 ↓ 5.8 1,642 1

GroupAggregate (cost=55,046.61..55,075.82 rows=285 width=64) (actual time=226.384..228.029 rows=1,642 loops=1)

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

Sort (cost=55,046.61..55,047.32 rows=285 width=37) (actual time=226.373..226.635 rows=1,642 loops=1)

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

Nested Loop (cost=11,946.37..55,034.99 rows=285 width=37) (actual time=80.727..224.941 rows=1,642 loops=1)

9. 1.940 167.744 ↓ 2.9 1,651 1

Nested Loop (cost=11,945.94..54,667.12 rows=579 width=60) (actual time=80.698..167.744 rows=1,651 loops=1)

10. 0.546 157.549 ↓ 2.9 1,651 1

Nested Loop (cost=11,945.51..54,371.71 rows=579 width=44) (actual time=80.684..157.549 rows=1,651 loops=1)

11. 0.876 87.661 ↓ 2.9 1,651 1

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

  • Hash Cond: (__t23.store_id = __t24.id)
12. 7.012 19.184 ↑ 17.5 1,682 1

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

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

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

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
15. 67.590 67.590 ↑ 77.5 8 1

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

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

Index Scan using consignment_pkey on consignment __t25 (cost=0.43..2.33 rows=1 width=32) (actual time=0.042..0.042 rows=1 loops=1,651)

  • Index Cond: (id = __t23.consignment_id)
  • Filter: isdefault
17. 8.255 8.255 ↑ 1.0 1 1,651

Index Scan using pk__feature on feature __t22 (cost=0.43..0.51 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=1,651)

  • Index Cond: (id = __t25.feature_id)
18. 52.832 52.832 ↑ 1.0 1 1,651

Index Scan using good_pkey on good __t26 (cost=0.43..0.60 rows=1 width=16) (actual time=0.032..0.032 rows=1 loops=1,651)

  • Index Cond: (id = __t22.parent_id)
  • Filter: ((NOT archived) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 0
19. 2.736 16,129.608 ↓ 1,000.0 1,000 1

Hash (cost=2,540.14..2,540.14 rows=1 width=1,532) (actual time=16,129.608..16,129.608 rows=1,000 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 532kB
20. 1.034 16,126.872 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=2,465.44..2,540.14 rows=1 width=1,532) (actual time=850.415..16,126.872 rows=1,000 loops=1)

  • Join Filter: (__t13_2.id = __t13.id)
21. 1.228 16,125.838 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=2,442.58..2,517.24 rows=1 width=1,500) (actual time=850.341..16,125.838 rows=1,000 loops=1)

  • Join Filter: (__t13.id = __t43.id)
22. 1.193 16,124.610 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=2,380.93..2,455.44 rows=1 width=1,468) (actual time=850.332..16,124.610 rows=1,000 loops=1)

  • Join Filter: (__t13.id = __t37.id)
23. 1.076 16,123.417 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=2,246.77..2,321.12 rows=1 width=1,436) (actual time=850.319..16,123.417 rows=1,000 loops=1)

  • Join Filter: (__t14_3.id = __t13.id)
24. 52.274 16,122.341 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=2,230.32..2,304.62 rows=1 width=1,404) (actual time=850.305..16,122.341 rows=1,000 loops=1)

  • Join Filter: (__t14_2.id = __t13.id)
  • Rows Removed by Join Filter: 667,137
25. 50.686 15,188.067 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=560.49..634.75 rows=1 width=1,372) (actual time=837.321..15,188.067 rows=1,000 loops=1)

  • Join Filter: (__t13_1.id = __t13.id)
  • Rows Removed by Join Filter: 499,500
26. 0.343 351.381 ↓ 1,000.0 1,000 1

Limit (cost=172.56..246.75 rows=1 width=1,340) (actual time=296.564..351.381 rows=1,000 loops=1)

27. 2.572 351.038 ↓ 1,000.0 1,000 1

Result (cost=172.56..246.75 rows=1 width=1,340) (actual time=296.563..351.038 rows=1,000 loops=1)

28. 3.583 296.830 ↓ 1,000.0 1,000 1

Sort (cost=172.56..172.57 rows=1 width=1,361) (actual time=296.436..296.830 rows=1,000 loops=1)

  • Sort Key: __t13.id
  • Sort Method: top-N heapsort Memory: 912kB
29. 2.413 293.247 ↓ 2,034.0 2,034 1

Nested Loop Left Join (cost=1.72..172.55 rows=1 width=1,361) (actual time=1.499..293.247 rows=2,034 loops=1)

30. 2.927 276.596 ↓ 2,034.0 2,034 1

Nested Loop (cost=1.29..165.97 rows=1 width=744) (actual time=1.319..276.596 rows=2,034 loops=1)

  • Join Filter: (__t11.id = __t13.parent_id)
31. 1.120 112.983 ↓ 2,034.0 2,034 1

Nested Loop (cost=0.86..156.23 rows=1 width=516) (actual time=0.874..112.983 rows=2,034 loops=1)

32. 4.061 4.061 ↓ 88.4 2,034 1

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

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

Index Scan using u__feature__default on feature __t14 (cost=0.43..3.50 rows=1 width=77) (actual time=0.053..0.053 rows=1 loops=2,034)

  • Index Cond: (parent_id = __t11.id)
  • Filter: ((deleted IS NULL) AND (NOT archived) AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
34. 160.686 160.686 ↑ 1.0 1 2,034

Index Scan using i__feature__parent_id on feature __t13 (cost=0.43..9.72 rows=1 width=260) (actual time=0.079..0.079 rows=1 loops=2,034)

  • Index Cond: (parent_id = __t14.parent_id)
  • Filter: ((deleted IS NULL) AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
35. 14.238 14.238 ↑ 1.0 1 2,034

Index Scan using good_pkey on good __t12 (cost=0.43..3.50 rows=1 width=53) (actual time=0.007..0.007 rows=1 loops=2,034)

  • 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 = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
36.          

SubPlan (for Result)

37. 0.993 51.636 ↓ 0.0 0 993

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

38. 3.972 50.643 ↓ 0.0 0 993

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

  • Sort Key: __t15.path DESC
  • Sort Method: quicksort Memory: 25kB
39. 1.929 46.671 ↓ 0.0 0 993

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

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

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

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

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

42. 9.920 37.696 ↑ 500.0 2 992

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

43. 15.872 27.776 ↑ 5.0 2 992

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

44. 0.000 11.904 ↑ 1.0 1 992

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

45. 11.904 11.904 ↑ 494.0 1 992

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

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
47. 0.102 0.102 ↓ 0.0 0 1

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

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

GroupAggregate (cost=387.93..387.97 rows=1 width=48) (actual time=0.576..14.786 rows=500 loops=1,000)

  • Group Key: __t13_1.id
49. 526.101 1,052.000 ↓ 8,003.0 8,003 1,000

Sort (cost=387.93..387.93 rows=1 width=80) (actual time=0.541..1.052 rows=8,003 loops=1,000)

  • Sort Key: __t13_1.id
  • Sort Method: quicksort Memory: 5,344kB
50. 18.768 525.899 ↓ 32,537.0 32,537 1

Nested Loop Left Join (cost=318.83..387.92 rows=1 width=80) (actual time=2.521..525.899 rows=32,537 loops=1)

  • Join Filter: (__t17.id = __t16.currency_id)
51. 3.531 474.594 ↓ 32,537.0 32,537 1

Nested Loop Left Join (cost=318.54..384.55 rows=1 width=88) (actual time=2.516..474.594 rows=32,537 loops=1)

52. 5.149 170.068 ↓ 8,135.0 8,135 1

Nested Loop Left Join (cost=318.11..377.93 rows=1 width=48) (actual time=2.257..170.068 rows=8,135 loops=1)

  • Join Filter: (__t19.id = __t18.currency_id)
53. 5.997 156.784 ↓ 8,135.0 8,135 1

Nested Loop (cost=317.82..374.57 rows=1 width=56) (actual time=2.250..156.784 rows=8,135 loops=1)

54. 5.755 126.382 ↓ 8,135.0 8,135 1

Nested Loop (cost=317.39..364.83 rows=1 width=56) (actual time=2.239..126.382 rows=8,135 loops=1)

55. 4.900 6.737 ↓ 1,162.1 8,135 1

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

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

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

57. 0.634 0.634 ↓ 3.3 8,135 1

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

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

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

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
59. 113.890 113.890 ↑ 1.0 1 8,135

Index Scan using pk__feature on feature __t14_1 (cost=0.43..3.50 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=8,135)

  • Index Cond: (id = __t18.parent_id)
  • Filter: (isdefault AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
60. 24.405 24.405 ↑ 1.0 1 8,135

Index Scan using i__feature__parent_id on feature __t13_1 (cost=0.43..9.72 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=8,135)

  • Index Cond: (parent_id = __t14_1.parent_id)
  • Filter: ((deleted IS NULL) AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
61. 8.135 8.135 ↑ 1.0 1 8,135

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

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

Index Scan using i__price__parent_id on price __t16 (cost=0.43..6.61 rows=1 width=56) (actual time=0.021..0.037 rows=4 loops=8,135)

  • Index Cond: (parent_id = __t13_1.id)
  • Filter: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (pricetype_id = ANY ('{b04d1a17-343d-11ea-0a80-044a000102ee,91689409-c7e7-11e9-9109-f8fc0019d39e,1c7181b4-bad0-11e9-912f-f3d40009d2c1,d73e1c7e-3615-11ea-0a80-01b5001729e2}'::uuid[])) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 6
63. 32.537 32.537 ↑ 1.0 1 32,537

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

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

GroupAggregate (cost=1,669.82..1,669.85 rows=1 width=48) (actual time=0.017..0.882 rows=668 loops=1,000)

  • Group Key: __t14_2.id
65. 52.446 63.000 ↓ 917.0 917 1,000

Sort (cost=1,669.82..1,669.83 rows=1 width=29) (actual time=0.011..0.063 rows=917 loops=1,000)

  • Sort Key: __t14_2.id
  • Sort Method: quicksort Memory: 189kB
66. 0.412 10.554 ↓ 1,795.0 1,795 1

Nested Loop (cost=878.04..1,669.81 rows=1 width=29) (actual time=3.090..10.554 rows=1,795 loops=1)

67. 0.510 4.757 ↓ 1,795.0 1,795 1

Hash Join (cost=877.61..1,666.31 rows=1 width=29) (actual time=3.077..4.757 rows=1,795 loops=1)

  • Hash Cond: (__t4.consignment_id = __t20.id)
68. 1.259 1.401 ↓ 6.9 1,795 1

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

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

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

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

Hash (cost=865.17..865.17 rows=282 width=32) (actual time=2.846..2.846 rows=2,034 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 144kB
71. 2.299 2.538 ↓ 7.2 2,034 1

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

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

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

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
73. 5.385 5.385 ↑ 1.0 1 1,795

Index Scan using pk__feature on feature __t14_2 (cost=0.43..3.48 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1,795)

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

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

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

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

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

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

77. 0.001 0.006 ↓ 0.0 0 1

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

78. 0.005 0.005 ↓ 0.0 0 1

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

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

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

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

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

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

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

  • Group Key: __t37.id
82. 0.000 0.000 ↓ 0.0 0 1,000

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

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

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

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

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

85. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=1.70..133.47 rows=1 width=58) (actual time=0.008..0.008 rows=0 loops=1)

86. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=1.27..132.96 rows=1 width=42) (actual time=0.008..0.008 rows=0 loops=1)

87. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.84..129.52 rows=1 width=42) (actual time=0.008..0.008 rows=0 loops=1)

88. 0.007 0.007 ↓ 0.0 0 1

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

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

Index Scan using place_pkey on place __t39 (cost=0.29..3.31 rows=1 width=23) (never executed)

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

Index Scan using consignment_pkey on consignment __t40 (cost=0.43..3.45 rows=1 width=32) (never executed)

  • Index Cond: (id = __t38.consignment_id)
91. 0.000 0.000 ↓ 0.0 0

Index Scan using pk__feature on feature __t37 (cost=0.43..0.51 rows=1 width=32) (never executed)

  • Index Cond: (id = __t40.feature_id)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using good_pkey on good __t41 (cost=0.43..0.60 rows=1 width=16) (never executed)

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

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

  • Group Key: __t43.id
94. 0.000 0.000 ↓ 0.0 0 1,000

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

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

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

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

Nested Loop (cost=2.13..61.64 rows=1 width=35) (actual time=0.004..0.004 rows=0 loops=1)

97. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=1.70..60.96 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=1)

98. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=1.27..60.45 rows=1 width=42) (actual time=0.003..0.003 rows=0 loops=1)

99. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.84..57.00 rows=1 width=42) (actual time=0.003..0.003 rows=0 loops=1)

100. 0.003 0.003 ↓ 0.0 0 1

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

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

Index Scan using place_pkey on place __t45 (cost=0.29..3.43 rows=1 width=23) (never executed)

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

Index Scan using consignment_pkey on consignment __t46 (cost=0.43..3.45 rows=1 width=32) (never executed)

  • Index Cond: (id = __t44.consignment_id)
103. 0.000 0.000 ↓ 0.0 0

Index Scan using pk__feature on feature __t43 (cost=0.43..0.51 rows=1 width=32) (never executed)

  • Index Cond: (id = __t46.feature_id)
104. 0.000 0.000 ↓ 0.0 0

Index Scan using good_pkey on good __t47 (cost=0.43..0.60 rows=1 width=16) (never executed)

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

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

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

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

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

Nested Loop Left Join (cost=1.85..22.85 rows=1 width=90) (actual time=0.070..0.070 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)))
108. 0.001 0.070 ↓ 0.0 0 1

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

109. 0.000 0.069 ↓ 0.0 0 1

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

110. 0.001 0.069 ↓ 0.0 0 1

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

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

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

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

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

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

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

  • Index Cond: ((evotor_id_new)::text = (__t49.evotor_group_id_new)::text)
  • Filter: (isdefault AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid))
114. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (parent_id = __t14_4.parent_id)
  • Filter: ((NOT isdefault) AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid))
115. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (parent_id = __t13_2.id))
116. 3.000 3.000 ↑ 1.0 1 1,000

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

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

GroupAggregate (cost=1,574.99..1,575.05 rows=1 width=48) (actual time=108.132..117.440 rows=567 loops=1,000)

  • Group Key: __t28.kit_id
118. 3,821.000 112,357.000 ↓ 4,535.0 4,535 1,000

GroupAggregate (cost=1,574.99..1,575.02 rows=1 width=64) (actual time=108.115..112.357 rows=4,535 loops=1,000)

  • Group Key: __t28.kit_id, __t28.root_store_id
119. 426.215 108,536.000 ↓ 8,982.0 8,982 1,000

Sort (cost=1,574.99..1,575.00 rows=1 width=69) (actual time=108.114..108.536 rows=8,982 loops=1,000)

  • Sort Key: __t28.kit_id, __t28.root_store_id
  • Sort Method: quicksort Memory: 1,213kB
120. 0.964 108,109.785 ↓ 10,600.0 10,600 1

Subquery Scan on __t28 (cost=1,574.85..1,574.98 rows=1 width=69) (actual time=108,100.417..108,109.785 rows=10,600 loops=1)

121. 7.797 108,108.821 ↓ 10,600.0 10,600 1

GroupAggregate (cost=1,574.85..1,574.97 rows=1 width=85) (actual time=108,100.416..108,108.821 rows=10,600 loops=1)

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

Sort (cost=1,574.85..1,574.86 rows=1 width=64) (actual time=108,100.402..108,101.024 rows=10,600 loops=1)

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

Nested Loop Left Join (cost=869.14..1,574.84 rows=1 width=64) (actual time=97.476..108,083.457 rows=10,600 loops=1)

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

Nested Loop Left Join (cost=868.59..1,571.09 rows=1 width=174) (actual time=97.463..108,020.192 rows=10,600 loops=1)

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

Nested Loop Left Join (cost=868.03..1,567.42 rows=1 width=171) (actual time=97.443..107,957.943 rows=10,600 loops=1)

  • Join Filter: ((__t33.id = __t30.store_id) AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", __t34.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN (NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t34.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t34.ptype) = 1) THEN ((NOT (__t34.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t34.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t34.shared) ELSE false END AND CASE WHEN (get_bit(B'111001110110010010000100000000010011000111001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::"bit", __t33.ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN (NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t33.shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", __t33.ptype) = 1) THEN ((NOT (__t33.owner_id IS DISTINCT FROM '1c55afe2-bad0-11e9-9109-f8fc0000596f'::uuid)) OR (NOT (__t33.group_id IS DISTINCT FROM '1c54333b-bad0-11e9-9109-f8fc0000596e'::uuid)) OR __t33.shared) ELSE false END)
  • Rows Removed by Join Filter: 46,353
126. 11.778 114.443 ↓ 10,600.0 10,600 1

Nested Loop (cost=867.48..1,563.73 rows=1 width=166) (actual time=5.343..114.443 rows=10,600 loops=1)

127. 1.772 31.115 ↓ 1,325.0 1,325 1

Nested Loop (cost=865.59..1,541.29 rows=1 width=106) (actual time=5.006..31.115 rows=1,325 loops=1)

128. 3.790 13.443 ↓ 1,325.0 1,325 1

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

  • Hash Cond: (__t29.element_id = __t34.feature_id)
129. 4.713 4.824 ↑ 1.0 1,325 1

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

  • Recheck Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
  • Heap Blocks: exact=217
130. 0.111 0.111 ↑ 1.0 1,325 1

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

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

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

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 281kB
132. 3.616 3.951 ↓ 3.6 2,034 1

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

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

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

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
134. 15.900 15.900 ↑ 1.0 1 1,325

Index Scan using good_pkey on good __t35 (cost=0.43..3.43 rows=1 width=32) (actual time=0.012..0.012 rows=1 loops=1,325)

  • Index Cond: (id = __t34.good_id)
  • Filter: (((dtype)::text <> 'Service'::text) AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid))
135. 63.600 71.550 ↓ 8.0 8 1,325

Bitmap Heap Scan on place __t33 (cost=1.89..22.44 rows=1 width=60) (actual time=0.018..0.054 rows=8 loops=1,325)

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

Bitmap Index Scan on i__account_place__evotor_id_new (cost=0.00..1.89 rows=13 width=0) (actual time=0.006..0.006 rows=12 loops=1,325)

  • Index Cond: (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid)
137. 107,823.200 107,823.200 ↓ 5.0 5 10,600

Index Scan using cost_cons_moment on cost __t30 (cost=0.56..3.58 rows=1 width=53) (actual time=9.910..10.172 rows=5 loops=10,600)

  • Index Cond: ((__t34.account_id = account_id) AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::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))
  • Rows Removed by Filter: 13,085
138. 42.400 42.400 ↓ 0.0 0 10,600

Index Scan using i__reserve_momentto on reserve __t31 (cost=0.56..3.56 rows=1 width=51) (actual time=0.004..0.004 rows=0 loops=10,600)

  • Index Cond: ((account_id = __t34.account_id) AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (__t34.id = consignment_id) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: ((motion_id IS NOT NULL) AND isvalid AND (reservetype = 1))
139. 21.200 21.200 ↓ 0.0 0 10,600

Index Scan using i__reserve_momentto on reserve __t32 (cost=0.56..3.56 rows=1 width=51) (actual time=0.002..0.002 rows=0 loops=10,600)

  • Index Cond: ((account_id = __t34.account_id) AND (account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) AND (__t34.id = consignment_id) AND (momentto = 'infinity'::timestamp without time zone))
  • Filter: ((motion_id IS NOT NULL) AND isvalid AND (reservetype = 0))
140. 5.000 5.000 ↑ 1.0 1 1,000

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

  • Index Cond: (id = __t11.uom_id)
  • Filter: ((account_id = '1c53ee3d-bad0-11e9-9109-f8fc0000596d'::uuid) OR (account_id IS NULL))
Planning time : 39.435 ms
Execution time : 133,872.760 ms