explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TPac

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 127,313.685 ↓ 40.0 40 1

Limit (cost=116,346.79..116,346.88 rows=1 width=354) (actual time=127,313.664..127,313.685 rows=40 loops=1)

  • Buffers: shared hit=4836701 dirtied=3
2. 0.020 127,313.684 ↓ 40.0 40 1

Group (cost=116,346.79..116,346.88 rows=1 width=354) (actual time=127,313.663..127,313.684 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=4836701 dirtied=3
3. 2.730 127,313.664 ↓ 40.0 40 1

Sort (cost=116,346.79..116,346.80 rows=1 width=354) (actual time=127,313.662..127,313.664 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: 661kB
  • Buffers: shared hit=4836701 dirtied=3
4. 13.185 127,310.934 ↓ 1,235.0 1,235 1

Nested Loop Left Join (cost=58,603.83..116,346.78 rows=1 width=354) (actual time=1,163.200..127,310.934 rows=1,235 loops=1)

  • Join Filter: ((t65._fld10729_type = '\\010'::bytea) AND (t65._fld10729_rtref = '\\000\\000\\000T'::bytea))
  • Buffers: shared hit=4836671 dirtied=3
5. 7.017 127,224.884 ↓ 1,235.0 1,235 1

Nested Loop Semi Join (cost=58,597.32..116,326.10 rows=1 width=339) (actual time=1,162.947..127,224.884 rows=1,235 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=4815525 dirtied=3
6. 3.708 127,200.577 ↓ 1,235.0 1,235 1

Nested Loop Left Join (cost=58,591.23..116,312.53 rows=1 width=339) (actual time=1,162.843..127,200.577 rows=1,235 loops=1)

  • Buffers: shared hit=4808094 dirtied=3
7. 12.427 127,182.049 ↓ 1,235.0 1,235 1

Nested Loop Left Join (cost=58,590.82..116,286.31 rows=1 width=339) (actual time=1,162.802..127,182.049 rows=1,235 loops=1)

  • Join Filter: (t64._fld10695rref = t94._idrref)
  • Rows Removed by Join Filter: 118560
  • Buffers: shared hit=4803396 dirtied=3
8. 15,860.628 127,136.277 ↓ 1,235.0 1,235 1

Nested Loop Left Join (cost=58,590.82..116,280.88 rows=1 width=322) (actual time=1,162.759..127,136.277 rows=1,235 loops=1)

  • Join Filter: (t75._fld20116_rrref = t64._idrref)
  • Rows Removed by Join Filter: 253540249
  • Filter: (t75._document361_idrref IS NULL)
  • Rows Removed by Filter: 5103
  • Buffers: shared hit=4799691 dirtied=3
9. 23.093 303.607 ↓ 6,338.0 6,338 1

Nested Loop Left Join (cost=7.36..20.26 rows=1 width=322) (actual time=0.598..303.607 rows=6,338 loops=1)

  • Buffers: shared hit=88788 dirtied=3
10. 14.318 14.318 ↓ 6,338.0 6,338 1

Index Scan using _document357_bydocdate_trl on _document357 t64 (cost=0.42..3.05 rows=1 width=298) (actual time=0.069..14.318 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=1224
11. 45.938 266.196 ↑ 1.0 1 6,338

Nested Loop Semi Join (cost=6.94..17.19 rows=1 width=41) (actual time=0.039..0.042 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=87564 dirtied=3
12. 20.193 145.774 ↑ 1.0 1 6,338

Nested Loop (cost=0.85..3.62 rows=1 width=58) (actual time=0.020..0.023 rows=1 loops=6,338)

  • Buffers: shared hit=50301 dirtied=3
13. 69.718 69.718 ↑ 1.0 1 6,338

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

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

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

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

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

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

Nested Loop (cost=6.09..10.09 rows=1 width=17) (actual time=0.318..0.318 rows=1 loops=1)

  • Buffers: shared hit=21
17. 0.001 0.272 ↑ 1.0 1 1

Nested Loop (cost=5.82..9.79 rows=1 width=38) (actual time=0.272..0.272 rows=1 loops=1)

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

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

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

Nested Loop (cost=5.41..8.05 rows=1 width=57) (actual time=0.198..0.198 rows=1 loops=1)

  • Buffers: shared hit=13
20. 0.006 0.121 ↑ 1.0 1 1

HashAggregate (cost=5.00..5.00 rows=1 width=19) (actual time=0.121..0.121 rows=1 loops=1)

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

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

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

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t72 (cost=0.28..1.63 rows=2 width=24) (actual time=0.051..0.052 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.058 0.058 ↑ 3.0 1 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t71 (cost=0.28..1.65 rows=3 width=49) (actual time=0.029..0.029 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.074 0.074 ↑ 1.0 1 1

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t69 (cost=0.42..3.04 rows=1 width=38) (actual time=0.074..0.074 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.044 0.044 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t68 (cost=0.27..0.29 rows=1 width=17) (actual time=0.044..0.044 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..1.73 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..1.74 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..82.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,909.037 110,972.042 ↓ 4.2 40,004 6,338

Hash Join (cost=58,583.45..116,142.24 rows=9,471 width=38) (actual time=1.457..17.509 rows=40,004 loops=6,338)

  • Hash Cond: (t86._idrref = t75._document361_idrref)
  • Buffers: shared hit=4710903
32. 32,708.323 65,997.594 ↓ 2.0 15,997 6,338

Nested Loop Semi Join (cost=6.09..56,532.51 rows=7,980 width=17) (actual time=0.003..10.413 rows=15,997 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=4709290
33. 33,287.176 33,287.176 ↓ 1.0 15,997 6,338

Seq Scan on _document361 t86 (cost=0.00..942.49 rows=15,959 width=34) (actual time=0.002..5.252 rows=15,997 loops=6,338)

  • Filter: (_posted AND (_fld717 = '0'::numeric))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4709134
34. 0.000 0.000 ↑ 1.0 1 101,388,986

Materialize (cost=6.09..12.81 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=101,388,986)

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

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

  • Buffers: shared hit=21
36. 0.004 0.042 ↑ 1.0 1 1

Nested Loop (cost=5.67..7.14 rows=1 width=56) (actual time=0.042..0.042 rows=1 loops=1)

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

Nested Loop (cost=5.40..6.74 rows=1 width=39) (actual time=0.035..0.035 rows=1 loops=1)

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

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

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

HashAggregate (cost=5.00..5.00 rows=1 width=19) (actual time=0.024..0.024 rows=1 loops=1)

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

Nested Loop (cost=0.56..4.99 rows=1 width=19) (actual time=0.021..0.022 rows=2 loops=1)

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

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t91 (cost=0.28..1.63 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 = '\\33 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
42. 0.010 0.010 ↑ 3.0 1 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t90 (cost=0.28..1.65 rows=3 width=49) (actual time=0.005..0.005 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.003 0.003 ↑ 1.0 1 1

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

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

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t89 (cost=0.42..3.04 rows=1 width=38) (actual time=0.021..0.021 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..1.73 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.230 1.230 ↑ 1.0 1,481 1

Seq Scan on _inforg13931 t92_1 (cost=0.00..81.34 rows=1,481 width=36) (actual time=0.020..1.230 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..1.74 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.865 0.865 ↓ 1.5 68 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t93_1 (cost=0.41..82.24 rows=45 width=17) (actual time=0.153..0.865 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. 8.997 65.411 ↓ 2.1 40,054 1

Hash (cost=58,340.60..58,340.60 rows=18,941 width=55) (actual time=65.411..65.411 rows=40,054 loops=1)

  • Buckets: 65536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 3759kB
  • Buffers: shared hit=1613
51. 11.068 56.414 ↓ 2.1 40,054 1

Hash Join (cost=56,632.26..58,340.60 rows=18,941 width=55) (actual time=26.202..56.414 rows=40,054 loops=1)

  • Hash Cond: (t75._document361_idrref = t77._idrref)
  • Buffers: shared hit=1613
52. 19.188 19.188 ↓ 1.1 40,054 1

Seq Scan on _document361_vt20114 t75 (cost=0.00..1,376.88 rows=37,879 width=41) (actual time=0.016..19.188 rows=40,054 loops=1)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld20116_type = '\\010'::bytea) AND (_fld20116_rtref = '\\000\\000\\001e'::bytea))
  • Buffers: shared hit=714
53. 3.669 26.158 ↓ 2.0 15,998 1

Hash (cost=56,532.51..56,532.51 rows=7,980 width=20) (actual time=26.158..26.158 rows=15,998 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 941kB
  • Buffers: shared hit=899
54. 9.580 22.489 ↓ 2.0 15,998 1

Nested Loop Semi Join (cost=6.09..56,532.51 rows=7,980 width=20) (actual time=1.842..22.489 rows=15,998 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=899
55. 11.676 11.676 ↓ 1.0 15,998 1

Seq Scan on _document361 t77 (cost=0.00..942.49 rows=15,959 width=37) (actual time=0.006..11.676 rows=15,998 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=743
56. 0.000 0.000 ↑ 1.0 1 15,998

Materialize (cost=6.09..12.81 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=15,998)

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

Nested Loop Semi Join (cost=6.09..12.81 rows=1 width=17) (actual time=0.072..0.072 rows=1 loops=1)

  • Buffers: shared hit=21
58. 0.002 0.058 ↑ 1.0 1 1

Nested Loop (cost=5.67..7.14 rows=1 width=56) (actual time=0.058..0.058 rows=1 loops=1)

  • Buffers: shared hit=16
59. 0.002 0.047 ↑ 1.0 1 1

Nested Loop (cost=5.40..6.74 rows=1 width=39) (actual time=0.047..0.047 rows=1 loops=1)

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

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

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

HashAggregate (cost=5.00..5.00 rows=1 width=19) (actual time=0.032..0.032 rows=1 loops=1)

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

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

  • Buffers: shared hit=8
  • -> Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t82 (cost=0.28..1.63 rows=2 width=24) (actual time=0.011..0.011 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..1.65 rows=3 width=49) (actual time=0.007..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.009 0.009 ↑ 1.0 1 1

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

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

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t80 (cost=0.42..3.04 rows=1 width=38) (actual time=0.010..0.010 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..1.73 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. 0.972 0.972 ↑ 1.0 1,481 1

Seq Scan on _inforg13931 t83_1 (cost=0.00..81.34 rows=1,481 width=36) (actual time=0.008..0.972 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..1.74 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.261 0.261 ↓ 1.5 68 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t84_1 (cost=0.41..82.24 rows=45 width=17) (actual time=0.045..0.261 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. 33.345 33.345 ↑ 1.0 97 1,235

Seq Scan on _reference109 t94 (cost=0.00..4.21 rows=97 width=34) (actual time=0.003..0.027 rows=97 loops=1,235)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=3705
71. 11.292 14.820 ↓ 0.0 0 1,235

Index Scan using _document365hpk on _document365 t96 (cost=0.41..26.21 rows=1 width=34) (actual time=0.012..0.012 rows=0 loops=1,235)

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

SubPlan (forIndex Scan)

73. 0.294 3.528 ↑ 1.0 1 49

Nested Loop Semi Join (cost=6.50..23.18 rows=1 width=0) (actual time=0.072..0.072 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.098 0.490 ↑ 1.0 1 49

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

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

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

76. 0.392 0.392 ↓ 0.0 0 49

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

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

Materialize (cost=6.09..13.56 rows=1 width=17) (actual time=0.056..0.056 rows=1 loops=49)

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

Nested Loop (cost=6.09..13.56 rows=1 width=17) (actual time=0.053..0.053 rows=1 loops=49)

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

Nested Loop (cost=5.82..9.79 rows=1 width=38) (actual time=0.026..0.026 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..1.72 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.637 ↑ 1.0 1 49

Nested Loop (cost=5.41..8.05 rows=1 width=57) (actual time=0.013..0.013 rows=1 loops=49)

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

HashAggregate (cost=5.00..5.00 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.008 0.027 ↓ 2.0 2 1

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

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

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t102 (cost=0.28..1.63 rows=2 width=24) (actual time=0.009..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: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..1.65 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.441 0.441 ↑ 1.0 1 49

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t99 (cost=0.42..3.04 rows=1 width=38) (actual time=0.009..0.009 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.539 1.176 ↑ 1.0 1 49

Index Only Scan using _reference73hpk on _reference73 t98 (cost=0.27..3.76 rows=1 width=17) (actual time=0.024..0.024 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..1.73 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..1.88 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.294 0.294 ↓ 0.0 0 49

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t104 (cost=0.41..1.74 rows=1 width=0) (actual time=0.006..0.006 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..82.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..4.79 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..3.05 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..1.73 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..1.74 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..87.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 1,235

Materialize (cost=6.09..10.09 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=1,235)

  • Buffers: shared hit=21
100. 0.003 0.069 ↑ 1.0 1 1

Nested Loop (cost=6.09..10.09 rows=1 width=17) (actual time=0.069..0.069 rows=1 loops=1)

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

Nested Loop (cost=5.82..9.79 rows=1 width=38) (actual time=0.059..0.059 rows=1 loops=1)

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

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

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

Nested Loop (cost=5.41..8.05 rows=1 width=57) (actual time=0.043..0.043 rows=1 loops=1)

  • Buffers: shared hit=13
104. 0.005 0.030 ↑ 1.0 1 1

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

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

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

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

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t124 (cost=0.28..1.63 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 = '\\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..1.65 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.010 0.010 ↑ 1.0 1 1

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t121 (cost=0.42..3.04 rows=1 width=38) (actual time=0.010..0.010 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.007 0.007 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t120 (cost=0.27..0.29 rows=1 width=17) (actual time=0.007..0.007 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. 9.880 9.880 ↓ 0.0 0 1,235

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t125 (cost=0.41..1.73 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1,235)

  • 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=3705
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. 7.410 7.410 ↓ 0.0 0 1,235

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t126 (cost=0.41..1.74 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1,235)

  • 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=3705
114. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t126_1 (cost=0.41..82.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. 12.968 72.865 ↑ 1.0 1 1,235

Nested Loop Semi Join (cost=6.51..20.61 rows=1 width=45) (actual time=0.059..0.059 rows=1 loops=1,235)

  • 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=21146
116. 23.465 23.465 ↑ 1.0 1 1,235

Index Scan using _reference84hpk on _reference84 t109 (cost=0.42..0.51 rows=1 width=79) (actual time=0.019..0.019 rows=1 loops=1,235)

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

Materialize (cost=6.09..10.09 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=1,104)

  • Buffers: shared hit=21
118. 0.002 0.059 ↑ 1.0 1 1

Nested Loop (cost=6.09..10.09 rows=1 width=17) (actual time=0.059..0.059 rows=1 loops=1)

  • Buffers: shared hit=21
119. 0.003 0.055 ↑ 1.0 1 1

Nested Loop (cost=5.82..9.79 rows=1 width=38) (actual time=0.055..0.055 rows=1 loops=1)

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

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

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

Nested Loop (cost=5.41..8.05 rows=1 width=57) (actual time=0.047..0.047 rows=1 loops=1)

  • Buffers: shared hit=13
122. 0.002 0.017 ↑ 1.0 1 1

HashAggregate (cost=5.00..5.00 rows=1 width=19) (actual time=0.017..0.017 rows=1 loops=1)

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

Nested Loop (cost=0.56..4.99 rows=1 width=19) (actual time=0.014..0.015 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..1.63 rows=2 width=24) (actual time=0.004..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..1.65 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.026 0.026 ↑ 1.0 1 1

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t111 (cost=0.42..3.04 rows=1 width=38) (actual time=0.026..0.026 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.002 0.002 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t110 (cost=0.27..0.29 rows=1 width=17) (actual time=0.002..0.002 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. 5.520 5.520 ↓ 0.0 0 1,104

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

  • 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=3312
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. 2.208 2.208 ↓ 0.0 0 1,104

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t119 (cost=0.41..1.74 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1,104)

  • 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=3312
132. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t119_1 (cost=0.41..82.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. 3.312 25.392 ↑ 1.0 1 1,104

Nested Loop (cost=0.83..4.79 rows=1 width=0) (actual time=0.023..0.023 rows=1 loops=1,104)

  • Buffers: shared hit=6764
134. 16.560 16.560 ↑ 1.0 1 1,104

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t116 (cost=0.42..3.05 rows=1 width=24) (actual time=0.015..0.015 rows=1 loops=1,104)

  • 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: 132
  • Buffers: shared hit=3451
135. 5.520 5.520 ↑ 1.0 1 1,104

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t115 (cost=0.41..1.73 rows=1 width=27) (actual time=0.005..0.005 rows=1 loops=1,104)

  • 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=3313
136. 3.312 3.312 ↑ 1.0 1 1,104

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

  • 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=3313
137. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t117_1 (cost=0.41..82.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 : 40.512 ms
Execution time : 127,315.455 ms