explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YLcI : Optimization for: Optimization for: plan #oM20; plan #ALlt

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 134,084.828 ↓ 40.0 40 1

Limit (cost=258,261.24..258,261.33 rows=1 width=354) (actual time=134,084.797..134,084.828 rows=40 loops=1)

  • Buffers: shared hit=4817404
2. 0.025 134,084.824 ↓ 40.0 40 1

Group (cost=258,261.24..258,261.33 rows=1 width=354) (actual time=134,084.795..134,084.824 rows=40 loops=1)

  • Group Key: t64._date_time, t64._idrref, t64._marked, t64._number, t64._posted, t64._fld10694rref, t64._fld10695rref, t94._fld2846rref, t64._fld10696, t64._fld10697rref, t64._fld10706rref, t64._fld10699, (CASE WHEN ((t64._fld10697rref = '\\216\\255\ (...)
  • Buffers: shared hit=4817404
3. 1.063 134,084.799 ↓ 40.0 40 1

Sort (cost=258,261.24..258,261.24 rows=1 width=354) (actual time=134,084.794..134,084.799 rows=40 loops=1)

  • Sort Key: t64._date_time DESC, t64._idrref DESC, t64._marked, t64._number, t64._posted, t64._fld10694rref, t64._fld10695rref, t94._fld2846rref, t64._fld10696, t64._fld10697rref, t64._fld10706rref, t64._fld10699, (CASE WHEN ((t64._fld10697rref (...)
  • Sort Method: quicksort Memory: 212kB
  • Buffers: shared hit=4817404
4. 3.590 134,083.736 ↓ 412.0 412 1

Nested Loop Left Join (cost=129,561.98..258,261.23 rows=1 width=354) (actual time=1,146.988..134,083.736 rows=412 loops=1)

  • Join Filter: ((t65._fld10729_type = '\\010'::bytea) AND (t65._fld10729_rtref = '\\000\\000\\000T'::bytea))
  • Buffers: shared hit=4817404
5. 1.981 134,066.550 ↓ 412.0 412 1

Nested Loop Semi Join (cost=129,548.87..258,214.03 rows=1 width=339) (actual time=1,146.877..134,066.550 rows=412 loops=1)

  • Join Filter: (CASE WHEN (alternatives: SubPlan 28 or hashed SubPlan 29) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 30 or hashed SubPlan 31) THEN true ELSE false END)
  • Buffers: shared hit=4812003
6. 0.945 134,059.625 ↓ 412.0 412 1

Nested Loop Left Join (cost=129,536.18..258,182.86 rows=1 width=339) (actual time=1,146.780..134,059.625 rows=412 loops=1)

  • Buffers: shared hit=4809510
7. 4.159 134,051.676 ↓ 412.0 412 1

Nested Loop Left Join (cost=129,535.77..258,121.44 rows=1 width=339) (actual time=1,146.769..134,051.676 rows=412 loops=1)

  • Join Filter: (t64._fld10695rref = t94._idrref)
  • Rows Removed by Join Filter: 39552
  • Buffers: shared hit=4807281
8. 19,196.806 134,035.981 ↓ 412.0 412 1

Nested Loop Left Join (cost=129,535.77..258,116.01 rows=1 width=322) (actual time=1,146.741..134,035.981 rows=412 loops=1)

  • Join Filter: (t75._fld20116_rrref = t64._idrref)
  • Rows Removed by Join Filter: 264092196
  • Filter: (t75._document361_idrref IS NULL)
  • Rows Removed by Filter: 5926
  • Buffers: shared hit=4806045
9. 12.967 241.797 ↓ 6,338.0 6,338 1

Nested Loop Left Join (cost=13.96..46.85 rows=1 width=322) (actual time=0.201..241.797 rows=6,338 loops=1)

  • Buffers: shared hit=88788
10. 7.000 7.000 ↓ 6,338.0 6,338 1

Index Scan using _document357_bydocdate_trl on _document357 t64 (cost=0.42..7.45 rows=1 width=298) (actual time=0.023..7.000 rows=6,338 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_date_time >= '2019-07-01 00:00:00'::timestamp without time zone) AND (_date_time >= '2019-08-01 00:00:00'::timestamp without time zone) AND (_date_time <= ' (...)
  • Buffers: shared hit=1226
11. 26.924 221.830 ↑ 1.0 1 6,338

Nested Loop Semi Join (cost=13.54..39.39 rows=1 width=41) (actual time=0.033..0.035 rows=1 loops=6,338)

  • Join Filter: (CASE WHEN (alternatives: SubPlan 1 or hashed SubPlan 2) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 3 or hashed SubPlan 4) THEN true ELSE false END)
  • Buffers: shared hit=87562
12. 19.931 120.422 ↑ 1.0 1 6,338

Nested Loop (cost=0.85..8.22 rows=1 width=58) (actual time=0.017..0.019 rows=1 loops=6,338)

  • Buffers: shared hit=50299
13. 57.042 57.042 ↑ 1.0 1 6,338

Index Scan using _document357_vt10724_intkeyind on _document357_vt10724 t65 (cost=0.42..7.44 rows=1 width=44) (actual time=0.009..0.009 rows=1 loops=6,338)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_document357_idrref = t64._idrref))
  • Buffers: shared hit=25357
14. 43.449 43.449 ↑ 1.0 1 6,207

Index Scan using _document357hpk on _document357 t67 (cost=0.42..0.76 rows=1 width=37) (actual time=0.007..0.007 rows=1 loops=6,207)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t65._document357_idrref))
  • Buffers: shared hit=24942
15. 0.000 0.000 ↑ 1.0 1 6,207

Materialize (cost=12.69..23.29 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=6,207)

  • Buffers: shared hit=21
16. 0.002 0.102 ↑ 1.0 1 1

Nested Loop (cost=12.69..23.29 rows=1 width=17) (actual time=0.102..0.102 rows=1 loops=1)

  • Buffers: shared hit=21
17. 0.002 0.090 ↑ 1.0 1 1

Nested Loop (cost=12.42..22.99 rows=1 width=38) (actual time=0.090..0.090 rows=1 loops=1)

  • Buffers: shared hit=17
18. 0.022 0.022 ↑ 1.0 1 1

Index Only Scan using _reference105_byfield2798_sr on _reference105 t70 (cost=0.41..3.92 rows=1 width=20) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: (_fld2789 = 'Документ.ПриходныйКассовыйОрдер'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=4
19. 0.005 0.066 ↑ 1.0 1 1

Nested Loop (cost=12.01..19.05 rows=1 width=57) (actual time=0.066..0.066 rows=1 loops=1)

  • Buffers: shared hit=13
20. 0.005 0.046 ↑ 1.0 1 1

HashAggregate (cost=11.59..11.60 rows=1 width=19) (actual time=0.046..0.046 rows=1 loops=1)

  • Group Key: t71._reference73_idrref
  • Buffers: shared hit=8
21. 0.007 0.041 ↓ 2.0 2 1

Nested Loop (cost=0.56..11.59 rows=1 width=19) (actual time=0.039..0.041 rows=2 loops=1)

  • Buffers: shared hit=8
22. 0.016 0.016 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t72 (cost=0.28..3.83 rows=2 width=24) (actual time=0.014..0.016 rows=2 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AND (_fld14728_rrref = '\\33 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
23. 0.018 0.018 ↑ 3.0 1 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t71 (cost=0.28..3.85 rows=3 width=49) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t72._fld14727_type) AND (_fld2105_rtref = t72._fld14727_rtref) AND (_fld2105_rrref = t72._fld14727_ (...)
  • Heap Fetches: 0
  • Buffers: shared hit=5
24. 0.015 0.015 ↑ 1.0 1 1

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t69 (cost=0.42..7.44 rows=1 width=38) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t71._reference73_idrref) AND (_fld14846rref = t70._idrref))
  • Heap Fetches: 1
  • Buffers: shared hit=5
25. 0.010 0.010 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t68 (cost=0.27..0.29 rows=1 width=17) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t69._fld14847rref))
  • Heap Fetches: 1
  • Buffers: shared hit=4
26.          

SubPlan (forNested Loop Semi Join)

27. 43.449 43.449 ↓ 0.0 0 6,207

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t73 (cost=0.41..3.93 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=6,207)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea) AND (_fld13933_rrref = t67._fld10697rref) AND (_fld13932rref = (...)
  • Heap Fetches: 0
  • Buffers: shared hit=18621
28. 0.000 0.000 ↓ 0.0 0

Seq Scan on _inforg13931 t73_1 (cost=0.00..81.34 rows=1,481 width=36) (never executed)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea))
29. 31.035 31.035 ↓ 0.0 0 6,207

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t74 (cost=0.41..3.93 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=6,207)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t68._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=18621
30. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t74_1 (cost=0.41..192.24 rows=45 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
31. 44,197.842 114,597.378 ↓ 4.0 41,669 6,338

Hash Join (cost=129,521.81..257,938.75 rows=10,433 width=38) (actual time=1.466..18.081 rows=41,669 loops=6,338)

  • Hash Cond: (t86._idrref = t75._document361_idrref)
  • Buffers: shared hit=4717257
32. 37,145.381 70,326.448 ↓ 2.0 16,029 6,338

Nested Loop Semi Join (cost=12.69..127,323.55 rows=8,014 width=17) (actual time=0.002..11.096 rows=16,029 loops=6,338)

  • Join Filter: (CASE WHEN (alternatives: SubPlan 9 or hashed SubPlan 10) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 11 or hashed SubPlan 12) THEN true ELSE false END)
  • Buffers: shared hit=4715628
33. 33,179.430 33,179.430 ↑ 1.0 16,029 6,338

Seq Scan on _document361 t86 (cost=0.00..944.36 rows=16,029 width=34) (actual time=0.001..5.235 rows=16,029 loops=6,338)

  • Filter: (_posted AND (_fld717 = '0'::numeric))
  • Buffers: shared hit=4715472
34. 0.000 0.000 ↑ 1.0 1 101,591,802

Materialize (cost=12.69..30.59 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=101,591,802)

  • Buffers: shared hit=21
35. 0.003 0.065 ↑ 1.0 1 1

Nested Loop Semi Join (cost=12.69..30.59 rows=1 width=17) (actual time=0.065..0.065 rows=1 loops=1)

  • Buffers: shared hit=21
36. 0.009 0.053 ↑ 1.0 1 1

Nested Loop (cost=12.27..16.13 rows=1 width=56) (actual time=0.053..0.053 rows=1 loops=1)

  • Buffers: shared hit=16
37. 0.001 0.040 ↑ 1.0 1 1

Nested Loop (cost=12.00..15.54 rows=1 width=39) (actual time=0.040..0.040 rows=1 loops=1)

  • Buffers: shared hit=12
38. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using _reference105_byfield2798_sr on _reference105 t87 (cost=0.41..3.92 rows=1 width=20) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (_fld2789 = 'Документ.РаспоряжениеНаПеремещениеДенежныхСредств'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=4
39. 0.002 0.030 ↑ 1.0 1 1

HashAggregate (cost=11.59..11.60 rows=1 width=19) (actual time=0.030..0.030 rows=1 loops=1)

  • Group Key: t90._reference73_idrref
  • Buffers: shared hit=8
40. 0.005 0.028 ↓ 2.0 2 1

Nested Loop (cost=0.56..11.59 rows=1 width=19) (actual time=0.026..0.028 rows=2 loops=1)

  • Buffers: shared hit=8
41. 0.011 0.011 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t91 (cost=0.28..3.83 rows=2 width=24) (actual time=0.010..0.011 rows=2 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AND (_fld14728_rrref = '\\33 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
42. 0.012 0.012 ↑ 3.0 1 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t90 (cost=0.28..3.85 rows=3 width=49) (actual time=0.005..0.006 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t91._fld14727_type) AND (_fld2105_rtref = t91._fld14727_rtref) AND (_fld2105_rrref = t91._fld14727_ (...)
  • Heap Fetches: 0
  • Buffers: shared hit=5
43. 0.004 0.004 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t88 (cost=0.27..0.58 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t90._reference73_idrref))
  • Heap Fetches: 1
  • Buffers: shared hit=4
44. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t89 (cost=0.42..7.44 rows=1 width=38) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t88._idrref) AND (_fld14846rref = t87._idrref))
  • Heap Fetches: 1
  • Buffers: shared hit=5
45.          

SubPlan (forNested Loop Semi Join)

46. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t92 (cost=0.41..3.93 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea) AND (_fld13933_rrref = t86._fld10905rref) AND (_fld13932rref = (...)
  • Heap Fetches: 0
47. 1.277 1.277 ↑ 1.0 1,481 1

Seq Scan on _inforg13931 t92_1 (cost=0.00..81.34 rows=1,481 width=36) (actual time=0.009..1.277 rows=1,481 loops=1)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea))
  • Rows Removed by Filter: 811
  • Buffers: shared hit=41
48. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t93 (cost=0.41..3.93 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t88._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
49. 0.360 0.360 ↓ 1.5 68 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t93_1 (cost=0.41..192.24 rows=45 width=17) (actual time=0.058..0.360 rows=68 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=94
50. 11.670 73.088 ↓ 2.0 41,669 1

Hash (cost=129,248.28..129,248.28 rows=20,867 width=55) (actual time=73.088..73.088 rows=41,669 loops=1)

  • Buckets: 65536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 3890kB
  • Buffers: shared hit=1629
51. 13.253 61.418 ↓ 2.0 41,669 1

Hash Join (cost=127,423.72..129,248.28 rows=20,867 width=55) (actual time=28.937..61.418 rows=41,669 loops=1)

  • Hash Cond: (t75._document361_idrref = t77._idrref)
  • Buffers: shared hit=1629
52. 19.276 19.276 ↑ 1.0 41,669 1

Seq Scan on _document361_vt20114 t75 (cost=0.00..1,459.38 rows=41,736 width=41) (actual time=0.008..19.276 rows=41,669 loops=1)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld20116_type = '\\010'::bytea) AND (_fld20116_rtref = '\\000\\000\\001e'::bytea))
  • Buffers: shared hit=729
53. 4.717 28.889 ↓ 2.0 16,029 1

Hash (cost=127,323.55..127,323.55 rows=8,014 width=20) (actual time=28.889..28.889 rows=16,029 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 942kB
  • Buffers: shared hit=900
54. 12.754 24.172 ↓ 2.0 16,029 1

Nested Loop Semi Join (cost=12.69..127,323.55 rows=8,014 width=20) (actual time=2.159..24.172 rows=16,029 loops=1)

  • Join Filter: (CASE WHEN (alternatives: SubPlan 5 or hashed SubPlan 6) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 7 or hashed SubPlan 8) THEN true ELSE false END)
  • Buffers: shared hit=900
55. 10.077 10.077 ↑ 1.0 16,029 1

Seq Scan on _document361 t77 (cost=0.00..944.36 rows=16,029 width=37) (actual time=0.005..10.077 rows=16,029 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=744
56. 0.000 0.000 ↑ 1.0 1 16,029

Materialize (cost=12.69..30.59 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=16,029)

  • Buffers: shared hit=21
57. 0.004 0.066 ↑ 1.0 1 1

Nested Loop Semi Join (cost=12.69..30.59 rows=1 width=17) (actual time=0.066..0.066 rows=1 loops=1)

  • Buffers: shared hit=21
58. 0.006 0.054 ↑ 1.0 1 1

Nested Loop (cost=12.27..16.13 rows=1 width=56) (actual time=0.054..0.054 rows=1 loops=1)

  • Buffers: shared hit=16
59. 0.000 0.042 ↑ 1.0 1 1

Nested Loop (cost=12.00..15.54 rows=1 width=39) (actual time=0.042..0.042 rows=1 loops=1)

  • Buffers: shared hit=12
60. 0.012 0.012 ↑ 1.0 1 1

Index Only Scan using _reference105_byfield2798_sr on _reference105 t78 (cost=0.41..3.92 rows=1 width=20) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (_fld2789 = 'Документ.РаспоряжениеНаПеремещениеДенежныхСредств'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=4
61. 0.002 0.030 ↑ 1.0 1 1

HashAggregate (cost=11.59..11.60 rows=1 width=19) (actual time=0.030..0.030 rows=1 loops=1)

  • Group Key: t81._reference73_idrref
  • Buffers: shared hit=8
62. 0.028 0.028 ↓ 2.0 2 1

Nested Loop (cost=0.56..11.59 rows=1 width=19) (actual time=0.026..0.028 rows=2 loops=1)

  • Buffers: shared hit=8
  • -> Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t82 (cost=0.28..3.83 rows=2 width=24) (actual time=0.008..0.008 rows=2 loop (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AND (_fld1 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
  • -> Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t81 (cost=0.28..3.85 rows=3 width=49) (actual time=0.006..0.0 (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t82._fld14727_type) AND (_fld2105_rtref = t82._fld14727_rtref) AND (_fld2105_rrre (...)
  • Heap Fetches: 0
  • Buffers: shared hit=5
63. 0.006 0.006 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t79 (cost=0.27..0.58 rows=1 width=17) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t81._reference73_idrref))
  • Heap Fetches: 1
  • Buffers: shared hit=4
64. 0.008 0.008 ↑ 1.0 1 1

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t80 (cost=0.42..7.44 rows=1 width=38) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t79._idrref) AND (_fld14846rref = t78._idrref))
  • Heap Fetches: 1
  • Buffers: shared hit=5
65.          

SubPlan (forNested Loop Semi Join)

66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t83 (cost=0.41..3.93 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea) AND (_fld13933_rrref = t77._fld10905rref) AN (...)
  • Heap Fetches: 0
67. 1.092 1.092 ↑ 1.0 1,481 1

Seq Scan on _inforg13931 t83_1 (cost=0.00..81.34 rows=1,481 width=36) (actual time=0.007..1.092 rows=1,481 loops=1)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea))
  • Rows Removed by Filter: 811
  • Buffers: shared hit=41
68. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t84 (cost=0.41..3.93 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t79._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\ (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
69. 0.249 0.249 ↓ 1.5 68 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t84_1 (cost=0.41..192.24 rows=45 width=17) (actual time=0.038..0.249 rows=68 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=94
70. 11.536 11.536 ↑ 1.0 97 412

Seq Scan on _reference109 t94 (cost=0.00..4.21 rows=97 width=34) (actual time=0.003..0.028 rows=97 loops=412)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=1236
71. 3.819 7.004 ↓ 0.0 0 412

Index Scan using _document365hpk on _document365 t96 (cost=0.41..61.41 rows=1 width=34) (actual time=0.017..0.017 rows=0 loops=412)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t64._fld10704rref = _idrref))
  • Filter: (SubPlan 20)
  • Buffers: shared hit=2229
72.          

SubPlan (forIndex Scan)

73. 0.196 3.185 ↑ 1.0 1 49

Nested Loop Semi Join (cost=13.10..53.98 rows=1 width=0) (actual time=0.065..0.065 rows=1 loops=49)

  • Join Filter: CASE WHEN (t96._fld10987rref = ANY ('{"\\\\271m\\\\262\\\\223\\\\302\\\\370\\\\215\\\\214F\\\\337y\\\\201\\\\031#\\\\365t","\\\\264\\\\257R\\\\301\\\\263\\\\225U\\\\345N\\\\352\\\\310\\\\325rM\\\\3 (...)
  • Buffers: shared hit=942
74. 0.049 0.441 ↑ 1.0 1 49

Nested Loop Left Join (cost=0.41..7.46 rows=1 width=17) (actual time=0.009..0.009 rows=1 loops=49)

  • Buffers: shared hit=147
75. 0.049 0.049 ↑ 1.0 1 49

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=49)

76. 0.343 0.343 ↓ 0.0 0 49

Index Scan using _document365_vt11021_intkeyind on _document365_vt11021 t97 (cost=0.41..7.43 rows=1 width=17) (actual time=0.007..0.007 rows=0 loops=49)

  • Index Cond: ((_fld717 = t96._fld717) AND (t96._idrref = _document365_idrref))
  • Buffers: shared hit=147
77. 0.147 2.548 ↑ 1.0 1 49

Materialize (cost=12.69..31.16 rows=1 width=17) (actual time=0.052..0.052 rows=1 loops=49)

  • Buffers: shared hit=795
78. 0.147 2.401 ↑ 1.0 1 49

Nested Loop (cost=12.69..31.16 rows=1 width=17) (actual time=0.049..0.049 rows=1 loops=49)

  • Buffers: shared hit=795
79. 0.049 1.225 ↑ 1.0 1 49

Nested Loop (cost=12.42..22.99 rows=1 width=38) (actual time=0.025..0.025 rows=1 loops=49)

  • Buffers: shared hit=353
80. 0.588 0.588 ↑ 1.0 1 49

Index Only Scan using _reference105_byfield2798_sr on _reference105 t100 (cost=0.41..3.92 rows=1 width=20) (actual time=0.012..0.012 rows=1 loops=49)

  • Index Cond: (_fld2789 = 'Документ.РасходныйКассовыйОрдер'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=148
81. 0.098 0.588 ↑ 1.0 1 49

Nested Loop (cost=12.01..19.05 rows=1 width=57) (actual time=0.012..0.012 rows=1 loops=49)

  • Buffers: shared hit=205
82. 0.070 0.098 ↑ 1.0 1 49

HashAggregate (cost=11.59..11.60 rows=1 width=19) (actual time=0.002..0.002 rows=1 loops=49)

  • Group Key: t101._reference73_idrref
  • Buffers: shared hit=8
83. 0.010 0.028 ↓ 2.0 2 1

Nested Loop (cost=0.56..11.59 rows=1 width=19) (actual time=0.028..0.028 rows=2 loops=1)

  • Buffers: shared hit=8
84. 0.008 0.008 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t102 (cost=0.28..3.83 rows=2 width=24) (actual time=0.008..0.008 rows=2 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AND (_fld14728_rrref = '\\336\\2220Z:w (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
85. 0.010 0.010 ↑ 3.0 1 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t101 (cost=0.28..3.85 rows=3 width=49) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t102._fld14727_type) AND (_fld2105_rtref = t102._fld14727_rtref) AND (_fld2105_rrref = t102._fld14727_rrref))
  • Heap Fetches: 0
  • Buffers: shared hit=5
86. 0.392 0.392 ↑ 1.0 1 49

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t99 (cost=0.42..7.44 rows=1 width=38) (actual time=0.008..0.008 rows=1 loops=49)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t101._reference73_idrref) AND (_fld14846rref = t100._idrref))
  • Heap Fetches: 49
  • Buffers: shared hit=197
87. 0.441 1.029 ↑ 1.0 1 49

Index Only Scan using _reference73hpk on _reference73 t98 (cost=0.27..8.16 rows=1 width=17) (actual time=0.021..0.021 rows=1 loops=49)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t99._fld14847rref))
  • Filter: (CASE WHEN (alternatives: SubPlan 13 or hashed SubPlan 14) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 15 or hashed SubPlan 16) THEN true ELSE false END)
  • Heap Fetches: 49
  • Buffers: shared hit=442
88.          

SubPlan (forIndex Only Scan)

89. 0.343 0.343 ↓ 0.0 0 49

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t103 (cost=0.41..3.93 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=49)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea) AND (_fld13933_rrref = t96._fld10987rref) AND (_fld139 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=147
90. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t103_1 (cost=0.41..4.08 rows=7 width=18) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea) AND (_fld13933_rrref = t96._fld10987rref))
  • Heap Fetches: 0
91. 0.245 0.245 ↓ 0.0 0 49

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t104 (cost=0.41..3.93 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=49)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t98._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::byt (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=147
92. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t104_1 (cost=0.41..192.24 rows=45 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
93.          

SubPlan (forNested Loop Semi Join)

94. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..11.39 rows=1 width=0) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t106 (cost=0.42..7.45 rows=1 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = CASE WHEN (t97._fld11023rref IS NOT NULL) THEN '\\010'::bytea ELSE NULL::bytea END) AND (_fld13762_rtref = CASE WHEN (t97._fld11023rref (...)
  • Heap Fetches: 0
96. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t105 (cost=0.41..3.93 rows=1 width=27) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t106._fld13763_type) AND (_fld13933_rtref = t106._fld13763_rtref) AND (_fld13933_rrref = t106._fld13763_rrref) AND (_fld13932rref = t98. (...)
  • Heap Fetches: 0
97. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t107 (cost=0.41..3.93 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t98._idrref) AND (_fld13940_type = CASE WHEN (t97._fld11023rref IS NOT NULL) THEN '\\010'::bytea ELSE NULL::bytea END) (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
98. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t107_1 (cost=0.41..197.25 rows=1,092 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
99. 0.000 0.000 ↑ 1.0 1 412

Materialize (cost=12.69..23.29 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=412)

  • Buffers: shared hit=21
100. 0.002 0.077 ↑ 1.0 1 1

Nested Loop (cost=12.69..23.29 rows=1 width=17) (actual time=0.077..0.077 rows=1 loops=1)

  • Buffers: shared hit=21
101. 0.002 0.069 ↑ 1.0 1 1

Nested Loop (cost=12.42..22.99 rows=1 width=38) (actual time=0.069..0.069 rows=1 loops=1)

  • Buffers: shared hit=17
102. 0.027 0.027 ↑ 1.0 1 1

Index Only Scan using _reference105_byfield2798_sr on _reference105 t122 (cost=0.41..3.92 rows=1 width=20) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: (_fld2789 = 'Документ.ПриходныйКассовыйОрдер'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=4
103. 0.002 0.040 ↑ 1.0 1 1

Nested Loop (cost=12.01..19.05 rows=1 width=57) (actual time=0.040..0.040 rows=1 loops=1)

  • Buffers: shared hit=13
104. 0.006 0.029 ↑ 1.0 1 1

HashAggregate (cost=11.59..11.60 rows=1 width=19) (actual time=0.029..0.029 rows=1 loops=1)

  • Group Key: t123._reference73_idrref
  • Buffers: shared hit=8
105. 0.004 0.023 ↓ 2.0 2 1

Nested Loop (cost=0.56..11.59 rows=1 width=19) (actual time=0.023..0.023 rows=2 loops=1)

  • Buffers: shared hit=8
106. 0.009 0.009 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t124 (cost=0.28..3.83 rows=2 width=24) (actual time=0.008..0.009 rows=2 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AND (_fld14728_rrref = '\\336\\2220Z:wN\\241\\021\\350h\\2 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
107. 0.010 0.010 ↑ 3.0 1 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t123 (cost=0.28..3.85 rows=3 width=49) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t124._fld14727_type) AND (_fld2105_rtref = t124._fld14727_rtref) AND (_fld2105_rrref = t124._fld14727_rrref))
  • Heap Fetches: 0
  • Buffers: shared hit=5
108. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t121 (cost=0.42..7.44 rows=1 width=38) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t123._reference73_idrref) AND (_fld14846rref = t122._idrref))
  • Heap Fetches: 1
  • Buffers: shared hit=5
109. 0.006 0.006 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t120 (cost=0.27..0.29 rows=1 width=17) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t121._fld14847rref))
  • Heap Fetches: 1
  • Buffers: shared hit=4
110.          

SubPlan (forNested Loop Semi Join)

111. 2.884 2.884 ↓ 0.0 0 412

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t125 (cost=0.41..3.93 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=412)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea) AND (_fld13933_rrref = t64._fld10697rref) AND (_fld13932rref = t120._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=1236
112. 0.000 0.000 ↓ 0.0 0

Seq Scan on _inforg13931 t125_1 (cost=0.00..81.34 rows=1,481 width=36) (never executed)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea))
113. 2.060 2.060 ↓ 0.0 0 412

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t126 (cost=0.41..3.93 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=412)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t120._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=1236
114. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t126_1 (cost=0.41..192.24 rows=45 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
115. 2.975 13.596 ↑ 1.0 1 412

Nested Loop Semi Join (cost=13.11..47.13 rows=1 width=45) (actual time=0.032..0.033 rows=1 loops=412)

  • Join Filter: ((CASE WHEN (alternatives: SubPlan 24 or hashed SubPlan 25) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 26 or hashed SubPlan 27) THEN true ELSE false END) AND (CASE WHEN (SubPlan 21) THEN true ELSE fal (...)
  • Buffers: shared hit=5401
116. 2.472 2.472 ↑ 1.0 1 412

Index Scan using _reference84hpk on _reference84 t109 (cost=0.42..0.63 rows=1 width=79) (actual time=0.006..0.006 rows=1 loops=412)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t65._fld10729_rrref = _idrref))
  • Buffers: shared hit=1128
117. 0.000 0.000 ↑ 1.0 1 281

Materialize (cost=12.69..23.29 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=281)

  • Buffers: shared hit=21
118. 0.001 0.033 ↑ 1.0 1 1

Nested Loop (cost=12.69..23.29 rows=1 width=17) (actual time=0.033..0.033 rows=1 loops=1)

  • Buffers: shared hit=21
119. 0.001 0.029 ↑ 1.0 1 1

Nested Loop (cost=12.42..22.99 rows=1 width=38) (actual time=0.029..0.029 rows=1 loops=1)

  • Buffers: shared hit=17
120. 0.006 0.006 ↑ 1.0 1 1

Index Only Scan using _reference105_byfield2798_sr on _reference105 t112 (cost=0.41..3.92 rows=1 width=20) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (_fld2789 = 'Справочник.ДоговорыКонтрагентов'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=4
121. 0.002 0.022 ↑ 1.0 1 1

Nested Loop (cost=12.01..19.05 rows=1 width=57) (actual time=0.022..0.022 rows=1 loops=1)

  • Buffers: shared hit=13
122. 0.004 0.016 ↑ 1.0 1 1

HashAggregate (cost=11.59..11.60 rows=1 width=19) (actual time=0.016..0.016 rows=1 loops=1)

  • Group Key: t113._reference73_idrref
  • Buffers: shared hit=8
123. 0.002 0.012 ↓ 2.0 2 1

Nested Loop (cost=0.56..11.59 rows=1 width=19) (actual time=0.012..0.012 rows=2 loops=1)

  • Buffers: shared hit=8
124. 0.006 0.006 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t114 (cost=0.28..3.83 rows=2 width=24) (actual time=0.005..0.006 rows=2 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AND (_fld14728_rrref = '\\336\\2220Z:wN\\241\\021\\350h\\2 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
125. 0.004 0.004 ↑ 3.0 1 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t113 (cost=0.28..3.85 rows=3 width=49) (actual time=0.002..0.002 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t114._fld14727_type) AND (_fld2105_rtref = t114._fld14727_rtref) AND (_fld2105_rrref = t114._fld14727_rrref))
  • Heap Fetches: 0
  • Buffers: shared hit=5
126. 0.004 0.004 ↑ 1.0 1 1

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t111 (cost=0.42..7.44 rows=1 width=38) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t113._reference73_idrref) AND (_fld14846rref = t112._idrref))
  • Heap Fetches: 1
  • Buffers: shared hit=5
127. 0.003 0.003 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t110 (cost=0.27..0.29 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t111._fld14847rref))
  • Heap Fetches: 1
  • Buffers: shared hit=4
128.          

SubPlan (forNested Loop Semi Join)

129. 1.405 1.405 ↓ 0.0 0 281

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t118 (cost=0.41..3.93 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=281)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea) AND (_fld13933_rrref = t109._fld2181rref) AND (_fld13932rref = t110._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=843
130. 0.000 0.000 ↓ 0.0 0

Seq Scan on _inforg13931 t118_1 (cost=0.00..81.34 rows=1,481 width=36) (never executed)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea))
131. 0.843 0.843 ↓ 0.0 0 281

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t119 (cost=0.41..3.93 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=281)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t110._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=843
132. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t119_1 (cost=0.41..192.24 rows=45 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
133. 0.562 5.058 ↑ 1.0 1 281

Nested Loop (cost=0.83..11.39 rows=1 width=0) (actual time=0.018..0.018 rows=1 loops=281)

  • Buffers: shared hit=1722
134. 2.810 2.810 ↑ 1.0 1 281

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t116 (cost=0.42..7.45 rows=1 width=24) (actual time=0.010..0.010 rows=1 loops=281)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = '\\010'::bytea) AND (_fld13762_rtref = '\\000\\000\\000\\242'::bytea) AND (_fld13762_rrref = t109._fld2175rref))
  • Heap Fetches: 32
  • Buffers: shared hit=878
135. 1.686 1.686 ↑ 1.0 1 281

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t115 (cost=0.41..3.93 rows=1 width=27) (actual time=0.006..0.006 rows=1 loops=281)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t116._fld13763_type) AND (_fld13933_rtref = t116._fld13763_rtref) AND (_fld13933_rrref = t116._fld13763_rrref) AND (_fld13932rref = t110._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=844
136. 0.843 0.843 ↑ 1.0 1 281

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t117 (cost=0.41..3.93 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=281)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t110._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=844
137. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t117_1 (cost=0.41..192.24 rows=45 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
Planning time : 59.858 ms
Execution time : 134,086.583 ms