explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3o2A

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 4,983.133 ↑ 12.0 2 1

Limit (cost=981,852.28..981,852.34 rows=24 width=454) (actual time=4,983.129..4,983.133 rows=2 loops=1)

  • Buffers: shared hit=868697
2. 0.017 4,983.132 ↑ 12.0 2 1

Sort (cost=981,852.28..981,852.34 rows=24 width=454) (actual time=4,983.128..4,983.132 rows=2 loops=1)

  • Sort Key: t1._date_time DESC
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=868697
3. 0.232 4,983.115 ↑ 12.0 2 1

Nested Loop Semi Join (cost=787,756.48..981,851.73 rows=24 width=454) (actual time=4,522.090..4,983.115 rows=2 loops=1)

  • Join Filter: ((CASE WHEN (alternatives: SubPlan 23 or hashed SubPlan 24) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 25 or hashed SubPlan 26) THEN true ELSE false END) OR (CASE WHEN (alternatives: SubPlan 27 or hashed SubPlan (...)
  • Buffers: shared hit=868697
4. 0.006 4,982.489 ↑ 16.0 2 1

Nested Loop Left Join (cost=787,750.39..981,537.36 rows=32 width=462) (actual time=4,521.477..4,982.489 rows=2 loops=1)

  • Buffers: shared hit=868513
5. 0.326 4,982.273 ↑ 16.0 2 1

Nested Loop Semi Join (cost=787,743.88..980,873.56 rows=32 width=445) (actual time=4,521.311..4,982.273 rows=2 loops=1)

  • Join Filter: ((CASE WHEN (alternatives: SubPlan 15 or hashed SubPlan 16) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 17 or hashed SubPlan 18) THEN true ELSE false END) OR (CASE WHEN (alternatives: SubPlan 19 or has (...)
  • Buffers: shared hit=868440
6. 0.007 4,980.867 ↑ 21.0 2 1

Nested Loop Left Join (cost=787,737.79..980,463.77 rows=42 width=445) (actual time=4,519.911..4,980.867 rows=2 loops=1)

  • Buffers: shared hit=868080
7. 0.020 4,980.838 ↑ 21.0 2 1

Nested Loop Left Join (cost=787,737.23..980,428.39 rows=42 width=406) (actual time=4,519.895..4,980.838 rows=2 loops=1)

  • Join Filter: (t2._fld7983 = t19._fld20243)
  • Buffers: shared hit=868070
8. 7.402 4,980.796 ↑ 21.0 2 1

Hash Join (cost=787,736.68..980,325.51 rows=42 width=389) (actual time=4,519.868..4,980.796 rows=2 loops=1)

  • Hash Cond: ((t2._fld17407rref = t5._document300_idrref) AND (t2._fld17352 = t5._fld7862))
  • Buffers: shared hit=868060
9. 13.945 532.922 ↓ 1.0 28,272 1

Nested Loop Left Join (cost=2.10..187,220.92 rows=28,261 width=337) (actual time=0.067..532.922 rows=28,272 loops=1)

  • Join Filter: ((t2._fld7983 = t4._fld15664) AND (t2._fld7979rref = t4._fld15662rref) AND (t2._fld7981rref = t4._fld15663rref))
  • Rows Removed by Join Filter: 571
  • Buffers: shared hit=417148
10. 29.186 349.345 ↓ 1.0 28,272 1

Nested Loop (cost=1.54..102,725.71 rows=28,261 width=332) (actual time=0.052..349.345 rows=28,272 loops=1)

  • Buffers: shared hit=278431
11. 27.586 179.999 ↓ 1.0 28,032 1

Nested Loop (cost=0.99..84,853.56 rows=28,031 width=191) (actual time=0.036..179.999 rows=28,032 loops=1)

  • Buffers: shared hit=137585
12. 40.285 40.285 ↓ 1.0 28,032 1

Index Scan Backward using _document302_bydocdate_trl on _document302 t1 (cost=0.56..16,563.70 rows=28,031 width=137) (actual time=0.022..40.285 rows=28,032 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_date_time >= '2020-01-26 00:00:00'::timestamp without time zone) AND (_date_time <= '2020-02-01 23:59:59'::timestamp without time zone) AND (_ma (...)
  • Filter: (NOT _marked)
  • Buffers: shared hit=25029
13. 112.128 112.128 ↑ 1.0 1 28,032

Index Scan using _document302hpk on _document302 t3 (cost=0.43..2.43 rows=1 width=54) (actual time=0.004..0.004 rows=1 loops=28,032)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t1._idrref))
  • Buffers: shared hit=112556
14. 140.160 140.160 ↑ 1.0 1 28,032

Index Scan using _document302_vt7973_intkeyind on _document302_vt7973 t2 (cost=0.56..0.63 rows=1 width=181) (actual time=0.005..0.005 rows=1 loops=28,032)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_document302_idrref = t3._idrref))
  • Buffers: shared hit=140846
15. 169.632 169.632 ↑ 1.0 1 28,272

Index Scan using _accumrg15660_bydims17975_rtrn on _accumrg15660 t4 (cost=0.56..2.97 rows=1 width=78) (actual time=0.006..0.006 rows=1 loops=28,272)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t1._idrref = _fld15661rref) AND (_recordertref = '\\000\\000\\001W'::bytea))
  • Filter: (_recordkind = '1'::numeric)
  • Buffers: shared hit=138717
16. 0.007 4,440.472 ↑ 2,513.5 2 1

Hash (cost=787,659.17..787,659.17 rows=5,027 width=91) (actual time=4,440.472..4,440.472 rows=2 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 65kB
  • Buffers: shared hit=450912
17. 0.237 4,440.465 ↑ 2,513.5 2 1

Nested Loop Semi Join (cost=6.52..787,659.17 rows=5,027 width=91) (actual time=2,870.765..4,440.465 rows=2 loops=1)

  • 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) AND (CASE WHEN (SubP (...)
  • Buffers: shared hit=450912
18. 0.015 4,439.253 ↑ 10,054.0 2 1

Nested Loop (cost=0.43..560,329.44 rows=20,108 width=125) (actual time=2,869.574..4,439.253 rows=2 loops=1)

  • Buffers: shared hit=450608
19. 4,439.212 4,439.212 ↑ 10,054.0 2 1

Seq Scan on _document300_vt7842 t5 (cost=0.00..510,924.06 rows=20,108 width=77) (actual time=2,869.548..4,439.212 rows=2 loops=1)

  • Filter: ((_fld17168 ~~ '%3293549%'::mvarchar) AND (_fld717 = '0'::numeric))
  • Rows Removed by Filter: 4074927
  • Buffers: shared hit=450600
20. 0.026 0.026 ↑ 1.0 1 2

Index Scan using _document300hpk on _document300 t7 (cost=0.43..2.45 rows=1 width=54) (actual time=0.013..0.013 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t5._document300_idrref))
  • Buffers: shared hit=8
21. 0.002 0.108 ↑ 1.0 1 2

Materialize (cost=6.09..8.79 rows=1 width=17) (actual time=0.054..0.054 rows=1 loops=2)

  • Buffers: shared hit=24
22. 0.003 0.106 ↑ 1.0 1 1

Nested Loop (cost=6.09..8.79 rows=1 width=17) (actual time=0.106..0.106 rows=1 loops=1)

  • Buffers: shared hit=24
23. 0.002 0.094 ↑ 1.0 1 1

Nested Loop (cost=5.82..8.49 rows=1 width=37) (actual time=0.094..0.094 rows=1 loops=1)

  • Buffers: shared hit=20
24. 0.016 0.016 ↑ 1.0 1 1

Index Only Scan using _reference105_byfield2798_sr on _reference105 t10 (cost=0.41..1.72 rows=1 width=19) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (_fld2789 = 'Документ.ЗаказКлиента'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=4
25. 0.006 0.076 ↑ 1.0 1 1

Nested Loop (cost=5.41..6.75 rows=1 width=55) (actual time=0.076..0.076 rows=1 loops=1)

  • Buffers: shared hit=16
26. 0.005 0.050 ↓ 2.0 2 1

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

  • Group Key: t11._reference73_idrref
  • Buffers: shared hit=9
27. 0.012 0.045 ↓ 6.0 6 1

Nested Loop (cost=0.56..4.99 rows=1 width=19) (actual time=0.042..0.045 rows=6 loops=1)

  • Buffers: shared hit=9
28. 0.013 0.013 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t12 (cost=0.28..1.63 rows=2 width=24) (actual time=0.011..0.013 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 = 'P\\2 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
29. 0.020 0.020 ↑ 1.0 3 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t11 (cost=0.28..1.65 rows=3 width=49) (actual time=0.009..0.010 rows=3 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t12._fld14727_type) AND (_fld2105_rtref = t12._fld14727_rtref) AND (_fld2105_rrref = t12._fld14727_ (...)
  • Heap Fetches: 0
  • Buffers: shared hit=6
30. 0.020 0.020 ↓ 0.0 0 2

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t9 (cost=0.42..1.74 rows=1 width=36) (actual time=0.010..0.010 rows=0 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t11._reference73_idrref) AND (_fld14846rref = t10._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=7
31. 0.009 0.009 ↑ 1.0 1 1

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

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

SubPlan (for Nested Loop Semi Join)

33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t13 (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\\000\\340'::bytea) AND (_fld13933_rrref = t7._fld7786rref) AND (_fld13932rref = t (...)
  • Heap Fetches: 0
34. 0.220 0.220 ↓ 1.1 281 1

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t13_1 (cost=0.41..32.41 rows=267 width=36) (actual time=0.017..0.220 rows=281 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
  • Heap Fetches: 120
  • Buffers: shared hit=72
35. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg13938_bydims_rr on _inforg13938 t14 (cost=0.41..3.03 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t8._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
36. 0.369 0.369 ↓ 3.6 138 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t14_1 (cost=0.41..79.35 rows=38 width=17) (actual time=0.012..0.369 rows=138 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 109
  • Buffers: shared hit=96
37. 0.012 0.050 ↑ 1.0 1 2

Nested Loop (cost=0.83..3.49 rows=1 width=0) (actual time=0.025..0.025 rows=1 loops=2)

  • Buffers: shared hit=16
38. 0.022 0.022 ↑ 1.0 1 2

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t16 (cost=0.42..1.75 rows=1 width=24) (actual time=0.011..0.011 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = '\\010'::bytea) AND (_fld13762_rtref = '\\000\\000\\000\\242'::bytea) AND (_fld13762_rrref = t7._fld7777rref))
  • Heap Fetches: 0
  • Buffers: shared hit=7
39. 0.016 0.016 ↑ 1.0 1 2

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t15 (cost=0.41..1.73 rows=1 width=27) (actual time=0.008..0.008 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t16._fld13763_type) AND (_fld13933_rtref = t16._fld13763_rtref) AND (_fld13933_rrref = t16._fld13763_rrref) AND (_fld13932rref (...)
  • Heap Fetches: 2
  • Buffers: shared hit=9
40. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg13938_bydims_rr on _inforg13938 t17 (cost=0.41..3.03 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t8._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
41. 0.228 0.228 ↓ 3.9 148 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t17_1 (cost=0.41..79.35 rows=38 width=17) (actual time=0.006..0.228 rows=148 loops=1)

  • 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: 2
  • Buffers: shared hit=96
42. 0.022 0.022 ↑ 1.0 1 2

Index Scan using _inforgs17524_bydims_rn on _inforgsl17524 t19 (cost=0.56..2.44 rows=1 width=38) (actual time=0.011..0.011 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t1._idrref = _fld17495rref))
  • Buffers: shared hit=10
43. 0.022 0.022 ↑ 1.0 1 2

Index Scan using _reference140ng_pkey1 on _reference140 t20 (cost=0.56..0.83 rows=1 width=56) (actual time=0.011..0.011 rows=1 loops=2)

  • Index Cond: (t2._fld7979rref = _idrref)
  • Buffers: shared hit=10
44. 0.002 0.112 ↑ 1.0 1 2

Materialize (cost=6.09..8.79 rows=1 width=17) (actual time=0.056..0.056 rows=1 loops=2)

  • Buffers: shared hit=24
45. 0.003 0.110 ↑ 1.0 1 1

Nested Loop (cost=6.09..8.79 rows=1 width=17) (actual time=0.110..0.110 rows=1 loops=1)

  • Buffers: shared hit=24
46. 0.002 0.098 ↑ 1.0 1 1

Nested Loop (cost=5.82..8.49 rows=1 width=37) (actual time=0.098..0.098 rows=1 loops=1)

  • Buffers: shared hit=20
47. 0.014 0.014 ↑ 1.0 1 1

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

  • Index Cond: (_fld2789 = 'Документ.ЗаказНаПеремещение'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=4
48. 0.016 0.082 ↑ 1.0 1 1

Nested Loop (cost=5.41..6.75 rows=1 width=55) (actual time=0.082..0.082 rows=1 loops=1)

  • Buffers: shared hit=16
49. 0.006 0.046 ↓ 2.0 2 1

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

  • Group Key: t36._reference73_idrref
  • Buffers: shared hit=9
50. 0.007 0.040 ↓ 6.0 6 1

Nested Loop (cost=0.56..4.99 rows=1 width=19) (actual time=0.035..0.040 rows=6 loops=1)

  • Buffers: shared hit=9
51. 0.013 0.013 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t37 (cost=0.28..1.63 rows=2 width=24) (actual time=0.012..0.013 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 = 'P\\2140Z:wL\\341\\021\\347\\024\\2 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
52. 0.020 0.020 ↑ 1.0 3 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t36 (cost=0.28..1.65 rows=3 width=49) (actual time=0.009..0.010 rows=3 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t37._fld14727_type) AND (_fld2105_rtref = t37._fld14727_rtref) AND (_fld2105_rrref = t37._fld14727_rrref))
  • Heap Fetches: 0
  • Buffers: shared hit=6
53. 0.020 0.020 ↓ 0.0 0 2

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t34 (cost=0.42..1.74 rows=1 width=36) (actual time=0.010..0.010 rows=0 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t36._reference73_idrref) AND (_fld14846rref = t35._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=7
54. 0.009 0.009 ↑ 1.0 1 1

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

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

SubPlan (for Nested Loop Semi Join)

56. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t38 (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\\000\\340'::bytea) AND (_fld13933_rrref = t1._fld7965rref) AND (_fld13932rref = t33._idrref))
  • Heap Fetches: 0
57. 0.201 0.201 ↓ 1.1 281 1

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t38_1 (cost=0.41..32.41 rows=267 width=36) (actual time=0.018..0.201 rows=281 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
  • Heap Fetches: 120
  • Buffers: shared hit=72
58. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg13938_bydims_rr on _inforg13938 t39 (cost=0.41..3.03 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t33._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
59. 0.366 0.366 ↓ 3.6 138 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t39_1 (cost=0.41..79.35 rows=38 width=17) (actual time=0.011..0.366 rows=138 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 109
  • Buffers: shared hit=96
60. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t40 (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\\000\\340'::bytea) AND (_fld13933_rrref = t1._fld7966rref) AND (_fld13932rref = t33._idrref))
  • Heap Fetches: 0
61. 0.151 0.151 ↓ 1.1 281 1

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t40_1 (cost=0.41..32.41 rows=267 width=36) (actual time=0.011..0.151 rows=281 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
  • Heap Fetches: 120
  • Buffers: shared hit=72
62. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg13938_bydims_rr on _inforg13938 t41 (cost=0.41..3.03 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t33._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
63. 0.250 0.250 ↓ 3.6 138 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t41_1 (cost=0.41..79.35 rows=38 width=17) (actual time=0.006..0.250 rows=138 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 109
  • Buffers: shared hit=96
64. 0.024 0.210 ↑ 1.0 1 2

Nested Loop Semi Join (cost=6.52..20.73 rows=1 width=34) (actual time=0.104..0.105 rows=1 loops=2)

  • Join Filter: ((CASE WHEN (alternatives: SubPlan 8 or hashed SubPlan 9) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 10 or hashed SubPlan 11) THEN true ELSE false END) AND (CASE WHEN (SubPlan 12) THEN true ELSE false (...)
  • Buffers: shared hit=73
65. 0.022 0.022 ↑ 1.0 1 2

Index Scan using _document300hpk on _document300 t22 (cost=0.43..0.64 rows=1 width=68) (actual time=0.010..0.011 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t2._fld17407rref = _idrref))
  • Buffers: shared hit=8
66. 0.001 0.070 ↑ 1.0 1 2

Materialize (cost=6.09..8.79 rows=1 width=17) (actual time=0.035..0.035 rows=1 loops=2)

  • Buffers: shared hit=24
67. 0.003 0.069 ↑ 1.0 1 1

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

  • Buffers: shared hit=24
68. 0.002 0.061 ↑ 1.0 1 1

Nested Loop (cost=5.82..8.49 rows=1 width=37) (actual time=0.061..0.061 rows=1 loops=1)

  • Buffers: shared hit=20
69. 0.008 0.008 ↑ 1.0 1 1

Index Only Scan using _reference105_byfield2798_sr on _reference105 t25 (cost=0.41..1.72 rows=1 width=19) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (_fld2789 = 'Документ.ЗаказКлиента'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=4
70. 0.006 0.051 ↑ 1.0 1 1

Nested Loop (cost=5.41..6.75 rows=1 width=55) (actual time=0.051..0.051 rows=1 loops=1)

  • Buffers: shared hit=16
71. 0.006 0.035 ↓ 2.0 2 1

HashAggregate (cost=5.00..5.00 rows=1 width=19) (actual time=0.034..0.035 rows=2 loops=1)

  • Group Key: t26._reference73_idrref
  • Buffers: shared hit=9
72. 0.007 0.029 ↓ 6.0 6 1

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

  • Buffers: shared hit=9
73. 0.008 0.008 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t27 (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 = 'P\\2140Z:wL\\341\\021\\347\\024\\2 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
74. 0.014 0.014 ↑ 1.0 3 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t26 (cost=0.28..1.65 rows=3 width=49) (actual time=0.005..0.007 rows=3 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t27._fld14727_type) AND (_fld2105_rtref = t27._fld14727_rtref) AND (_fld2105_rrref = t27._fld14727_rrref))
  • Heap Fetches: 0
  • Buffers: shared hit=6
75. 0.010 0.010 ↓ 0.0 0 2

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t24 (cost=0.42..1.74 rows=1 width=36) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t26._reference73_idrref) AND (_fld14846rref = t25._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=7
76. 0.005 0.005 ↑ 1.0 1 1

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

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

SubPlan (for Nested Loop Semi Join)

78. 0.014 0.014 ↑ 1.0 1 2

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t28 (cost=0.41..1.73 rows=1 width=0) (actual time=0.007..0.007 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea) AND (_fld13933_rrref = t22._fld7786rref) AND (_fld13932rref = t23._idrref))
  • Heap Fetches: 2
  • Buffers: shared hit=9
79. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t28_1 (cost=0.41..32.41 rows=267 width=36) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
  • Heap Fetches: 0
80. 0.018 0.018 ↑ 1.0 1 2

Index Scan using _inforg13938_bydims_rr on _inforg13938 t29 (cost=0.41..3.03 rows=1 width=0) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t23._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=8
81. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t29_1 (cost=0.41..79.35 rows=38 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
82. 0.010 0.048 ↑ 1.0 1 2

Nested Loop (cost=0.83..3.49 rows=1 width=0) (actual time=0.024..0.024 rows=1 loops=2)

  • Buffers: shared hit=16
83. 0.022 0.022 ↑ 1.0 1 2

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t31 (cost=0.42..1.75 rows=1 width=24) (actual time=0.011..0.011 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = '\\010'::bytea) AND (_fld13762_rtref = '\\000\\000\\000\\242'::bytea) AND (_fld13762_rrref = t22._fld7777rref))
  • Heap Fetches: 0
  • Buffers: shared hit=7
84. 0.016 0.016 ↑ 1.0 1 2

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t30 (cost=0.41..1.73 rows=1 width=27) (actual time=0.008..0.008 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t31._fld13763_type) AND (_fld13933_rtref = t31._fld13763_rtref) AND (_fld13933_rrref = t31._fld13763_rrref) AND (_fld13932rref = t23._idrref))
  • Heap Fetches: 2
  • Buffers: shared hit=9
85. 0.014 0.014 ↑ 1.0 1 2

Index Scan using _inforg13938_bydims_rr on _inforg13938 t32 (cost=0.41..3.03 rows=1 width=0) (actual time=0.007..0.007 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t23._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=8
86. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t32_1 (cost=0.41..79.35 rows=38 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
87. 0.002 0.064 ↑ 1.0 1 2

Materialize (cost=6.09..8.79 rows=1 width=17) (actual time=0.032..0.032 rows=1 loops=2)

  • Buffers: shared hit=24
88. 0.002 0.062 ↑ 1.0 1 1

Nested Loop (cost=6.09..8.79 rows=1 width=17) (actual time=0.062..0.062 rows=1 loops=1)

  • Buffers: shared hit=24
89. 0.002 0.056 ↑ 1.0 1 1

Nested Loop (cost=5.82..8.49 rows=1 width=37) (actual time=0.056..0.056 rows=1 loops=1)

  • Buffers: shared hit=20
90. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using _reference105_byfield2798_sr on _reference105 t44 (cost=0.41..1.72 rows=1 width=19) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (_fld2789 = 'Документ.ЗаказНаПеремещение'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=4
91. 0.004 0.043 ↑ 1.0 1 1

Nested Loop (cost=5.41..6.75 rows=1 width=55) (actual time=0.043..0.043 rows=1 loops=1)

  • Buffers: shared hit=16
92. 0.004 0.029 ↓ 2.0 2 1

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

  • Group Key: t45._reference73_idrref
  • Buffers: shared hit=9
93. 0.007 0.025 ↓ 6.0 6 1

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

  • Buffers: shared hit=9
94. 0.006 0.006 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t46 (cost=0.28..1.63 rows=2 width=24) (actual time=0.006..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 = 'P\\2140Z:wL\\341\\021\\347\\024\\222\\030\\303 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
95. 0.012 0.012 ↑ 1.0 3 2

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t46._fld14727_type) AND (_fld2105_rtref = t46._fld14727_rtref) AND (_fld2105_rrref = t46._fld14727_rrref))
  • Heap Fetches: 0
  • Buffers: shared hit=6
96. 0.010 0.010 ↓ 0.0 0 2

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t43 (cost=0.42..1.74 rows=1 width=36) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t45._reference73_idrref) AND (_fld14846rref = t44._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=7
97. 0.004 0.004 ↑ 1.0 1 1

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

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

SubPlan (for Nested Loop Semi Join)

99. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t47 (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\\000\\340'::bytea) AND (_fld13933_rrref = t3._fld7965rref) AND (_fld13932rref = t42._idrref))
  • Heap Fetches: 0
100. 0.155 0.155 ↓ 1.1 281 1

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t47_1 (cost=0.41..32.41 rows=267 width=36) (actual time=0.009..0.155 rows=281 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
  • Heap Fetches: 120
  • Buffers: shared hit=72
101. 0.010 0.010 ↑ 1.0 1 2

Index Scan using _inforg13938_bydims_rr on _inforg13938 t48 (cost=0.41..3.03 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t42._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=8
102. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t48_1 (cost=0.41..79.35 rows=38 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
103. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t49 (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\\000\\340'::bytea) AND (_fld13933_rrref = t3._fld7966rref) AND (_fld13932rref = t42._idrref))
  • Heap Fetches: 0
104. 0.155 0.155 ↓ 1.1 281 1

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t49_1 (cost=0.41..32.41 rows=267 width=36) (actual time=0.009..0.155 rows=281 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
  • Heap Fetches: 120
  • Buffers: shared hit=72
105. 0.010 0.010 ↑ 1.0 1 2

Index Scan using _inforg13938_bydims_rr on _inforg13938 t50 (cost=0.41..3.03 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t42._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=8
106. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t50_1 (cost=0.41..79.35 rows=38 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
Planning time : 54.338 ms
Execution time : 4,984.397 ms