explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UFpT

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 19,606.244 ↑ 1.0 1,000 1

Limit (cost=6,918,436.15..6,918,438.65 rows=1,000 width=525) (actual time=19,606.021..19,606.244 rows=1,000 loops=1)

  • Buffers: shared hit=11376541
2. 325.105 19,606.210 ↑ 165.6 1,000 1

Sort (cost=6,918,436.15..6,918,850.11 rows=165,582 width=525) (actual time=19,606.020..19,606.210 rows=1,000 loops=1)

  • Sort Key: t1._date_time DESC
  • Sort Method: top-N heapsort Memory: 1064kB
  • Buffers: shared hit=11376541
3. 489.467 19,281.105 ↓ 3.5 573,453 1

Nested Loop Semi Join (cost=990,012.59..6,909,357.47 rows=165,582 width=525) (actual time=3,896.593..19,281.105 rows=573,453 loops=1)

  • Join Filter: (CASE WHEN (SubPlan 4) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 5 or hashed SubPlan 6) THEN true ELSE false END)
  • Buffers: shared hit=11376541
4. 256.127 15,350.788 ↓ 1.7 573,453 1

Nested Loop Semi Join (cost=990,006.79..5,270,907.49 rows=331,165 width=470) (actual time=3,896.357..15,350.788 rows=573,453 loops=1)

  • Join Filter: (CASE WHEN (SubPlan 7) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 8 or hashed SubPlan 9) THEN true ELSE false END)
  • Buffers: shared hit=7923684
5. 379.719 11,080.319 ↑ 1.2 573,453 1

Nested Loop Left Join (cost=990,000.99..1,998,986.13 rows=662,330 width=487) (actual time=3,896.038..11,080.319 rows=573,453 loops=1)

  • Buffers: shared hit=4470827
6. 191.580 8,406.788 ↑ 1.2 573,453 1

Hash Left Join (cost=990,000.44..1,410,493.03 rows=662,330 width=448) (actual time=3,896.026..8,406.788 rows=573,453 loops=1)

  • Hash Cond: ((t2._document300_idrref = t8._document300_idrref) AND (t2._fld7862 = t8._fld20143))
  • Buffers: shared hit=1597048
7. 967.695 8,105.751 ↑ 1.2 573,453 1

Hash Join (cost=920,361.66..1,311,031.09 rows=662,330 width=448) (actual time=3,786.540..8,105.751 rows=573,453 loops=1)

  • Hash Cond: ((t2._document300_idrref = t1._idrref) AND (t2._fld7862 = t20._fld17386))
  • Buffers: shared hit=1501560
8. 906.684 5,219.654 ↑ 1.0 2,651,905 1

Hash Join (cost=375,862.15..742,940.70 rows=2,651,905 width=287) (actual time=1,865.751..5,219.654 rows=2,651,905 loops=1)

  • Hash Cond: (t2._document300_idrref = t3._idrref)
  • Buffers: shared hit=619780
9. 1,797.398 2,454.058 ↑ 1.0 2,651,905 1

Hash Left Join (cost=225.20..330,840.05 rows=2,651,905 width=256) (actual time=1.531..2,454.058 rows=2,651,905 loops=1)

  • Hash Cond: (t2._fld17170 = t4._code)
  • Buffers: shared hit=280613
10. 655.181 655.181 ↑ 1.0 2,651,905 1

Seq Scan on _document300_vt7842 t2 (cost=0.00..313,615.81 rows=2,651,905 width=252) (actual time=0.009..655.181 rows=2,651,905 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=280467
11. 0.109 1.479 ↑ 1.0 509 1

Hash (cost=218.76..218.76 rows=515 width=15) (actual time=1.479..1.479 rows=509 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
  • Buffers: shared hit=146
12. 0.112 1.370 ↑ 1.0 509 1

Hash Join (cost=184.40..218.76 rows=515 width=15) (actual time=1.115..1.370 rows=509 loops=1)

  • Hash Cond: ("*SELECT* 1".q_001_f_000rref = t4._idrref)
  • Buffers: shared hit=146
13. 0.019 0.160 ↑ 1.0 509 1

Append (cost=0.00..27.28 rows=515 width=22) (actual time=0.008..0.160 rows=509 loops=1)

  • Buffers: shared hit=10
14. 0.028 0.136 ↑ 1.0 509 1

Subquery Scan on *SELECT* 1 (cost=0.00..20.45 rows=509 width=22) (actual time=0.008..0.136 rows=509 loops=1)

  • Buffers: shared hit=9
15. 0.108 0.108 ↑ 1.0 509 1

Seq Scan on _inforg20131 t6 (cost=0.00..15.36 rows=509 width=22) (actual time=0.008..0.108 rows=509 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=9
16. 0.000 0.005 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=1.40..6.83 rows=6 width=36) (actual time=0.005..0.005 rows=0 loops=1)

  • Buffers: shared hit=1
17. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _inforg20135 t7 (cost=1.40..6.77 rows=6 width=36) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (_fld717 = '0'::numeric)
  • Buffers: shared hit=1
18. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _inforg20135_bydims_r (cost=0.00..1.40 rows=6 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (_fld717 = '0'::numeric)
  • Buffers: shared hit=1
19. 0.271 1.098 ↑ 1.0 1,936 1

Hash (cost=160.20..160.20 rows=1,936 width=28) (actual time=1.098..1.098 rows=1,936 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 130kB
  • Buffers: shared hit=136
20. 0.827 0.827 ↑ 1.0 1,936 1

Seq Scan on _reference17080 t4 (cost=0.00..160.20 rows=1,936 width=28) (actual time=0.007..0.827 rows=1,936 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=136
21. 331.651 1,858.912 ↓ 1.0 1,459,005 1

Hash (cost=357,401.97..357,401.97 rows=1,458,798 width=37) (actual time=1,858.912..1,858.912 rows=1,459,005 loops=1)

  • Buckets: 2097152 Batches: 1 Memory Usage: 114696kB
  • Buffers: shared hit=339167
22. 1,527.261 1,527.261 ↓ 1.0 1,459,005 1

Seq Scan on _document300 t3 (cost=0.00..357,401.97 rows=1,458,798 width=37) (actual time=0.013..1,527.261 rows=1,459,005 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=339167
23. 254.660 1,918.402 ↑ 1.0 584,100 1

Hash (cost=535,692.38..535,692.38 rows=587,142 width=200) (actual time=1,918.402..1,918.402 rows=584,100 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 143380kB
  • Buffers: shared hit=881780
24. 373.420 1,663.742 ↑ 1.0 584,100 1

Merge Join (cost=41.56..535,692.38 rows=587,142 width=200) (actual time=0.036..1,663.742 rows=584,100 loops=1)

  • Merge Cond: (t20._fld17385rref = t1._idrref)
  • Buffers: shared hit=881780
25. 739.936 739.936 ↑ 1.0 584,100 1

Index Scan using _inforgs17461_bydims_rn on _inforgsl17461 t20 (cost=0.43..121,690.00 rows=587,142 width=39) (actual time=0.018..739.936 rows=584,100 loops=1)

  • Index Cond: (_fld717 = '0'::numeric)
  • Filter: (_fld17426rref <> '\\337\\2030Z:wL\\341\\021\\347J\\002e\\202\\372\\330'::bytea)
  • Rows Removed by Filter: 2078440
  • Buffers: shared hit=436532
26. 550.386 550.386 ↓ 1.1 1,644,738 1

Index Scan using _document300hpk on _document300 t1 (cost=0.43..403,056.82 rows=1,458,798 width=161) (actual time=0.013..550.386 rows=1,644,738 loops=1)

  • Index Cond: (_fld717 = '0'::numeric)
  • Buffers: shared hit=445248
27. 2.444 109.457 ↓ 2.0 9,478 1

Hash (cost=69,567.69..69,567.69 rows=4,739 width=39) (actual time=109.457..109.457 rows=9,478 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 786kB
  • Buffers: shared hit=95488
28. 4.782 107.013 ↓ 2.0 9,478 1

Nested Loop Semi Join (cost=6.23..69,567.69 rows=4,739 width=39) (actual time=0.339..107.013 rows=9,478 loops=1)

  • Join Filter: (CASE WHEN (SubPlan 1) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 2 or hashed SubPlan 3) THEN true ELSE false END)
  • Buffers: shared hit=95488
29. 5.681 35.701 ↑ 1.0 9,478 1

Nested Loop (cost=0.43..22,736.86 rows=9,478 width=56) (actual time=0.020..35.701 rows=9,478 loops=1)

  • Buffers: shared hit=38192
30. 1.586 1.586 ↑ 1.0 9,478 1

Seq Scan on _document300_vt20140 t8 (cost=0.00..309.48 rows=9,478 width=42) (actual time=0.008..1.586 rows=9,478 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=191
31. 28.434 28.434 ↑ 1.0 1 9,478

Index Scan using _document300hpk on _document300 t10 (cost=0.43..2.36 rows=1 width=37) (actual time=0.003..0.003 rows=1 loops=9,478)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t8._document300_idrref))
  • Buffers: shared hit=38001
32. 0.000 0.000 ↑ 1.0 1 9,478

Materialize (cost=5.80..9.52 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=9,478)

  • Buffers: shared hit=20
33. 0.004 0.071 ↑ 1.0 1 1

Nested Loop (cost=5.80..9.51 rows=1 width=17) (actual time=0.071..0.071 rows=1 loops=1)

  • Buffers: shared hit=20
34. 0.005 0.060 ↑ 1.0 1 1

Nested Loop (cost=5.53..9.21 rows=1 width=38) (actual time=0.060..0.060 rows=1 loops=1)

  • Buffers: shared hit=16
35. 0.000 0.048 ↑ 1.0 1 1

Nested Loop (cost=5.11..7.56 rows=1 width=39) (actual time=0.048..0.048 rows=1 loops=1)

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

Index Only Scan using _reference105_byfield2798_sr on _reference105 t13 (cost=0.41..2.82 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
37. 0.000 0.035 ↑ 2.0 1 1

Unique (cost=4.71..4.72 rows=2 width=19) (actual time=0.035..0.035 rows=1 loops=1)

  • Buffers: shared hit=8
38. 0.010 0.035 ↑ 2.0 1 1

Sort (cost=4.71..4.71 rows=2 width=19) (actual time=0.035..0.035 rows=1 loops=1)

  • Sort Key: t14._reference73_idrref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8
39. 0.006 0.025 ↑ 1.0 2 1

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

  • Buffers: shared hit=8
40. 0.007 0.007 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t15 (cost=0.28..1.53 rows=2 width=24) (actual time=0.007..0.007 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 = 'L\\2230Z:w (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
41. 0.012 0.012 ↑ 3.0 1 2

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

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

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t12 (cost=0.42..1.64 rows=1 width=38) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t14._reference73_idrref) AND (_fld14846rref = t13._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=4
43. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t11 (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 = t12._fld14847rref))
  • Heap Fetches: 1
  • Buffers: shared hit=4
44.          

SubPlan (forNested Loop Semi Join)

45. 0.000 66.346 ↑ 1.0 1 9,478

Nested Loop (cost=0.83..3.29 rows=1 width=0) (actual time=0.007..0.007 rows=1 loops=9,478)

  • Buffers: shared hit=57182
46. 37.912 37.912 ↑ 1.0 1 9,478

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t17 (cost=0.42..1.65 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=9,478)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = '\\010'::bytea) AND (_fld13762_rtref = '\\000\\000\\000\\242'::bytea) AND (_fld13762_rrref = t10._fld7777rref))
  • Heap Fetches: 251
  • Buffers: shared hit=28747
47. 28.434 28.434 ↑ 1.0 1 9,478

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t16 (cost=0.41..1.63 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=9,478)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t17._fld13763_type) AND (_fld13933_rtref = t17._fld13763_rtref) AND (_fld13933_rrref = t17._fld13763_rrref) AND (_fld13932rref = t11._idrr (...)
  • Heap Fetches: 0
  • Buffers: shared hit=28435
48. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t11._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
49. 0.184 0.184 ↓ 3.4 141 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t18_1 (cost=0.41..77.21 rows=42 width=17) (actual time=0.008..0.184 rows=141 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: 0
  • Buffers: shared hit=94
50. 2,293.812 2,293.812 ↑ 1.0 1 573,453

Index Scan using _reference140ng_pkey1 on _reference140 t21 (cost=0.56..0.88 rows=1 width=56) (actual time=0.004..0.004 rows=1 loops=573,453)

  • Index Cond: (t2._fld7845rref = _idrref)
  • Buffers: shared hit=2873779
51. 0.000 0.000 ↑ 1.0 1 573,453

Materialize (cost=5.80..11.16 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=573,453)

  • Buffers: shared hit=20
52. 0.004 0.071 ↑ 1.0 1 1

Nested Loop (cost=5.80..11.15 rows=1 width=17) (actual time=0.071..0.071 rows=1 loops=1)

  • Buffers: shared hit=20
53. 0.002 0.061 ↑ 1.0 1 1

Nested Loop (cost=5.53..10.85 rows=1 width=38) (actual time=0.061..0.061 rows=1 loops=1)

  • Buffers: shared hit=16
54. 0.012 0.012 ↑ 1.0 1 1

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

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

Nested Loop (cost=5.12..8.02 rows=1 width=57) (actual time=0.047..0.047 rows=1 loops=1)

  • Buffers: shared hit=12
56. 0.001 0.035 ↑ 2.0 1 1

Unique (cost=4.71..4.72 rows=2 width=19) (actual time=0.035..0.035 rows=1 loops=1)

  • Buffers: shared hit=8
57. 0.012 0.034 ↑ 2.0 1 1

Sort (cost=4.71..4.71 rows=2 width=19) (actual time=0.034..0.034 rows=1 loops=1)

  • Sort Key: t33._reference73_idrref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8
58. 0.003 0.022 ↑ 1.0 2 1

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

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

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t34 (cost=0.28..1.53 rows=2 width=24) (actual time=0.007..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 = 'L\\2230Z:wN\\241\\021\\350\\363\\3 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
60. 0.010 0.010 ↑ 3.0 1 2

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

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

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t33._reference73_idrref) AND (_fld14846rref = t32._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=4
62. 0.006 0.006 ↑ 1.0 1 1

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

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

SubPlan (forNested Loop Semi Join)

64. 0.000 4,014.171 ↑ 1.0 1 573,453

Nested Loop (cost=0.83..3.29 rows=1 width=0) (actual time=0.007..0.007 rows=1 loops=573,453)

  • Buffers: shared hit=3452743
65. 2,293.812 2,293.812 ↑ 1.0 1 573,453

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t36 (cost=0.42..1.65 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=573,453)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = '\\010'::bytea) AND (_fld13762_rtref = '\\000\\000\\000\\242'::bytea) AND (_fld13762_rrref = t3._fld7777rref))
  • Heap Fetches: 7201
  • Buffers: shared hit=1732383
66. 1,720.359 1,720.359 ↑ 1.0 1 573,453

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t35 (cost=0.41..1.63 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=573,453)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t36._fld13763_type) AND (_fld13933_rtref = t36._fld13763_rtref) AND (_fld13933_rrref = t36._fld13763_rrref) AND (_fld13932rref = t30._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=1720360
67. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t30._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
68. 0.171 0.171 ↓ 3.4 141 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t37_1 (cost=0.41..77.21 rows=42 width=17) (actual time=0.007..0.171 rows=141 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: 0
  • Buffers: shared hit=94
69. 0.000 0.000 ↑ 1.0 1 573,453

Materialize (cost=5.80..11.16 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=573,453)

  • Buffers: shared hit=20
70. 0.004 0.036 ↑ 1.0 1 1

Nested Loop (cost=5.80..11.15 rows=1 width=17) (actual time=0.036..0.036 rows=1 loops=1)

  • Buffers: shared hit=20
71. 0.002 0.030 ↑ 1.0 1 1

Nested Loop (cost=5.53..10.85 rows=1 width=38) (actual time=0.030..0.030 rows=1 loops=1)

  • Buffers: shared hit=16
72. 0.004 0.004 ↑ 1.0 1 1

Index Only Scan using _reference105_byfield2798_sr on _reference105 t24 (cost=0.41..2.82 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=1)

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

Nested Loop (cost=5.12..8.02 rows=1 width=57) (actual time=0.024..0.024 rows=1 loops=1)

  • Buffers: shared hit=12
74. 0.000 0.018 ↑ 2.0 1 1

Unique (cost=4.71..4.72 rows=2 width=19) (actual time=0.018..0.018 rows=1 loops=1)

  • Buffers: shared hit=8
75. 0.005 0.018 ↑ 2.0 1 1

Sort (cost=4.71..4.71 rows=2 width=19) (actual time=0.018..0.018 rows=1 loops=1)

  • Sort Key: t25._reference73_idrref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8
76. 0.005 0.013 ↑ 1.0 2 1

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

  • Buffers: shared hit=8
77. 0.004 0.004 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t26 (cost=0.28..1.53 rows=2 width=24) (actual time=0.004..0.004 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 = 'L\\2230Z:wN\\241\\021\\350\\363\\316\\21 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=3
78. 0.004 0.004 ↑ 3.0 1 2

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

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

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t23 (cost=0.42..1.64 rows=1 width=38) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t25._reference73_idrref) AND (_fld14846rref = t24._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=4
80. 0.002 0.002 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t22 (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 = t23._fld14847rref))
  • Heap Fetches: 1
  • Buffers: shared hit=4
81.          

SubPlan (forNested Loop Semi Join)

82. 0.000 3,440.718 ↑ 1.0 1 573,453

Nested Loop (cost=0.83..3.29 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=573,453)

  • Buffers: shared hit=3452743
83. 1,720.359 1,720.359 ↑ 1.0 1 573,453

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t28 (cost=0.42..1.65 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=573,453)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = '\\010'::bytea) AND (_fld13762_rtref = '\\000\\000\\000\\242'::bytea) AND (_fld13762_rrref = t1._fld7777rref))
  • Heap Fetches: 7201
  • Buffers: shared hit=1732383
84. 1,720.359 1,720.359 ↑ 1.0 1 573,453

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t27 (cost=0.41..1.63 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=573,453)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t28._fld13763_type) AND (_fld13933_rtref = t28._fld13763_rtref) AND (_fld13933_rrref = t28._fld13763_rrref) AND (_fld13932rref = t22._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=1720360
85. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t22._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
86. 0.132 0.132 ↓ 3.4 141 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t29_1 (cost=0.41..77.21 rows=42 width=17) (actual time=0.020..0.132 rows=141 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: 0
  • Buffers: shared hit=94
Planning time : 59.677 ms
Execution time : 19,607.675 ms