explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ToYd

Settings
# exclusive inclusive rows x rows loops node
1. 2.050 95,542.960 ↓ 227.0 681 1

Sort (cost=85,765.26..85,765.26 rows=3 width=342) (actual time=95,542.921..95,542.960 rows=681 loops=1)

  • Sort Key: "*SELECT* 1".sdbl_sfa_3_, "*SELECT* 1".sdbl_sfa_4_, "*SELECT* 1".sdbl_sfa_5rref, "*SELECT* 1".sdbl_sfa_6_, "*SELECT* 1".sdbl_sfa_7rref
  • Sort Method: quicksort Memory: 245kB
2. 0.045 95,540.910 ↓ 227.0 681 1

Append (cost=42,882.01..85,765.15 rows=3 width=342) (actual time=47,464.273..95,540.910 rows=681 loops=1)

3. 0.048 47,464.739 ↓ 429.0 429 1

Subquery Scan on *SELECT* 1 (cost=42,882.01..42,882.04 rows=1 width=334) (actual time=47,464.273..47,464.739 rows=429 loops=1)

4. 0.406 47,464.691 ↓ 429.0 429 1

GroupAggregate (cost=42,882.01..42,882.03 rows=1 width=335) (actual time=47,464.271..47,464.691 rows=429 loops=1)

  • Group Key: t12._owneridrref, (CASE WHEN (NOT t24._folder) THEN true WHEN t24._folder THEN false ELSE NULL::boolean END), t25._idrref, t12._fld1777rref, t24._idrref
5. 0.314 47,464.285 ↓ 429.0 429 1

Sort (cost=42,882.01..42,882.01 rows=1 width=196) (actual time=47,464.264..47,464.285 rows=429 loops=1)

  • Sort Key: t12._owneridrref, (CASE WHEN (NOT t24._folder) THEN true WHEN t24._folder THEN false ELSE NULL::boolean END), t25._idrref, t12._fld1777rref
  • Sort Method: quicksort Memory: 138kB
6. 0.184 47,463.971 ↓ 429.0 429 1

Nested Loop (cost=42,826.23..42,881.95 rows=1 width=196) (actual time=47,279.804..47,463.971 rows=429 loops=1)

  • Join Filter: (t12._owneridrref = t26._reffieldrref)
7. 0.137 47,462.071 ↓ 429.0 429 1

Nested Loop Left Join (cost=42,826.07..42,881.74 rows=1 width=212) (actual time=47,279.774..47,462.071 rows=429 loops=1)

8. 0.223 47,461.505 ↓ 429.0 429 1

Nested Loop (cost=42,826.01..42,879.39 rows=1 width=155) (actual time=47,279.766..47,461.505 rows=429 loops=1)

  • Join Filter: (t12._owneridrref = t24._idrref)
9. 97.961 47,459.566 ↓ 429.0 429 1

Nested Loop (cost=42,825.85..42,878.03 rows=1 width=97) (actual time=47,279.753..47,459.566 rows=429 loops=1)

  • Join Filter: ((t12._owneridrref = t23._q_000_f_001rref) AND (t12._fld1777rref = t23._q_000_f_002rref))
  • Rows Removed by Join Filter: 1,115,049
10. 8.771 47,288.057 ↓ 681.0 681 1

GroupAggregate (cost=42,825.85..42,825.98 rows=1 width=166) (actual time=47,279.120..47,288.057 rows=681 loops=1)

  • Group Key: t12._owneridrref, t17._lineno2094, t22._idrref, t12._fld1777rref
11. 1.387 47,279.286 ↓ 1,439.0 1,439 1

Sort (cost=42,825.85..42,825.85 rows=1 width=175) (actual time=47,279.091..47,279.286 rows=1,439 loops=1)

  • Sort Key: t12._owneridrref, t17._lineno2094, t22._idrref, t12._fld1777rref
  • Sort Method: quicksort Memory: 431kB
12. 0.894 47,277.899 ↓ 1,439.0 1,439 1

Nested Loop Left Join (cost=42,809.25..42,825.80 rows=1 width=175) (actual time=47,260.751..47,277.899 rows=1,439 loops=1)

13. 0.591 47,274.127 ↓ 1,439.0 1,439 1

Nested Loop (cost=42,809.08..42,825.48 rows=1 width=118) (actual time=47,260.739..47,274.127 rows=1,439 loops=1)

14. 5.319 47,266.341 ↓ 1,439.0 1,439 1

Nested Loop (cost=42,809.08..42,823.66 rows=1 width=105) (actual time=47,260.732..47,266.341 rows=1,439 loops=1)

  • Join Filter: ((t9._q_001_f_002 >= date_trunc('day'::text, ('2020-06-30 23:59:59'::timestamp without time zone + ((((((- t11._fld2095))::integer)::numeric)::text || 'DAY'::text))::interval))) AND (t9._q_001_f_002 <= (((((('2000-01-01 00:00:00'::timestamp without time zone + ((((((((date_part('YEAR'::text, ('2020-06-30 23:59:59'::timestamp without time zone + ((((((- t11._fld2096))::integer)::numeric)::text || 'DAY'::text))::interval)))::integer)::numeric - '2000'::numeric))::integer)::numeric)::text || 'YEAR'::text))::interval) + ((((((((date_part('MONTH'::text, ('2020-06-30 23:59:59'::timestamp without time zone + ((((((- t11._fld2096))::integer)::numeric)::text || 'DAY'::text))::interval)))::integer)::numeric - '1'::numeric))::integer)::numeric)::text || 'MONTH'::text))::interval) + ((((((((date_part('DAY'::text, ('2020-06-30 23:59:59'::timestamp without time zone + ((((((- t11._fld2096))::integer)::numeric)::text || 'DAY'::text))::interval)))::integer)::numeric - '1'::numeric))::integer)::numeric)::text || 'DAY'::text))::interval) + ('23HOUR'::cstring)::interval) + ('59MINUTE'::cstring)::interval) + ('59SECOND'::cstring)::interval)))
15. 0.001 0.041 ↑ 1.0 1 1

Nested Loop (cost=0.22..5.41 rows=1 width=19) (actual time=0.037..0.041 rows=1 loops=1)

16. 0.003 0.029 ↑ 1.0 1 1

Nested Loop (cost=0.22..3.58 rows=1 width=11) (actual time=0.028..0.029 rows=1 loops=1)

17. 0.005 0.015 ↑ 1.0 1 1

GroupAggregate (cost=0.11..1.24 rows=1 width=28) (actual time=0.014..0.015 rows=1 loops=1)

  • Group Key: t20._fld16635rref
18. 0.010 0.010 ↓ 2.0 2 1

Index Only Scan using _inforg16634_bydims_rt on _inforg16634 t20 (cost=0.11..1.23 rows=1 width=28) (actual time=0.010..0.010 rows=2 loops=1)

  • Index Cond: ((_fld16635rref = '\\xaed50022152f41cb11ded3452bb9e1e0'::bytea) AND (_period <= '2020-06-30 23:59:59'::timestamp without time zone))
  • Heap Fetches: 0
19. 0.011 0.011 ↑ 1.0 1 1

Index Scan using _inforg16634_bydims_rt on _inforg16634 t21 (cost=0.11..2.33 rows=1 width=39) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: ((_fld16635rref = t20._fld16635rref) AND (_period = (max(t20._period))))
20. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on _reference126_vt2093 t11 (cost=0.00..1.81 rows=1 width=8) (actual time=0.008..0.011 rows=1 loops=1)

  • Filter: (_reference126_idrref = '\\x80c7002590fc813711e560b00591b683'::bytea)
  • Rows Removed by Filter: 73
21. 0.319 47,260.981 ↓ 1,439.0 1,439 1

Hash Right Join (cost=42,808.86..42,818.16 rows=1 width=94) (actual time=47,260.661..47,260.981 rows=1,439 loops=1)

  • Hash Cond: (t16._fld16635rref = t12._fld1745rref)
22. 0.008 0.984 ↑ 1.0 4 1

Nested Loop (cost=73.52..82.81 rows=4 width=31) (actual time=0.970..0.984 rows=4 loops=1)

23. 0.550 0.960 ↑ 1.0 4 1

HashAggregate (cost=73.41..73.45 rows=4 width=28) (actual time=0.958..0.960 rows=4 loops=1)

  • Group Key: t15._fld16635rref
24. 0.410 0.410 ↑ 1.0 3,375 1

Seq Scan on _inforg16634 t15 (cost=0.00..66.65 rows=3,378 width=28) (actual time=0.011..0.410 rows=3,375 loops=1)

  • Filter: (_period <= '2020-06-30 23:59:59'::timestamp without time zone)
  • Rows Removed by Filter: 48
25. 0.016 0.016 ↑ 1.0 1 4

Index Scan using _inforg16634_bydims_rt on _inforg16634 t16 (cost=0.11..2.33 rows=1 width=39) (actual time=0.004..0.004 rows=1 loops=4)

  • Index Cond: ((_fld16635rref = t15._fld16635rref) AND (_period = (max(t15._period))))
26. 0.720 47,259.678 ↓ 1,439.0 1,439 1

Hash (cost=42,735.33..42,735.33 rows=1 width=103) (actual time=47,259.678..47,259.678 rows=1,439 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 162kB
27. 2.479 47,258.958 ↓ 1,439.0 1,439 1

Nested Loop Left Join (cost=42,732.98..42,735.33 rows=1 width=103) (actual time=30,117.296..47,258.958 rows=1,439 loops=1)

28. 15,899.176 47,250.723 ↓ 1,439.0 1,439 1

GroupAggregate (cost=42,732.82..42,732.93 rows=1 width=147) (actual time=30,117.246..47,250.723 rows=1,439 loops=1)

  • Group Key: t9._q_001_f_002, t9._q_001_f_003tref, t5._fld18892_rtref, t5._fld18892_type, t5._fld18891rref, t5._fld18892_rrref, t9._q_001_f_003rref, (sum(t5._fld18895))
  • Filter: (CASE WHEN (sum((t10._q_001_f_005 * CASE WHEN ((t10._q_001_f_004_00 = '0'::numeric) AND (t10._q_001_f_005 > '0'::numeric) AND ((t10._q_001_f_003tref <> t9._q_001_f_003tref) OR (t10._q_001_f_003rref <> t9._q_001_f_003rref))) THEN '1'::numeric WHEN ((t10._q_001_f_004_00 <> '0'::numeric) AND (t10._q_001_f_005 < '0'::numeric) AND ((t10._q_001_f_003tref <> t9._q_001_f_003tref) OR (t10._q_001_f_003rref <> t9._q_001_f_003rref))) THEN '-1'::numeric ELSE '0'::numeric END)) > (sum(t5._fld18895))) THEN '0'::numeric ELSE CASE WHEN (sum((t10._q_001_f_005 * CASE WHEN ((t10._q_001_f_004_00 = '0'::numeric) AND (t10._q_001_f_005 > '0'::numeric)) THEN '1'::numeric WHEN ((t10._q_001_f_004_00 <> '0'::numeric) AND (t10._q_001_f_005 < '0'::numeric)) THEN '-1'::numeric ELSE '0'::numeric END)) > (sum(t5._fld18895))) THEN (sum(CASE WHEN ((t9._q_001_f_003tref = t10._q_001_f_003tref) AND (t9._q_001_f_003rref = t10._q_001_f_003rref)) THEN (sum(t5._fld18895)) ELSE '0'::numeric END) - sum((t10._q_001_f_005 * CASE WHEN ((t10._q_001_f_004_00 = '0'::numeric) AND (t10._q_001_f_005 > '0'::numeric) AND ((t9._q_001_f_003tref <> t10._q_001_f_003tref) OR (t9._q_001_f_003rref <> t10._q_001_f_003rref))) THEN '1'::numeric WHEN ((t10._q_001_f_004_00 <> '0'::numeric) AND (t10._q_001_f_005 < '0'::numeric) AND ((t9._q_001_f_003tref <> t10._q_001_f_003tref) OR (t9._q_001_f_003rref <> t10._q_001_f_003rref))) THEN '-1'::numeric ELSE '0'::numeric END))) ELSE sum((t9._q_001_f_005 * CASE WHEN ((t9._q_001_f_004_00 = '0'::numeric) AND (t9._q_001_f_005 > '0'::numeric) AND (t9._q_001_f_003tref = t10._q_001_f_003tref) AND (t9._q_001_f_003rref = t10._q_001_f_003rref)) THEN '1'::numeric WHEN ((t9._q_001_f_004_00 <> '0'::numeric) AND (t9._q_001_f_005 < '0'::numeric) AND (t9._q_001_f_003tref = t10._q_001_f_003tref) AND (t9._q_001_f_003rref = t10._q_001_f_003rref)) THEN '-1'::numeric ELSE '0'::numeric END)) END END > '0'::numeric)
  • Rows Removed by Filter: 47,266
29. 23,535.922 31,351.547 ↓ 10,353,584.0 10,353,584 1

Sort (cost=42,732.82..42,732.82 rows=1 width=157) (actual time=29,754.029..31,351.547 rows=10,353,584 loops=1)

  • Sort Key: t9._q_001_f_002, t9._q_001_f_003tref, t5._fld18892_rtref, t5._fld18892_type, t5._fld18891rref, t5._fld18892_rrref, t9._q_001_f_003rref, (sum(t5._fld18895))
  • Sort Method: external sort Disk: 1,463,264kB
30. 7,298.432 7,815.625 ↓ 10,353,584.0 10,353,584 1

Hash Right Join (cost=22,851.20..42,732.71 rows=1 width=157) (actual time=293.604..7,815.625 rows=10,353,584 loops=1)

  • Hash Cond: ((t10._q_001_f_000rref = t9._q_001_f_000rref) AND (t10._q_001_f_001_type = t9._q_001_f_001_type) AND (t10._q_001_f_001_rtref = t9._q_001_f_001_rtref) AND (t10._q_001_f_001_rrref = t9._q_001_f_001_rrref))
  • Join Filter: ((t10._q_001_f_002 > t9._q_001_f_002) OR ((t10._q_001_f_002 = t9._q_001_f_002) AND ((t10._q_001_f_003tref > t9._q_001_f_003tref) OR ((t10._q_001_f_003tref = t9._q_001_f_003tref) AND (t10._q_001_f_003rref >= t9._q_001_f_003rref)))))
  • Rows Removed by Join Filter: 10,304,879
31. 223.623 223.623 ↑ 1.0 316,644 1

Seq Scan on tt3 t10 (cost=0.00..17,976.90 rows=316,851 width=81) (actual time=0.019..223.623 rows=316,644 loops=1)

  • Filter: ((_q_001_f_002 <= '2020-06-30 23:59:59'::timestamp without time zone) AND (((_q_001_f_004_00 = '0'::numeric) AND (_q_001_f_005 > '0'::numeric)) OR ((_q_001_f_004_00 <> '0'::numeric) AND (_q_001_f_005 < '0'::numeric))))
  • Rows Removed by Filter: 284,483
32. 22.464 293.570 ↓ 48,705.0 48,705 1

Hash (cost=22,851.19..22,851.19 rows=1 width=166) (actual time=293.570..293.570 rows=48,705 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 8,532kB
33. 60.944 271.106 ↓ 48,705.0 48,705 1

Hash Join (cost=3,543.51..22,851.19 rows=1 width=166) (actual time=25.572..271.106 rows=48,705 loops=1)

  • Hash Cond: ((t9._q_001_f_000rref = t5._fld18891rref) AND (t9._q_001_f_001_type = t5._fld18892_type) AND (t9._q_001_f_001_rtref = t5._fld18892_rtref) AND (t9._q_001_f_001_rrref = t5._fld18892_rrref))
34. 184.646 184.646 ↑ 1.0 316,644 1

Seq Scan on tt3 t9 (cost=0.00..17,976.90 rows=316,851 width=81) (actual time=0.037..184.646 rows=316,644 loops=1)

  • Filter: ((_q_001_f_002 <= '2020-06-30 23:59:59'::timestamp without time zone) AND (((_q_001_f_004_00 = '0'::numeric) AND (_q_001_f_005 > '0'::numeric)) OR ((_q_001_f_004_00 <> '0'::numeric) AND (_q_001_f_005 < '0'::numeric))))
  • Rows Removed by Filter: 284,483
35. 0.243 25.516 ↓ 41.5 705 1

Hash (cost=3,543.27..3,543.27 rows=17 width=85) (actual time=25.516..25.516 rows=705 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 64kB
36. 1.640 25.273 ↓ 41.5 705 1

GroupAggregate (cost=0.66..3,543.10 rows=17 width=85) (actual time=0.207..25.273 rows=705 loops=1)

  • Group Key: t5._fld18891rref, t5._fld18892_type, t5._fld18892_rtref, t5._fld18892_rrref
  • Filter: ((sum(t5._fld18895) <> '0'::numeric) AND (sum(t5._fld18895) > '0'::numeric))
  • Rows Removed by Filter: 966
37. 1.326 23.633 ↓ 32.8 1,671 1

Nested Loop (cost=0.66..3,541.98 rows=51 width=60) (actual time=0.120..23.633 rows=1,671 loops=1)

38. 0.000 17.102 ↓ 15.6 1,735 1

Nested Loop (cost=0.50..3,505.11 rows=111 width=97) (actual time=0.108..17.102 rows=1,735 loops=1)

39. 0.401 11.256 ↓ 2.2 3,077 1

Nested Loop (cost=0.33..3,234.40 rows=1,428 width=80) (actual time=0.027..11.256 rows=3,077 loops=1)

40. 1.534 1.534 ↓ 1.7 3,107 1

Index Scan using _accumrg18897_bydims_trrrrn on _accumrgt18897 t5 (cost=0.17..841.59 rows=1,843 width=60) (actual time=0.013..1.534 rows=3,107 loops=1)

  • Index Cond: (_period = '2020-07-01 00:00:00'::timestamp without time zone)
  • Filter: ((_fld18895 <> '0'::numeric) AND (_fld18895 <> '0'::numeric))
  • Rows Removed by Filter: 18
41. 9.321 9.321 ↑ 1.0 1 3,107

Index Scan using _reference72_pkey on _reference72 t6 (cost=0.17..1.30 rows=1 width=40) (actual time=0.003..0.003 rows=1 loops=3,107)

  • Index Cond: (_idrref = t5._fld18891rref)
  • Filter: ((NOT _fld27229) AND (_fld1747rref <> '\\x80be0026554da21811e35bd742084a77'::bytea) AND (_description <> 'Премия'::mvarchar))
  • Rows Removed by Filter: 0
42. 6.154 6.154 ↑ 1.0 1 3,077

Index Only Scan using tmpind_1 on tt4 t8 (cost=0.16..0.19 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=3,077)

  • Index Cond: (_reffieldrref = t6._owneridrref)
  • Heap Fetches: 1,735
43. 5.205 5.205 ↑ 1.0 1 1,735

Index Scan using _reference112_pkey on _reference112 t7 (cost=0.17..0.33 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=1,735)

  • Index Cond: (_idrref = t6._owneridrref)
  • Filter: ((_fld26316rref = ANY ('{"\\\\xb7dcf2b4ca2ca8dd40078792a5d5eb2d","\\\\xa521826e890126e9434536bd7c0cc90f"}'::bytea[])) AND (_fld1961rref <> ALL ('{"\\\\x80ff002590fc813711e6ad7c7634de81","\\\\x84f908002735c70211e16e443036d4be","\\\\x80ff002590fc813711e6afd4e0ec463b","\\\\x80ff002590fc813711e6a72606095ea5","\\\\x80ff002590fc813711e6a72660881bf6","\\\\x80ff002590fc813711e6afd552c21525","\\\\x80ff002590fc813711e6a727895fa037","\\\\x80ff002590fc813711e6a7255c4cb91d","\\\\x80ff002590fc813711e6a7263bba535d","\\\\x80ff002590fc813711e6a72691bd9c37","\\\\xaedd001e0b28018b11df1c7c4af2d5f0","\\\\xbd85f50ca933a6c44cd335ea2f9d3cf8","\\\\xb6ab0026554da21211df84070e90dc23","\\\\x80d2001e6706a2b111e47ea256a87259","\\\\x811a002590fc813711e76c45392151a4","\\\\x8125002590fc813711e9083ddd1e0b2e","\\\\xbebc0026554da21811e09e52e0e27896","\\\\x80c70026554da21811e421c6c65df82a","\\\\x80cb002590fc813711e56e44b95ebb90","\\\\x80d3001e6706a2b111e4a13015148989","\\\\xa7d68ead8dba74104f6072ed27551d2b","\\\\x87de0026554da21811e103c22fce876e","\\\\x8f920026554da21211dfa03a8b5713cd","\\\\xab9a0026554da21811e0a7b2c52c709e","\\\\x9fe80026554da21811e0971457114a40","\\\\x8130002590fc813711e9d52c49f69afc","\\\\x881f47ef298a0b3a4d07870318101659","\\\\x80fb001e6706a2b111e5470f79e59000","\\\\x80d2001e6706a2b111e49bb2b1874c1f","\\\\x8124002590fc813711e864b79dc1079b"}'::bytea[])))
  • Rows Removed by Filter: 0
44. 5.756 5.756 ↑ 1.0 1 1,439

Index Scan using _reference72_pkey on _reference72 t12 (cost=0.17..2.38 rows=1 width=83) (actual time=0.004..0.004 rows=1 loops=1,439)

  • Index Cond: (_idrref = t5._fld18891rref)
45. 7.195 7.195 ↑ 1.0 1 1,439

Seq Scan on _reference126_vt2093 t17 (cost=0.00..1.81 rows=1 width=13) (actual time=0.002..0.005 rows=1 loops=1,439)

  • Filter: (_reference126_idrref = '\\x80c7002590fc813711e560b00591b683'::bytea)
  • Rows Removed by Filter: 73
46. 2.878 2.878 ↑ 1.0 1 1,439

Index Scan using _reference112_pkey on _reference112 t22 (cost=0.17..0.32 rows=1 width=57) (actual time=0.002..0.002 rows=1 loops=1,439)

  • Index Cond: (_idrref = t12._owneridrref)
47. 73.548 73.548 ↑ 1.0 1,638 681

Seq Scan on tt2 t23 (cost=0.00..32.38 rows=1,638 width=42) (actual time=0.002..0.108 rows=1,638 loops=681)

48. 1.716 1.716 ↑ 1.0 1 429

Index Scan using _reference112_pkey on _reference112 t24 (cost=0.17..1.35 rows=1 width=58) (actual time=0.004..0.004 rows=1 loops=429)

  • Index Cond: (_idrref = t23._q_000_f_001rref)
  • Filter: ((_fld26316rref = ANY ('{"\\\\xb7dcf2b4ca2ca8dd40078792a5d5eb2d","\\\\xa521826e890126e9434536bd7c0cc90f"}'::bytea[])) AND (_fld1961rref <> ALL ('{"\\\\x80ff002590fc813711e6ad7c7634de81","\\\\x84f908002735c70211e16e443036d4be","\\\\x80ff002590fc813711e6afd4e0ec463b","\\\\x80ff002590fc813711e6a72606095ea5","\\\\x80ff002590fc813711e6a72660881bf6","\\\\x80ff002590fc813711e6afd552c21525","\\\\x80ff002590fc813711e6a727895fa037","\\\\x80ff002590fc813711e6a7255c4cb91d","\\\\x80ff002590fc813711e6a7263bba535d","\\\\x80ff002590fc813711e6a72691bd9c37","\\\\xaedd001e0b28018b11df1c7c4af2d5f0","\\\\xbd85f50ca933a6c44cd335ea2f9d3cf8","\\\\xb6ab0026554da21211df84070e90dc23","\\\\x80d2001e6706a2b111e47ea256a87259","\\\\x811a002590fc813711e76c45392151a4","\\\\x8125002590fc813711e9083ddd1e0b2e","\\\\xbebc0026554da21811e09e52e0e27896","\\\\x80c70026554da21811e421c6c65df82a","\\\\x80cb002590fc813711e56e44b95ebb90","\\\\x80d3001e6706a2b111e4a13015148989","\\\\xa7d68ead8dba74104f6072ed27551d2b","\\\\x87de0026554da21811e103c22fce876e","\\\\x8f920026554da21211dfa03a8b5713cd","\\\\xab9a0026554da21811e0a7b2c52c709e","\\\\x9fe80026554da21811e0971457114a40","\\\\x8130002590fc813711e9d52c49f69afc","\\\\x881f47ef298a0b3a4d07870318101659","\\\\x80fb001e6706a2b111e5470f79e59000","\\\\x80d2001e6706a2b111e49bb2b1874c1f","\\\\x8124002590fc813711e864b79dc1079b"}'::bytea[])))
49. 0.429 0.429 ↑ 1.0 1 429

Index Scan using _reference164_pkey on _reference164 t25 (cost=0.06..2.27 rows=1 width=57) (actual time=0.001..0.001 rows=1 loops=429)

  • Index Cond: (_idrref = t12._fld1777rref)
50. 1.716 1.716 ↑ 1.0 1 429

Index Only Scan using tmpind_1 on tt4 t26 (cost=0.16..0.20 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=429)

  • Index Cond: (_reffieldrref = t24._idrref)
  • Heap Fetches: 429
51. 0.001 0.002 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.00..0.02 rows=1 width=358) (actual time=0.002..0.002 rows=0 loops=1)

52. 0.000 0.001 ↓ 0.0 0 1

HashAggregate (cost=0.00..0.01 rows=1 width=359) (actual time=0.001..0.001 rows=0 loops=1)

  • Group Key: CASE WHEN (NOT _folder) THEN true WHEN _folder THEN false ELSE NULL::boolean END, _idrref, _idrref
53. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=124) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
54. 0.031 48,076.124 ↓ 252.0 252 1

Subquery Scan on *SELECT* 3 (cost=42,883.04..42,883.08 rows=1 width=334) (actual time=48,075.844..48,076.124 rows=252 loops=1)

55. 0.244 48,076.093 ↓ 252.0 252 1

GroupAggregate (cost=42,883.04..42,883.07 rows=1 width=335) (actual time=48,075.843..48,076.093 rows=252 loops=1)

  • Group Key: t62._owneridrref, (CASE WHEN (NOT t73._folder) THEN true WHEN t73._folder THEN false ELSE NULL::boolean END), t74._idrref, t62._fld1777rref, t73._idrref
56. 0.222 48,075.849 ↓ 252.0 252 1

Sort (cost=42,883.04..42,883.05 rows=1 width=188) (actual time=48,075.835..48,075.849 rows=252 loops=1)

  • Sort Key: t62._owneridrref, (CASE WHEN (NOT t73._folder) THEN true WHEN t73._folder THEN false ELSE NULL::boolean END), t74._idrref, t62._fld1777rref
  • Sort Method: quicksort Memory: 81kB
57. 69.359 48,075.627 ↓ 252.0 252 1

Nested Loop Anti Join (cost=42,826.23..42,882.99 rows=1 width=188) (actual time=47,937.866..48,075.627 rows=252 loops=1)

  • Join Filter: ((t76._q_000_f_001rref = t62._owneridrref) AND (t76._q_000_f_002rref = t62._fld1777rref))
  • Rows Removed by Join Filter: 749,243
58. 0.154 47,953.831 ↓ 681.0 681 1

Nested Loop (cost=42,826.23..42,830.95 rows=1 width=187) (actual time=47,937.546..47,953.831 rows=681 loops=1)

  • Join Filter: (t62._owneridrref = t75._reffieldrref)
59. 0.236 47,950.953 ↓ 681.0 681 1

Nested Loop Left Join (cost=42,826.07..42,830.74 rows=1 width=187) (actual time=47,937.511..47,950.953 rows=681 loops=1)

60. 0.441 47,950.036 ↓ 681.0 681 1

Nested Loop (cost=42,826.01..42,828.39 rows=1 width=130) (actual time=47,937.505..47,950.036 rows=681 loops=1)

61. 9.186 47,946.871 ↓ 681.0 681 1

GroupAggregate (cost=42,825.85..42,825.98 rows=1 width=166) (actual time=47,937.492..47,946.871 rows=681 loops=1)

  • Group Key: t62._owneridrref, t67._lineno2094, t72._idrref, t62._fld1777rref
62. 1.359 47,937.685 ↓ 1,439.0 1,439 1

Sort (cost=42,825.85..42,825.85 rows=1 width=175) (actual time=47,937.464..47,937.685 rows=1,439 loops=1)

  • Sort Key: t62._owneridrref, t67._lineno2094, t72._idrref, t62._fld1777rref
  • Sort Method: quicksort Memory: 431kB
63. 1.172 47,936.326 ↓ 1,439.0 1,439 1

Nested Loop Left Join (cost=42,809.25..42,825.80 rows=1 width=175) (actual time=47,918.525..47,936.326 rows=1,439 loops=1)

64. 0.791 47,932.276 ↓ 1,439.0 1,439 1

Nested Loop (cost=42,809.08..42,825.48 rows=1 width=118) (actual time=47,918.513..47,932.276 rows=1,439 loops=1)

65. 5.474 47,924.290 ↓ 1,439.0 1,439 1

Nested Loop (cost=42,809.08..42,823.66 rows=1 width=105) (actual time=47,918.506..47,924.290 rows=1,439 loops=1)

  • Join Filter: ((t59._q_001_f_002 >= date_trunc('day'::text, ('2020-06-30 23:59:59'::timestamp without time zone + ((((((- t61._fld2095))::integer)::numeric)::text || 'DAY'::text))::interval))) AND (t59._q_001_f_002 <= (((((('2000-01-01 00:00:00'::timestamp without time zone + ((((((((date_part('YEAR'::text, ('2020-06-30 23:59:59'::timestamp without time zone + ((((((- t61._fld2096))::integer)::numeric)::text || 'DAY'::text))::interval)))::integer)::numeric - '2000'::numeric))::integer)::numeric)::text || 'YEAR'::text))::interval) + ((((((((date_part('MONTH'::text, ('2020-06-30 23:59:59'::timestamp without time zone + ((((((- t61._fld2096))::integer)::numeric)::text || 'DAY'::text))::interval)))::integer)::numeric - '1'::numeric))::integer)::numeric)::text || 'MONTH'::text))::interval) + ((((((((date_part('DAY'::text, ('2020-06-30 23:59:59'::timestamp without time zone + ((((((- t61._fld2096))::integer)::numeric)::text || 'DAY'::text))::interval)))::integer)::numeric - '1'::numeric))::integer)::numeric)::text || 'DAY'::text))::interval) + ('23HOUR'::cstring)::interval) + ('59MINUTE'::cstring)::interval) + ('59SECOND'::cstring)::interval)))
66. 0.002 0.044 ↑ 1.0 1 1

Nested Loop (cost=0.22..5.41 rows=1 width=19) (actual time=0.038..0.044 rows=1 loops=1)

67. 0.003 0.031 ↑ 1.0 1 1

Nested Loop (cost=0.22..3.58 rows=1 width=11) (actual time=0.031..0.031 rows=1 loops=1)

68. 0.004 0.016 ↑ 1.0 1 1

GroupAggregate (cost=0.11..1.24 rows=1 width=28) (actual time=0.016..0.016 rows=1 loops=1)

  • Group Key: t70._fld16635rref
69. 0.012 0.012 ↓ 2.0 2 1

Index Only Scan using _inforg16634_bydims_rt on _inforg16634 t70 (cost=0.11..1.23 rows=1 width=28) (actual time=0.011..0.012 rows=2 loops=1)

  • Index Cond: ((_fld16635rref = '\\xaed50022152f41cb11ded3452bb9e1e0'::bytea) AND (_period <= '2020-06-30 23:59:59'::timestamp without time zone))
  • Heap Fetches: 0
70. 0.012 0.012 ↑ 1.0 1 1

Index Scan using _inforg16634_bydims_rt on _inforg16634 t71 (cost=0.11..2.33 rows=1 width=39) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((_fld16635rref = t70._fld16635rref) AND (_period = (max(t70._period))))
71. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on _reference126_vt2093 t61 (cost=0.00..1.81 rows=1 width=8) (actual time=0.007..0.011 rows=1 loops=1)

  • Filter: (_reference126_idrref = '\\x80c7002590fc813711e560b00591b683'::bytea)
  • Rows Removed by Filter: 73
72. 0.329 47,918.772 ↓ 1,439.0 1,439 1

Hash Right Join (cost=42,808.86..42,818.16 rows=1 width=94) (actual time=47,918.441..47,918.772 rows=1,439 loops=1)

  • Hash Cond: (t66._fld16635rref = t62._fld1745rref)
73. 0.006 1.026 ↑ 1.0 4 1

Nested Loop (cost=73.52..82.81 rows=4 width=31) (actual time=1.007..1.026 rows=4 loops=1)

74. 0.591 1.000 ↑ 1.0 4 1

HashAggregate (cost=73.41..73.45 rows=4 width=28) (actual time=0.997..1.000 rows=4 loops=1)

  • Group Key: t65._fld16635rref
75. 0.409 0.409 ↑ 1.0 3,375 1

Seq Scan on _inforg16634 t65 (cost=0.00..66.65 rows=3,378 width=28) (actual time=0.011..0.409 rows=3,375 loops=1)

  • Filter: (_period <= '2020-06-30 23:59:59'::timestamp without time zone)
  • Rows Removed by Filter: 48
76. 0.020 0.020 ↑ 1.0 1 4

Index Scan using _inforg16634_bydims_rt on _inforg16634 t66 (cost=0.11..2.33 rows=1 width=39) (actual time=0.005..0.005 rows=1 loops=4)

  • Index Cond: ((_fld16635rref = t65._fld16635rref) AND (_period = (max(t65._period))))
77. 0.700 47,917.417 ↓ 1,439.0 1,439 1

Hash (cost=42,735.33..42,735.33 rows=1 width=103) (actual time=47,917.417..47,917.417 rows=1,439 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 162kB
78. 2.808 47,916.717 ↓ 1,439.0 1,439 1

Nested Loop Left Join (cost=42,732.98..42,735.33 rows=1 width=103) (actual time=29,734.894..47,916.717 rows=1,439 loops=1)

79. 16,791.563 47,908.153 ↓ 1,439.0 1,439 1

GroupAggregate (cost=42,732.82..42,732.93 rows=1 width=147) (actual time=29,734.855..47,908.153 rows=1,439 loops=1)

  • Group Key: t59._q_001_f_002, t59._q_001_f_003tref, t55._fld18892_rtref, t55._fld18892_type, t55._fld18891rref, t55._fld18892_rrref, t59._q_001_f_003rref, (sum(t55._fld18895))
  • Filter: (CASE WHEN (sum((t60._q_001_f_005 * CASE WHEN ((t60._q_001_f_004_00 = '0'::numeric) AND (t60._q_001_f_005 > '0'::numeric) AND ((t60._q_001_f_003tref <> t59._q_001_f_003tref) OR (t60._q_001_f_003rref <> t59._q_001_f_003rref))) THEN '1'::numeric WHEN ((t60._q_001_f_004_00 <> '0'::numeric) AND (t60._q_001_f_005 < '0'::numeric) AND ((t60._q_001_f_003tref <> t59._q_001_f_003tref) OR (t60._q_001_f_003rref <> t59._q_001_f_003rref))) THEN '-1'::numeric ELSE '0'::numeric END)) > (sum(t55._fld18895))) THEN '0'::numeric ELSE CASE WHEN (sum((t60._q_001_f_005 * CASE WHEN ((t60._q_001_f_004_00 = '0'::numeric) AND (t60._q_001_f_005 > '0'::numeric)) THEN '1'::numeric WHEN ((t60._q_001_f_004_00 <> '0'::numeric) AND (t60._q_001_f_005 < '0'::numeric)) THEN '-1'::numeric ELSE '0'::numeric END)) > (sum(t55._fld18895))) THEN (sum(CASE WHEN ((t59._q_001_f_003tref = t60._q_001_f_003tref) AND (t59._q_001_f_003rref = t60._q_001_f_003rref)) THEN (sum(t55._fld18895)) ELSE '0'::numeric END) - sum((t60._q_001_f_005 * CASE WHEN ((t60._q_001_f_004_00 = '0'::numeric) AND (t60._q_001_f_005 > '0'::numeric) AND ((t59._q_001_f_003tref <> t60._q_001_f_003tref) OR (t59._q_001_f_003rref <> t60._q_001_f_003rref))) THEN '1'::numeric WHEN ((t60._q_001_f_004_00 <> '0'::numeric) AND (t60._q_001_f_005 < '0'::numeric) AND ((t59._q_001_f_003tref <> t60._q_001_f_003tref) OR (t59._q_001_f_003rref <> t60._q_001_f_003rref))) THEN '-1'::numeric ELSE '0'::numeric END))) ELSE sum((t59._q_001_f_005 * CASE WHEN ((t59._q_001_f_004_00 = '0'::numeric) AND (t59._q_001_f_005 > '0'::numeric) AND (t59._q_001_f_003tref = t60._q_001_f_003tref) AND (t59._q_001_f_003rref = t60._q_001_f_003rref)) THEN '1'::numeric WHEN ((t59._q_001_f_004_00 <> '0'::numeric) AND (t59._q_001_f_005 < '0'::numeric) AND (t59._q_001_f_003tref = t60._q_001_f_003tref) AND (t59._q_001_f_003rref = t60._q_001_f_003rref)) THEN '-1'::numeric ELSE '0'::numeric END)) END END > '0'::numeric)
  • Rows Removed by Filter: 47,266
80. 23,744.646 31,116.590 ↓ 10,353,584.0 10,353,584 1

Sort (cost=42,732.82..42,732.82 rows=1 width=157) (actual time=29,367.187..31,116.590 rows=10,353,584 loops=1)

  • Sort Key: t59._q_001_f_002, t59._q_001_f_003tref, t55._fld18892_rtref, t55._fld18892_type, t55._fld18891rref, t55._fld18892_rrref, t59._q_001_f_003rref, (sum(t55._fld18895))
  • Sort Method: external sort Disk: 1,463,264kB
81. 6,889.151 7,371.944 ↓ 10,353,584.0 10,353,584 1

Hash Right Join (cost=22,851.20..42,732.71 rows=1 width=157) (actual time=272.867..7,371.944 rows=10,353,584 loops=1)

  • Hash Cond: ((t60._q_001_f_000rref = t59._q_001_f_000rref) AND (t60._q_001_f_001_type = t59._q_001_f_001_type) AND (t60._q_001_f_001_rtref = t59._q_001_f_001_rtref) AND (t60._q_001_f_001_rrref = t59._q_001_f_001_rrref))
  • Join Filter: ((t60._q_001_f_002 > t59._q_001_f_002) OR ((t60._q_001_f_002 = t59._q_001_f_002) AND ((t60._q_001_f_003tref > t59._q_001_f_003tref) OR ((t60._q_001_f_003tref = t59._q_001_f_003tref) AND (t60._q_001_f_003rref >= t59._q_001_f_003rref)))))
  • Rows Removed by Join Filter: 10,304,879
82. 209.957 209.957 ↑ 1.0 316,644 1

Seq Scan on tt3 t60 (cost=0.00..17,976.90 rows=316,851 width=81) (actual time=0.017..209.957 rows=316,644 loops=1)

  • Filter: ((_q_001_f_002 <= '2020-06-30 23:59:59'::timestamp without time zone) AND (((_q_001_f_004_00 = '0'::numeric) AND (_q_001_f_005 > '0'::numeric)) OR ((_q_001_f_004_00 <> '0'::numeric) AND (_q_001_f_005 < '0'::numeric))))
  • Rows Removed by Filter: 284,483
83. 21.706 272.836 ↓ 48,705.0 48,705 1

Hash (cost=22,851.19..22,851.19 rows=1 width=166) (actual time=272.836..272.836 rows=48,705 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 8,532kB
84. 58.789 251.130 ↓ 48,705.0 48,705 1

Hash Join (cost=3,543.51..22,851.19 rows=1 width=166) (actual time=24.529..251.130 rows=48,705 loops=1)

  • Hash Cond: ((t59._q_001_f_000rref = t55._fld18891rref) AND (t59._q_001_f_001_type = t55._fld18892_type) AND (t59._q_001_f_001_rtref = t55._fld18892_rtref) AND (t59._q_001_f_001_rrref = t55._fld18892_rrref))
85. 167.840 167.840 ↑ 1.0 316,644 1

Seq Scan on tt3 t59 (cost=0.00..17,976.90 rows=316,851 width=81) (actual time=0.010..167.840 rows=316,644 loops=1)

  • Filter: ((_q_001_f_002 <= '2020-06-30 23:59:59'::timestamp without time zone) AND (((_q_001_f_004_00 = '0'::numeric) AND (_q_001_f_005 > '0'::numeric)) OR ((_q_001_f_004_00 <> '0'::numeric) AND (_q_001_f_005 < '0'::numeric))))
  • Rows Removed by Filter: 284,483
86. 0.232 24.501 ↓ 41.5 705 1

Hash (cost=3,543.27..3,543.27 rows=17 width=85) (actual time=24.501..24.501 rows=705 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 64kB
87. 1.545 24.269 ↓ 41.5 705 1

GroupAggregate (cost=0.66..3,543.10 rows=17 width=85) (actual time=0.177..24.269 rows=705 loops=1)

  • Group Key: t55._fld18891rref, t55._fld18892_type, t55._fld18892_rtref, t55._fld18892_rrref
  • Filter: ((sum(t55._fld18895) <> '0'::numeric) AND (sum(t55._fld18895) > '0'::numeric))
  • Rows Removed by Filter: 966
88. 0.770 22.724 ↓ 32.8 1,671 1

Nested Loop (cost=0.66..3,541.98 rows=51 width=60) (actual time=0.103..22.724 rows=1,671 loops=1)

89. 0.000 16.749 ↓ 15.6 1,735 1

Nested Loop (cost=0.50..3,505.11 rows=111 width=97) (actual time=0.094..16.749 rows=1,735 loops=1)

90. 0.202 10.954 ↓ 2.2 3,077 1

Nested Loop (cost=0.33..3,234.40 rows=1,428 width=80) (actual time=0.033..10.954 rows=3,077 loops=1)

91. 1.431 1.431 ↓ 1.7 3,107 1

Index Scan using _accumrg18897_bydims_trrrrn on _accumrgt18897 t55 (cost=0.17..841.59 rows=1,843 width=60) (actual time=0.012..1.431 rows=3,107 loops=1)

  • Index Cond: (_period = '2020-07-01 00:00:00'::timestamp without time zone)
  • Filter: ((_fld18895 <> '0'::numeric) AND (_fld18895 <> '0'::numeric))
  • Rows Removed by Filter: 18
92. 9.321 9.321 ↑ 1.0 1 3,107

Index Scan using _reference72_pkey on _reference72 t56 (cost=0.17..1.30 rows=1 width=40) (actual time=0.003..0.003 rows=1 loops=3,107)

  • Index Cond: (_idrref = t55._fld18891rref)
  • Filter: ((NOT _fld27229) AND (_fld1747rref <> '\\x80be0026554da21811e35bd742084a77'::bytea) AND (_description <> 'Премия'::mvarchar))
  • Rows Removed by Filter: 0
93. 6.154 6.154 ↑ 1.0 1 3,077

Index Only Scan using tmpind_1 on tt4 t58 (cost=0.16..0.19 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=3,077)

  • Index Cond: (_reffieldrref = t56._owneridrref)
  • Heap Fetches: 1,735
94. 5.205 5.205 ↑ 1.0 1 1,735

Index Scan using _reference112_pkey on _reference112 t57 (cost=0.17..0.33 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=1,735)

  • Index Cond: (_idrref = t56._owneridrref)
  • Filter: ((_fld26316rref = ANY ('{"\\\\xb7dcf2b4ca2ca8dd40078792a5d5eb2d","\\\\xa521826e890126e9434536bd7c0cc90f"}'::bytea[])) AND (_fld1961rref <> ALL ('{"\\\\x80ff002590fc813711e6ad7c7634de81","\\\\x84f908002735c70211e16e443036d4be","\\\\x80ff002590fc813711e6afd4e0ec463b","\\\\x80ff002590fc813711e6a72606095ea5","\\\\x80ff002590fc813711e6a72660881bf6","\\\\x80ff002590fc813711e6afd552c21525","\\\\x80ff002590fc813711e6a727895fa037","\\\\x80ff002590fc813711e6a7255c4cb91d","\\\\x80ff002590fc813711e6a7263bba535d","\\\\x80ff002590fc813711e6a72691bd9c37","\\\\xaedd001e0b28018b11df1c7c4af2d5f0","\\\\xbd85f50ca933a6c44cd335ea2f9d3cf8","\\\\xb6ab0026554da21211df84070e90dc23","\\\\x80d2001e6706a2b111e47ea256a87259","\\\\x811a002590fc813711e76c45392151a4","\\\\x8125002590fc813711e9083ddd1e0b2e","\\\\xbebc0026554da21811e09e52e0e27896","\\\\x80c70026554da21811e421c6c65df82a","\\\\x80cb002590fc813711e56e44b95ebb90","\\\\x80d3001e6706a2b111e4a13015148989","\\\\xa7d68ead8dba74104f6072ed27551d2b","\\\\x87de0026554da21811e103c22fce876e","\\\\x8f920026554da21211dfa03a8b5713cd","\\\\xab9a0026554da21811e0a7b2c52c709e","\\\\x9fe80026554da21811e0971457114a40","\\\\x8130002590fc813711e9d52c49f69afc","\\\\x881f47ef298a0b3a4d07870318101659","\\\\x80fb001e6706a2b111e5470f79e59000","\\\\x80d2001e6706a2b111e49bb2b1874c1f","\\\\x8124002590fc813711e864b79dc1079b"}'::bytea[])))
  • Rows Removed by Filter: 0
95. 5.756 5.756 ↑ 1.0 1 1,439

Index Scan using _reference72_pkey on _reference72 t62 (cost=0.17..2.38 rows=1 width=83) (actual time=0.004..0.004 rows=1 loops=1,439)

  • Index Cond: (_idrref = t55._fld18891rref)
96. 7.195 7.195 ↑ 1.0 1 1,439

Seq Scan on _reference126_vt2093 t67 (cost=0.00..1.81 rows=1 width=13) (actual time=0.002..0.005 rows=1 loops=1,439)

  • Filter: (_reference126_idrref = '\\x80c7002590fc813711e560b00591b683'::bytea)
  • Rows Removed by Filter: 73
97. 2.878 2.878 ↑ 1.0 1 1,439

Index Scan using _reference112_pkey on _reference112 t72 (cost=0.17..0.32 rows=1 width=57) (actual time=0.002..0.002 rows=1 loops=1,439)

  • Index Cond: (_idrref = t62._owneridrref)
98. 2.724 2.724 ↑ 1.0 1 681

Index Scan using _reference112_pkey on _reference112 t73 (cost=0.17..2.40 rows=1 width=58) (actual time=0.004..0.004 rows=1 loops=681)

  • Index Cond: (_idrref = t62._owneridrref)
  • Filter: ((_fld26316rref = ANY ('{"\\\\xb7dcf2b4ca2ca8dd40078792a5d5eb2d","\\\\xa521826e890126e9434536bd7c0cc90f"}'::bytea[])) AND (_fld1961rref <> ALL ('{"\\\\x80ff002590fc813711e6ad7c7634de81","\\\\x84f908002735c70211e16e443036d4be","\\\\x80ff002590fc813711e6afd4e0ec463b","\\\\x80ff002590fc813711e6a72606095ea5","\\\\x80ff002590fc813711e6a72660881bf6","\\\\x80ff002590fc813711e6afd552c21525","\\\\x80ff002590fc813711e6a727895fa037","\\\\x80ff002590fc813711e6a7255c4cb91d","\\\\x80ff002590fc813711e6a7263bba535d","\\\\x80ff002590fc813711e6a72691bd9c37","\\\\xaedd001e0b28018b11df1c7c4af2d5f0","\\\\xbd85f50ca933a6c44cd335ea2f9d3cf8","\\\\xb6ab0026554da21211df84070e90dc23","\\\\x80d2001e6706a2b111e47ea256a87259","\\\\x811a002590fc813711e76c45392151a4","\\\\x8125002590fc813711e9083ddd1e0b2e","\\\\xbebc0026554da21811e09e52e0e27896","\\\\x80c70026554da21811e421c6c65df82a","\\\\x80cb002590fc813711e56e44b95ebb90","\\\\x80d3001e6706a2b111e4a13015148989","\\\\xa7d68ead8dba74104f6072ed27551d2b","\\\\x87de0026554da21811e103c22fce876e","\\\\x8f920026554da21211dfa03a8b5713cd","\\\\xab9a0026554da21811e0a7b2c52c709e","\\\\x9fe80026554da21811e0971457114a40","\\\\x8130002590fc813711e9d52c49f69afc","\\\\x881f47ef298a0b3a4d07870318101659","\\\\x80fb001e6706a2b111e5470f79e59000","\\\\x80d2001e6706a2b111e49bb2b1874c1f","\\\\x8124002590fc813711e864b79dc1079b"}'::bytea[])))
99. 0.681 0.681 ↑ 1.0 1 681

Index Scan using _reference164_pkey on _reference164 t74 (cost=0.06..2.27 rows=1 width=57) (actual time=0.001..0.001 rows=1 loops=681)

  • Index Cond: (_idrref = t62._fld1777rref)
100. 2.724 2.724 ↑ 1.0 1 681

Index Only Scan using tmpind_1 on tt4 t75 (cost=0.16..0.20 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=681)

  • Index Cond: (_reffieldrref = t73._idrref)
  • Heap Fetches: 681
101. 52.437 52.437 ↑ 1.5 1,101 681

Seq Scan on tt2 t76 (cost=0.00..32.38 rows=1,638 width=34) (actual time=0.002..0.077 rows=1,101 loops=681)