explain.depesz.com

PostgreSQL's explain analyze made readable

Result: miQH

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.051 ↓ 0.0 0 1

Limit (cost=358,682.16..358,682.25 rows=1 width=354) (actual time=0.051..0.051 rows=0 loops=1)

  • Buffers: shared hit=3
2. 0.000 0.048 ↓ 0.0 0 1

Group (cost=358,682.16..358,682.25 rows=1 width=354) (actual time=0.048..0.048 rows=0 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=3
3. 0.029 0.048 ↓ 0.0 0 1

Sort (cost=358,682.16..358,682.16 rows=1 width=354) (actual time=0.048..0.048 rows=0 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: 25kB
  • Buffers: shared hit=3
4. 0.001 0.019 ↓ 0.0 0 1

Nested Loop Left Join (cost=179,311.33..358,682.15 rows=1 width=354) (actual time=0.019..0.019 rows=0 loops=1)

  • Join Filter: ((t65._fld10729_type = '\\010'::bytea) AND (t65._fld10729_rtref = '\\000\\000\\000T'::bytea))
  • Buffers: shared hit=3
5. 0.000 0.018 ↓ 0.0 0 1

Nested Loop Semi Join (cost=179,298.22..358,627.94 rows=1 width=339) (actual time=0.018..0.018 rows=0 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=3
6. 0.000 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=179,285.52..358,593.26 rows=1 width=339) (actual time=0.018..0.018 rows=0 loops=1)

  • Buffers: shared hit=3
7. 0.000 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=179,285.11..358,524.84 rows=1 width=339) (actual time=0.018..0.018 rows=0 loops=1)

  • Join Filter: (t64._fld10695rref = t94._idrref)
  • Buffers: shared hit=3
8. 0.000 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=179,285.11..358,519.69 rows=1 width=322) (actual time=0.018..0.018 rows=0 loops=1)

  • Join Filter: (t75._fld20116_rrref = t64._idrref)
  • Filter: (t75._document361_idrref IS NULL)
  • Buffers: shared hit=3
9. 0.002 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=13.97..50.36 rows=1 width=322) (actual time=0.018..0.018 rows=0 loops=1)

  • Buffers: shared hit=3
10. 0.016 0.016 ↓ 0.0 0 1

Index Scan using _document357_bydocdate_trl on _document357 t64 (cost=0.42..7.45 rows=1 width=298) (actual time=0.016..0.016 rows=0 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=3
11. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=13.54..42.90 rows=1 width=41) (never executed)

  • 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)
12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..8.22 rows=1 width=58) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using _document357_vt10724_intkeyind on _document357_vt10724 t65 (cost=0.42..7.44 rows=1 width=44) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_document357_idrref = t64._idrref))
14. 0.000 0.000 ↓ 0.0 0

Index Scan using _document357hpk on _document357 t67 (cost=0.42..0.76 rows=1 width=37) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t65._document357_idrref))
15. 0.000 0.000 ↓ 0.0 0

Materialize (cost=12.69..23.30 rows=1 width=17) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.69..23.29 rows=1 width=17) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.42..22.99 rows=1 width=38) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference105_byfield2798_sr on _reference105 t70 (cost=0.41..7.42 rows=1 width=20) (never executed)

  • Index Cond: (_fld2789 = 'Документ.ПриходныйКассовыйОрдер'::mvarchar)
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.02..15.56 rows=1 width=57) (never executed)

20. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.60..11.61 rows=1 width=19) (never executed)

  • Group Key: t71._reference73_idrref
21. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..11.60 rows=1 width=19) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t72 (cost=0.28..3.83 rows=2 width=24) (never executed)

  • 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
23. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t71 (cost=0.28..3.85 rows=3 width=49) (never executed)

  • 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
24. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t69 (cost=0.42..3.94 rows=1 width=38) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t71._reference73_idrref) AND (_fld14846rref = t70._idrref))
  • Heap Fetches: 0
25. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73hpk on _reference73 t68 (cost=0.27..0.29 rows=1 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t69._fld14847rref))
  • Heap Fetches: 0
26.          

SubPlan (forNested Loop Semi Join)

27. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t73 (cost=0.41..7.43 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 = t67._fld10697rref) AND (_fld13932rref = (...)
  • Heap Fetches: 0
28. 0.000 0.000 ↓ 0.0 0

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

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

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

  • 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
30. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t74_1 (cost=0.41..191.27 rows=43 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. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=179,271.14..358,405.97 rows=5,069 width=38) (never executed)

  • Hash Cond: (t86._idrref = t75._document361_idrref)
32. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=12.69..178,143.29 rows=7,784 width=17) (never executed)

  • 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)
33. 0.000 0.000 ↓ 0.0 0

Seq Scan on _document361 t86 (cost=0.00..924.59 rows=15,567 width=34) (never executed)

  • Filter: (_posted AND (_fld717 = '0'::numeric))
34. 0.000 0.000 ↓ 0.0 0

Materialize (cost=12.69..27.32 rows=1 width=17) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=12.69..27.32 rows=1 width=17) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.27..19.86 rows=1 width=56) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.00..19.04 rows=1 width=39) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference105_byfield2798_sr on _reference105 t87 (cost=0.41..7.42 rows=1 width=20) (never executed)

  • Index Cond: (_fld2789 = 'Документ.РаспоряжениеНаПеремещениеДенежныхСредств'::mvarchar)
  • Heap Fetches: 0
39. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.60..11.61 rows=1 width=19) (never executed)

  • Group Key: t90._reference73_idrref
40. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..11.60 rows=1 width=19) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t91 (cost=0.28..3.83 rows=2 width=24) (never executed)

  • 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
42. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t90 (cost=0.28..3.85 rows=3 width=49) (never executed)

  • 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
43. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73hpk on _reference73 t88 (cost=0.27..0.80 rows=1 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t90._reference73_idrref))
  • Heap Fetches: 0
44. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t89 (cost=0.42..3.94 rows=1 width=38) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t88._idrref) AND (_fld14846rref = t87._idrref))
  • Heap Fetches: 0
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..7.43 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. 0.000 0.000 ↓ 0.0 0

Seq Scan on _inforg13931 t92_1 (cost=0.00..83.12 rows=1,542 width=36) (never executed)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea))
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.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t93_1 (cost=0.41..191.27 rows=43 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
50. 0.000 0.000 ↓ 0.0 0

Hash (cost=179,131.74..179,131.74 rows=10,137 width=55) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=178,240.59..179,131.74 rows=10,137 width=55) (never executed)

  • Hash Cond: (t75._document361_idrref = t77._idrref)
52. 0.000 0.000 ↓ 0.0 0

Seq Scan on _document361_vt20114 t75 (cost=0.00..713.76 rows=20,272 width=41) (never executed)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld20116_type = '\\010'::bytea) AND (_fld20116_rtref = '\\000\\000\\001e'::bytea))
53. 0.000 0.000 ↓ 0.0 0

Hash (cost=178,143.29..178,143.29 rows=7,784 width=20) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=12.69..178,143.29 rows=7,784 width=20) (never executed)

  • 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)
55. 0.000 0.000 ↓ 0.0 0

Seq Scan on _document361 t77 (cost=0.00..924.59 rows=15,567 width=37) (never executed)

  • Filter: (_fld717 = '0'::numeric)
56. 0.000 0.000 ↓ 0.0 0

Materialize (cost=12.69..27.32 rows=1 width=17) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=12.69..27.32 rows=1 width=17) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.27..19.86 rows=1 width=56) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.00..19.04 rows=1 width=39) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference105_byfield2798_sr on _reference105 t78 (cost=0.41..7.42 rows=1 width=20) (never executed)

  • Index Cond: (_fld2789 = 'Документ.РаспоряжениеНаПеремещениеДенежныхСредств'::mvarchar)
  • Heap Fetches: 0
61. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.60..11.61 rows=1 width=19) (never executed)

  • Group Key: t81._reference73_idrref
62. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..11.60 rows=1 width=19) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t82 (cost=0.28..3.83 rows=2 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AND (_fld1 (...)
  • Heap Fetches: 0
64. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t81 (cost=0.28..3.85 rows=3 width=49) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t82._fld14727_type) AND (_fld2105_rtref = t82._fld14727_rtref) AND (_fld2105_rrre (...)
  • Heap Fetches: 0
65. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73hpk on _reference73 t79 (cost=0.27..0.80 rows=1 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t81._reference73_idrref))
  • Heap Fetches: 0
66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t80 (cost=0.42..3.94 rows=1 width=38) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t79._idrref) AND (_fld14846rref = t78._idrref))
  • Heap Fetches: 0
67.          

SubPlan (forNested Loop Semi Join)

68. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t83 (cost=0.41..7.43 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
69. 0.000 0.000 ↓ 0.0 0

Seq Scan on _inforg13931 t83_1 (cost=0.00..83.12 rows=1,542 width=36) (never executed)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\002\\274'::bytea))
70. 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
71. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t84_1 (cost=0.41..191.27 rows=43 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
72. 0.000 0.000 ↓ 0.0 0

Seq Scan on _reference109 t94 (cost=0.00..4.08 rows=86 width=34) (never executed)

  • Filter: (_fld717 = '0'::numeric)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using _document365hpk on _document365 t96 (cost=0.41..68.42 rows=1 width=34) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t64._fld10704rref = _idrref))
  • Filter: (SubPlan 20)
74.          

SubPlan (forIndex Scan)

75. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=13.10..60.98 rows=1 width=0) (never executed)

  • 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 (...)
76. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.41..7.46 rows=1 width=17) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=4) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Index Scan using _document365_vt11021_intkeyind on _document365_vt11021 t97 (cost=0.41..7.43 rows=1 width=17) (never executed)

  • Index Cond: ((_fld717 = t96._fld717) AND (t96._idrref = _document365_idrref))
79. 0.000 0.000 ↓ 0.0 0

Materialize (cost=12.69..34.67 rows=1 width=17) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.69..34.66 rows=1 width=17) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.42..22.99 rows=1 width=38) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference105_byfield2798_sr on _reference105 t100 (cost=0.41..7.42 rows=1 width=20) (never executed)

  • Index Cond: (_fld2789 = 'Документ.РасходныйКассовыйОрдер'::mvarchar)
  • Heap Fetches: 0
83. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.02..15.56 rows=1 width=57) (never executed)

84. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.60..11.61 rows=1 width=19) (never executed)

  • Group Key: t101._reference73_idrref
85. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..11.60 rows=1 width=19) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t102 (cost=0.28..3.83 rows=2 width=24) (never executed)

  • 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
87. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t101 (cost=0.28..3.85 rows=3 width=49) (never executed)

  • 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
88. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t99 (cost=0.42..3.94 rows=1 width=38) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t101._reference73_idrref) AND (_fld14846rref = t100._idrref))
  • Heap Fetches: 0
89. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73hpk on _reference73 t98 (cost=0.27..11.66 rows=1 width=17) (never executed)

  • 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: 0
90.          

SubPlan (forIndex Only Scan)

91. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t103 (cost=0.41..7.43 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 = t96._fld10987rref) AND (_fld139 (...)
  • Heap Fetches: 0
92. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t103_1 (cost=0.41..9.14 rows=8 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
93. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t104 (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 = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\002\\274'::byt (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
94. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t104_1 (cost=0.41..191.27 rows=43 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
95.          

SubPlan (forNested Loop Semi Join)

96. 0.000 0.000 ↓ 0.0 0

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

97. 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
98. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t105 (cost=0.41..7.43 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
99. 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
100. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
101. 0.000 0.000 ↓ 0.0 0

Materialize (cost=12.69..23.30 rows=1 width=17) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.69..23.29 rows=1 width=17) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.42..22.99 rows=1 width=38) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference105_byfield2798_sr on _reference105 t122 (cost=0.41..7.42 rows=1 width=20) (never executed)

  • Index Cond: (_fld2789 = 'Документ.ПриходныйКассовыйОрдер'::mvarchar)
  • Heap Fetches: 0
105. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.02..15.56 rows=1 width=57) (never executed)

106. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.60..11.61 rows=1 width=19) (never executed)

  • Group Key: t123._reference73_idrref
107. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..11.60 rows=1 width=19) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t124 (cost=0.28..3.83 rows=2 width=24) (never executed)

  • 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
109. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t123 (cost=0.28..3.85 rows=3 width=49) (never executed)

  • 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
110. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t121 (cost=0.42..3.94 rows=1 width=38) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t123._reference73_idrref) AND (_fld14846rref = t122._idrref))
  • Heap Fetches: 0
111. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73hpk on _reference73 t120 (cost=0.27..0.29 rows=1 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t121._fld14847rref))
  • Heap Fetches: 0
112.          

SubPlan (forNested Loop Semi Join)

113. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t125 (cost=0.41..7.43 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 = t64._fld10697rref) AND (_fld13932rref = t120._idrref))
  • Heap Fetches: 0
114. 0.000 0.000 ↓ 0.0 0

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

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

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

  • 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
116. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t126_1 (cost=0.41..191.27 rows=43 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
117. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=13.11..54.14 rows=1 width=45) (never executed)

  • 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 (...)
118. 0.000 0.000 ↓ 0.0 0

Index Scan using _reference84hpk on _reference84 t109 (cost=0.42..0.63 rows=1 width=79) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t65._fld10729_rrref = _idrref))
119. 0.000 0.000 ↓ 0.0 0

Materialize (cost=12.69..23.30 rows=1 width=17) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.69..23.29 rows=1 width=17) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.42..22.99 rows=1 width=38) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference105_byfield2798_sr on _reference105 t112 (cost=0.41..7.42 rows=1 width=20) (never executed)

  • Index Cond: (_fld2789 = 'Справочник.ДоговорыКонтрагентов'::mvarchar)
  • Heap Fetches: 0
123. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.02..15.56 rows=1 width=57) (never executed)

124. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=11.60..11.61 rows=1 width=19) (never executed)

  • Group Key: t113._reference73_idrref
125. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..11.60 rows=1 width=19) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t114 (cost=0.28..3.83 rows=2 width=24) (never executed)

  • 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
127. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t113 (cost=0.28..3.85 rows=3 width=49) (never executed)

  • 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
128. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t111 (cost=0.42..3.94 rows=1 width=38) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t113._reference73_idrref) AND (_fld14846rref = t112._idrref))
  • Heap Fetches: 0
129. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73hpk on _reference73 t110 (cost=0.27..0.29 rows=1 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t111._fld14847rref))
  • Heap Fetches: 0
130.          

SubPlan (forNested Loop Semi Join)

131. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t118 (cost=0.41..7.43 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 = t109._fld2181rref) AND (_fld13932rref = t110._idrref))
  • Heap Fetches: 0
132. 0.000 0.000 ↓ 0.0 0

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

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

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

  • 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
134. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t119_1 (cost=0.41..191.27 rows=43 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
135. 0.000 0.000 ↓ 0.0 0

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

136. 0.000 0.000 ↓ 0.0 0

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

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

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

  • 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
138. 0.000 0.000 ↓ 0.0 0

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

  • 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
139. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t117_1 (cost=0.41..191.27 rows=43 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 : 65.418 ms
Execution time : 2.226 ms