explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YBpl

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.164 49,198.903 ↓ 100.0 100 1

Sort (cost=147.82..147.83 rows=1 width=1,096) (actual time=49,198.900..49,198.903 rows=100 loops=1)

  • Sort Key: __t1.id, __t8.archived, (COALESCE(__t8.attributevalues, '{}'::character varying[])), __t7.name
  • Sort Method: quicksort Memory: 90kB
2. 0.190 49,198.739 ↓ 100.0 100 1

Nested Loop Left Join (cost=137.25..147.81 rows=1 width=1,096) (actual time=49,197.631..49,198.739 rows=100 loops=1)

3. 0.019 49,198.449 ↓ 100.0 100 1

Nested Loop Left Join (cost=136.97..145.21 rows=1 width=541) (actual time=49,197.609..49,198.449 rows=100 loops=1)

4. 0.000 49,198.130 ↓ 100.0 100 1

Nested Loop Left Join (cost=136.27..141.81 rows=1 width=541) (actual time=49,197.594..49,198.130 rows=100 loops=1)

5. 0.065 49,197.944 ↓ 100.0 100 1

Nested Loop Left Join (cost=135.84..139.16 rows=1 width=525) (actual time=49,197.583..49,197.944 rows=100 loops=1)

6. 0.009 49,197.579 ↓ 100.0 100 1

Limit (cost=135.14..135.15 rows=1 width=722) (actual time=49,197.558..49,197.579 rows=100 loops=1)

7. 5.834 49,197.570 ↓ 100.0 100 1

Sort (cost=135.14..135.15 rows=1 width=722) (actual time=49,197.557..49,197.570 rows=100 loops=1)

  • Sort Key: __t1.id, __t8.archived, (COALESCE(__t8.attributevalues, '{}'::character varying[])), __t7.name
  • Sort Method: top-N heapsort Memory: 136kB
8. 19.762 49,191.736 ↓ 2,732.0 2,732 1

Nested Loop Left Join (cost=131.26..135.13 rows=1 width=722) (actual time=512.493..49,191.736 rows=2,732 loops=1)

  • Join Filter: (__t7.id = __t26.id)
  • Filter: CASE WHEN (((COALESCE((sum(__t14.stock)), '0'::numeric) - COALESCE((sum(__t21.reservestock)), '0'::numeric)) + COALESCE((sum(__t27.reservestock)), '0'::numeric)) <> '0'::numeric) THEN true ELSE false END
  • Rows Removed by Filter: 10348
9. 563.672 49,106.574 ↓ 13,080.0 13,080 1

Nested Loop Left Join (cost=95.75..99.57 rows=1 width=477) (actual time=439.517..49,106.574 rows=13,080 loops=1)

  • Join Filter: (__t7.id = __t20.id)
  • Rows Removed by Join Filter: 12083400
10. 3,235.094 44,304.982 ↓ 13,080.0 13,080 1

Nested Loop Left Join (cost=61.29..65.07 rows=1 width=445) (actual time=356.957..44,304.982 rows=13,080 loops=1)

  • Join Filter: (__t7.id = __t13.id)
  • Rows Removed by Join Filter: 68603370
11. 11.544 129.488 ↓ 13,080.0 13,080 1

Nested Loop (cost=25.93..29.65 rows=1 width=349) (actual time=0.135..129.488 rows=13,080 loops=1)

12. 6.094 52.544 ↓ 13,080.0 13,080 1

Nested Loop (cost=25.50..29.11 rows=1 width=261) (actual time=0.126..52.544 rows=13,080 loops=1)

13. 3.144 16.848 ↓ 1,558.0 1,558 1

Nested Loop (cost=25.08..28.46 rows=1 width=210) (actual time=0.119..16.848 rows=1,558 loops=1)

14. 1.925 2.028 ↓ 1,668.0 1,668 1

Bitmap Heap Scan on goodattributevalue __t12 (cost=24.65..25.77 rows=1 width=16) (actual time=0.110..2.028 rows=1,668 loops=1)

  • Recheck Cond: ((metadata_id = 'aac95894-ef3c-11e9-0a80-03d30006b414'::uuid) AND (entityvalue_id = '64aec0d3-f184-11e9-0a80-030c0004416a'::uuid))
  • Filter: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
  • Heap Blocks: exact=46
15. 0.003 0.103 ↓ 0.0 0 1

BitmapAnd (cost=24.65..24.65 rows=1 width=0) (actual time=0.103..0.103 rows=0 loops=1)

16. 0.055 0.055 ↓ 5.7 1,809 1

Bitmap Index Scan on i__goodattributevalue__metadata_id (cost=0.00..5.00 rows=317 width=0) (actual time=0.055..0.055 rows=1,809 loops=1)

  • Index Cond: (metadata_id = 'aac95894-ef3c-11e9-0a80-03d30006b414'::uuid)
17. 0.045 0.045 ↓ 1.1 1,668 1

Bitmap Index Scan on goodattributevalue_entity_index (cost=0.00..19.40 rows=1,521 width=0) (actual time=0.045..0.045 rows=1,668 loops=1)

  • Index Cond: (entityvalue_id = '64aec0d3-f184-11e9-0a80-030c0004416a'::uuid)
18. 11.676 11.676 ↑ 1.0 1 1,668

Index Scan using good_pkey on good __t1 (cost=0.43..2.70 rows=1 width=194) (actual time=0.007..0.007 rows=1 loops=1,668)

  • Index Cond: (id = __t12.good_id)
  • Filter: ((NOT COALESCE(archived, false)) AND ((dtype)::text = 'Good'::text) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 0
19. 29.602 29.602 ↓ 8.0 8 1,558

Index Scan using i__feature__parent_id on feature __t8 (cost=0.43..0.64 rows=1 width=83) (actual time=0.005..0.019 rows=8 loops=1,558)

  • Index Cond: (parent_id = __t1.id)
  • Filter: (NOT COALESCE(archived, false))
  • Rows Removed by Filter: 0
20. 65.400 65.400 ↑ 1.0 1 13,080

Index Scan using i_consignment_feature_id on consignment __t7 (cost=0.43..0.53 rows=1 width=104) (actual time=0.004..0.005 rows=1 loops=13,080)

  • Index Cond: (feature_id = __t8.id)
  • Filter: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
21. 37,735.786 40,940.400 ↓ 5,245.0 5,245 13,080

GroupAggregate (cost=35.36..35.39 rows=1 width=112) (actual time=0.028..3.130 rows=5,245 loops=13,080)

  • Group Key: __t13.id
22.          

Initplan (for GroupAggregate)

23. 0.008 0.014 ↑ 1.0 1 1

Aggregate (cost=2.56..2.57 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=1)

24. 0.006 0.006 ↑ 1.0 1 1

Index Scan using i__place__account_id on place __t19 (cost=0.28..2.55 rows=1 width=21) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
  • Filter: ((id = '759ecfe8-8355-11e8-9107-50480019fba7'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 2
25. 2,855.536 3,204.600 ↓ 5,246.0 5,246 13,080

Sort (cost=32.79..32.79 rows=1 width=34) (actual time=0.027..0.245 rows=5,246 loops=13,080)

  • Sort Key: __t13.id
  • Sort Method: quicksort Memory: 760kB
26. 5.011 349.064 ↓ 7,260.0 7,260 1

Nested Loop (cost=26.77..32.78 rows=1 width=34) (actual time=0.206..349.064 rows=7,260 loops=1)

27. 10.108 147.989 ↓ 12,254.0 12,254 1

Nested Loop (cost=26.49..31.99 rows=1 width=50) (actual time=0.125..147.989 rows=12,254 loops=1)

28. 9.138 59.401 ↓ 13,080.0 13,080 1

Nested Loop (cost=25.93..30.68 rows=1 width=16) (actual time=0.109..59.401 rows=13,080 loops=1)

29. 2.145 24.103 ↓ 13,080.0 13,080 1

Nested Loop (cost=25.50..29.72 rows=1 width=16) (actual time=0.105..24.103 rows=13,080 loops=1)

30. 0.393 7.936 ↓ 1,558.0 1,558 1

Nested Loop (cost=25.08..28.46 rows=1 width=32) (actual time=0.102..7.936 rows=1,558 loops=1)

31. 0.777 0.871 ↓ 1,668.0 1,668 1

Bitmap Heap Scan on goodattributevalue __t12_1 (cost=24.65..25.77 rows=1 width=32) (actual time=0.097..0.871 rows=1,668 loops=1)

  • Recheck Cond: ((metadata_id = 'aac95894-ef3c-11e9-0a80-03d30006b414'::uuid) AND (entityvalue_id = '64aec0d3-f184-11e9-0a80-030c0004416a'::uuid))
  • Filter: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
  • Heap Blocks: exact=46
32. 0.003 0.094 ↓ 0.0 0 1

BitmapAnd (cost=24.65..24.65 rows=1 width=0) (actual time=0.094..0.094 rows=0 loops=1)

33. 0.045 0.045 ↓ 5.7 1,809 1

Bitmap Index Scan on i__goodattributevalue__metadata_id (cost=0.00..5.00 rows=317 width=0) (actual time=0.045..0.045 rows=1,809 loops=1)

  • Index Cond: (metadata_id = 'aac95894-ef3c-11e9-0a80-03d30006b414'::uuid)
34. 0.046 0.046 ↓ 1.1 1,668 1

Bitmap Index Scan on goodattributevalue_entity_index (cost=0.00..19.40 rows=1,521 width=0) (actual time=0.046..0.046 rows=1,668 loops=1)

  • Index Cond: (entityvalue_id = '64aec0d3-f184-11e9-0a80-030c0004416a'::uuid)
35. 6.672 6.672 ↑ 1.0 1 1,668

Index Scan using good_pkey on good __t16 (cost=0.43..2.70 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=1,668)

  • Index Cond: (id = __t12_1.good_id)
  • Filter: ((NOT COALESCE(archived, false)) AND ((dtype)::text = 'Good'::text) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 0
36. 14.022 14.022 ↓ 8.0 8 1,558

Index Scan using i__feature__parent_id on feature __t15 (cost=0.43..1.25 rows=1 width=32) (actual time=0.003..0.009 rows=8 loops=1,558)

  • Index Cond: (parent_id = __t16.id)
  • Filter: (NOT COALESCE(archived, false))
  • Rows Removed by Filter: 0
37. 26.160 26.160 ↑ 1.0 1 13,080

Index Scan using i_consignment_feature_id on consignment __t13 (cost=0.43..0.95 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=13,080)

  • Index Cond: (feature_id = __t15.id)
38. 78.480 78.480 ↑ 1.0 1 13,080

Index Scan using cost_cons_moment on cost __t14 (cost=0.56..1.30 rows=1 width=50) (actual time=0.005..0.006 rows=1 loops=13,080)

  • Index Cond: ((account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid) AND (consignment_id = __t13.id))
  • Filter: ((initialcost_id IS NULL) AND (motion_id IS NOT NULL) AND isvalid AND (momentfrom <= '2019-11-06 08:07:35.724'::timestamp without time zone) AND (momentto > '2019-11-06 08:07:35.724'::timestamp without time zone))
  • Rows Removed by Filter: 6
39. 196.064 196.064 ↑ 1.0 1 12,254

Index Scan using place_pkey on place __t17 (cost=0.28..0.79 rows=1 width=16) (actual time=0.016..0.016 rows=1 loops=12,254)

  • Index Cond: (id = __t14.store_id)
  • Filter: ((array_length(regexp_match(((path)::text || (id)::text), $0), 1) > 0) AND (CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) ELSE false END OR (id IS NULL)))
  • Rows Removed by Filter: 0
40. 3,675.473 4,237.920 ↓ 924.0 924 13,080

GroupAggregate (cost=34.46..34.48 rows=1 width=48) (actual time=0.007..0.324 rows=924 loops=13,080)

  • Group Key: __t20.id
41.          

Initplan (for GroupAggregate)

42. 0.003 0.007 ↑ 1.0 1 1

Aggregate (cost=2.56..2.57 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=1)

43. 0.004 0.004 ↑ 1.0 1 1

Index Scan using i__place__account_id on place __t25 (cost=0.28..2.55 rows=1 width=21) (actual time=0.003..0.004 rows=1 loops=1)

  • Index Cond: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
  • Filter: ((id = '759ecfe8-8355-11e8-9107-50480019fba7'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 2
44. 480.622 562.440 ↓ 924.0 924 13,080

Sort (cost=31.89..31.89 rows=1 width=19) (actual time=0.006..0.043 rows=924 loops=13,080)

  • Sort Key: __t20.id
  • Sort Method: quicksort Memory: 99kB
45. 0.322 81.818 ↓ 959.0 959 1

Nested Loop (cost=26.77..31.88 rows=1 width=19) (actual time=0.305..81.818 rows=959 loops=1)

46. 6.988 60.398 ↓ 959.0 959 1

Nested Loop (cost=26.49..30.35 rows=1 width=35) (actual time=0.253..60.398 rows=959 loops=1)

47. 0.000 40.330 ↓ 13,080.0 13,080 1

Nested Loop (cost=25.93..29.65 rows=1 width=16) (actual time=0.113..40.330 rows=13,080 loops=1)

48. 1.571 15.974 ↓ 13,080.0 13,080 1

Nested Loop (cost=25.50..29.11 rows=1 width=16) (actual time=0.110..15.974 rows=13,080 loops=1)

49. 0.000 5.055 ↓ 1,558.0 1,558 1

Nested Loop (cost=25.08..28.46 rows=1 width=32) (actual time=0.106..5.055 rows=1,558 loops=1)

50. 0.413 0.507 ↓ 1,668.0 1,668 1

Bitmap Heap Scan on goodattributevalue __t12_2 (cost=24.65..25.77 rows=1 width=32) (actual time=0.099..0.507 rows=1,668 loops=1)

  • Recheck Cond: ((metadata_id = 'aac95894-ef3c-11e9-0a80-03d30006b414'::uuid) AND (entityvalue_id = '64aec0d3-f184-11e9-0a80-030c0004416a'::uuid))
  • Filter: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
  • Heap Blocks: exact=46
51. 0.004 0.094 ↓ 0.0 0 1

BitmapAnd (cost=24.65..24.65 rows=1 width=0) (actual time=0.094..0.094 rows=0 loops=1)

52. 0.049 0.049 ↓ 5.7 1,809 1

Bitmap Index Scan on i__goodattributevalue__metadata_id (cost=0.00..5.00 rows=317 width=0) (actual time=0.049..0.049 rows=1,809 loops=1)

  • Index Cond: (metadata_id = 'aac95894-ef3c-11e9-0a80-03d30006b414'::uuid)
53. 0.041 0.041 ↓ 1.1 1,668 1

Bitmap Index Scan on goodattributevalue_entity_index (cost=0.00..19.40 rows=1,521 width=0) (actual time=0.041..0.041 rows=1,668 loops=1)

  • Index Cond: (entityvalue_id = '64aec0d3-f184-11e9-0a80-030c0004416a'::uuid)
54. 5.004 5.004 ↑ 1.0 1 1,668

Index Scan using good_pkey on good __t23 (cost=0.43..2.70 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1,668)

  • Index Cond: (id = __t12_2.good_id)
  • Filter: ((NOT COALESCE(archived, false)) AND ((dtype)::text = 'Good'::text) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 0
55. 9.348 9.348 ↓ 8.0 8 1,558

Index Scan using i__feature__parent_id on feature __t22 (cost=0.43..0.64 rows=1 width=32) (actual time=0.002..0.006 rows=8 loops=1,558)

  • Index Cond: (parent_id = __t23.id)
  • Filter: (NOT COALESCE(archived, false))
  • Rows Removed by Filter: 0
56. 26.160 26.160 ↑ 1.0 1 13,080

Index Scan using i_consignment_feature_id on consignment __t20 (cost=0.43..0.53 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=13,080)

  • Index Cond: (feature_id = __t22.id)
57. 13.080 13.080 ↓ 0.0 0 13,080

Index Scan using reserve_isvalid_cons_moment on reserve __t21 (cost=0.56..0.69 rows=1 width=35) (actual time=0.001..0.001 rows=0 loops=13,080)

  • Index Cond: ((account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid) AND (isvalid = true) AND (consignment_id = __t20.id))
  • Filter: (isvalid AND (momentfrom <= '2019-11-06 08:07:35.724'::timestamp without time zone) AND (momentto > '2019-11-06 08:07:35.724'::timestamp without time zone) AND (reservetype = 1))
  • Rows Removed by Filter: 0
58. 21.098 21.098 ↑ 1.0 1 959

Index Scan using place_pkey on place __t24 (cost=0.28..1.52 rows=1 width=16) (actual time=0.022..0.022 rows=1 loops=959)

  • Index Cond: (id = __t21.store_id)
  • Filter: ((array_length(regexp_match(((path)::text || (id)::text), $1), 1) > 0) AND (CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) ELSE false END OR (id IS NULL)))
59. 0.000 65.400 ↓ 0.0 0 13,080

GroupAggregate (cost=35.51..35.53 rows=1 width=48) (actual time=0.005..0.005 rows=0 loops=13,080)

  • Group Key: __t26.id
60.          

Initplan (for GroupAggregate)

61. 0.018 0.044 ↑ 1.0 1 1

Aggregate (cost=2.56..2.57 rows=1 width=32) (actual time=0.044..0.044 rows=1 loops=1)

62. 0.026 0.026 ↑ 1.0 1 1

Index Scan using i__place__account_id on place __t31 (cost=0.28..2.55 rows=1 width=21) (actual time=0.024..0.026 rows=1 loops=1)

  • Index Cond: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
  • Filter: ((id = '759ecfe8-8355-11e8-9107-50480019fba7'::uuid) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 2
63. 0.000 65.400 ↓ 0.0 0 13,080

Sort (cost=32.93..32.94 rows=1 width=19) (actual time=0.005..0.005 rows=0 loops=13,080)

  • Sort Key: __t26.id
  • Sort Method: quicksort Memory: 25kB
64. 0.176 67.071 ↓ 0.0 0 1

Nested Loop (cost=26.77..32.92 rows=1 width=19) (actual time=67.071..67.071 rows=0 loops=1)

65. 8.237 66.253 ↓ 321.0 321 1

Nested Loop (cost=26.49..30.35 rows=1 width=35) (actual time=0.850..66.253 rows=321 loops=1)

66. 0.755 44.936 ↓ 13,080.0 13,080 1

Nested Loop (cost=25.93..29.65 rows=1 width=16) (actual time=0.252..44.936 rows=13,080 loops=1)

67. 1.365 18.021 ↓ 13,080.0 13,080 1

Nested Loop (cost=25.50..29.11 rows=1 width=16) (actual time=0.231..18.021 rows=13,080 loops=1)

68. 0.061 5.750 ↓ 1,558.0 1,558 1

Nested Loop (cost=25.08..28.46 rows=1 width=32) (actual time=0.215..5.750 rows=1,558 loops=1)

69. 0.509 0.685 ↓ 1,668.0 1,668 1

Bitmap Heap Scan on goodattributevalue __t12_3 (cost=24.65..25.77 rows=1 width=32) (actual time=0.188..0.685 rows=1,668 loops=1)

  • Recheck Cond: ((metadata_id = 'aac95894-ef3c-11e9-0a80-03d30006b414'::uuid) AND (entityvalue_id = '64aec0d3-f184-11e9-0a80-030c0004416a'::uuid))
  • Filter: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
  • Heap Blocks: exact=46
70. 0.007 0.176 ↓ 0.0 0 1

BitmapAnd (cost=24.65..24.65 rows=1 width=0) (actual time=0.176..0.176 rows=0 loops=1)

71. 0.094 0.094 ↓ 5.7 1,809 1

Bitmap Index Scan on i__goodattributevalue__metadata_id (cost=0.00..5.00 rows=317 width=0) (actual time=0.094..0.094 rows=1,809 loops=1)

  • Index Cond: (metadata_id = 'aac95894-ef3c-11e9-0a80-03d30006b414'::uuid)
72. 0.075 0.075 ↓ 1.1 1,668 1

Bitmap Index Scan on goodattributevalue_entity_index (cost=0.00..19.40 rows=1,521 width=0) (actual time=0.075..0.075 rows=1,668 loops=1)

  • Index Cond: (entityvalue_id = '64aec0d3-f184-11e9-0a80-030c0004416a'::uuid)
73. 5.004 5.004 ↑ 1.0 1 1,668

Index Scan using good_pkey on good __t29 (cost=0.43..2.70 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1,668)

  • Index Cond: (id = __t12_3.good_id)
  • Filter: ((NOT COALESCE(archived, false)) AND ((dtype)::text = 'Good'::text) AND CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) ELSE false END)
  • Rows Removed by Filter: 0
74. 10.906 10.906 ↓ 8.0 8 1,558

Index Scan using i__feature__parent_id on feature __t28 (cost=0.43..0.64 rows=1 width=32) (actual time=0.003..0.007 rows=8 loops=1,558)

  • Index Cond: (parent_id = __t29.id)
  • Filter: (NOT COALESCE(archived, false))
  • Rows Removed by Filter: 0
75. 26.160 26.160 ↑ 1.0 1 13,080

Index Scan using i_consignment_feature_id on consignment __t26 (cost=0.43..0.53 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=13,080)

  • Index Cond: (feature_id = __t28.id)
76. 13.080 13.080 ↓ 0.0 0 13,080

Index Scan using reserve_isvalid_cons_moment on reserve __t27 (cost=0.56..0.69 rows=1 width=35) (actual time=0.001..0.001 rows=0 loops=13,080)

  • Index Cond: ((account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid) AND (isvalid = true) AND (consignment_id = __t26.id))
  • Filter: (isvalid AND (momentfrom <= '2019-11-06 08:07:35.724'::timestamp without time zone) AND (momentto > '2019-11-06 08:07:35.724'::timestamp without time zone) AND (reservetype = 0))
  • Rows Removed by Filter: 0
77. 0.642 0.642 ↓ 0.0 0 321

Index Scan using place_pkey on place __t30 (cost=0.28..2.56 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=321)

  • Index Cond: (id = __t27.store_id)
  • Filter: ((array_length(regexp_match(((path)::text || (id)::text), $2), 1) > 0) AND (CASE WHEN (get_bit(B'111111111111111111111111111111110011111111011111111000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011'::"bit", ptype) = 1) THEN true WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN (NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid))) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) WHEN (get_bit(B'000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::"bit", ptype) = 1) THEN ((NOT (owner_id IS DISTINCT FROM '75869cea-8355-11e8-9109-f8fc0000cb5c'::uuid)) OR (NOT (group_id IS DISTINCT FROM '758559a8-8355-11e8-9109-f8fc0000cb5b'::uuid)) OR shared) ELSE false END OR (id IS NULL)))
  • Rows Removed by Filter: 1
78. 0.043 0.300 ↑ 1.0 1 100

Nested Loop Left Join (cost=0.70..3.99 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=100)

79. 0.200 0.200 ↑ 1.0 1 100

Index Scan using u__price__parent_id__pricetype_id on price __t3 (cost=0.43..2.65 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: ((parent_id = __t8.id) AND (pricetype_id = '75a24418-8355-11e8-9107-50480019fbad'::uuid))
  • Filter: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
80. 0.057 0.057 ↑ 1.0 1 57

Index Scan using currency_pkey on currency __t4 (cost=0.28..0.81 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=57)

  • Index Cond: (id = __t3.currency_id)
  • Filter: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
81. 0.200 0.200 ↑ 1.0 1 100

Index Scan using u__feature__default on feature __t32 (cost=0.43..2.65 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: (parent_id = __t1.id)
  • Filter: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
82. 0.000 0.300 ↑ 1.0 1 100

Nested Loop Left Join (cost=0.70..3.39 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=100)

83. 0.200 0.200 ↑ 1.0 1 100

Index Scan using u__price__parent_id__pricetype_id on price __t5 (cost=0.43..2.05 rows=1 width=40) (actual time=0.001..0.002 rows=1 loops=100)

  • Index Cond: ((parent_id = __t32.id) AND (pricetype_id = '75a24418-8355-11e8-9107-50480019fbad'::uuid))
  • Filter: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
84. 0.100 0.100 ↑ 1.0 1 100

Index Scan using currency_pkey on currency __t6 (cost=0.28..0.81 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=100)

  • Index Cond: (id = __t5.currency_id)
  • Filter: (account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid)
85. 0.100 0.100 ↑ 1.0 1 100

Index Scan using uom_pkey on uom __t2 (cost=0.28..2.50 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=100)

  • Index Cond: (id = __t1.uom_id)
  • Filter: ((account_id = '758525c5-8355-11e8-9109-f8fc0000cb5a'::uuid) OR (account_id IS NULL))
Planning time : 16.610 ms
Execution time : 49,199.957 ms