explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kDrU

Settings
# exclusive inclusive rows x rows loops node
1. 0.053 20,303.593 ↑ 1.0 1,000 1

Limit (cost=9,156,350.17..9,156,352.67 rows=1,000 width=526) (actual time=20,303.345..20,303.593 rows=1,000 loops=1)

  • Buffers: shared hit=12349960 read=23941 dirtied=58
2. 323.229 20,303.540 ↑ 162.5 1,000 1

Sort (cost=9,156,350.17..9,156,756.48 rows=162,523 width=526) (actual time=20,303.345..20,303.540 rows=1,000 loops=1)

  • Sort Key: t1._date_time DESC
  • Sort Method: top-N heapsort Memory: 1064kB
  • Buffers: shared hit=12349960 read=23941 dirtied=58
3. 659.976 19,980.311 ↓ 3.5 567,114 1

Nested Loop Semi Join (cost=993,045.61..9,147,439.21 rows=162,523 width=526) (actual time=4,174.779..19,980.311 rows=567,114 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=12349957 read=23941 dirtied=58
4. 423.382 15,917.544 ↓ 1.7 567,114 1

Nested Loop Semi Join (cost=993,038.10..6,759,152.51 rows=325,046 width=471) (actual time=4,174.561..15,917.544 rows=567,114 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)
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=8353968 read=23941 dirtied=58
5. 566.815 11,524.175 ↑ 1.1 567,115 1

Nested Loop Left Join (cost=993,030.59..1,987,458.67 rows=650,093 width=488) (actual time=4,174.252..11,524.175 rows=567,115 loops=1)

  • Buffers: shared hit=4358018 read=23895 dirtied=53
6. 178.945 8,688.900 ↑ 1.1 567,115 1

Hash Left Join (cost=993,030.03..1,407,145.60 rows=650,093 width=449) (actual time=4,174.229..8,688.900 rows=567,115 loops=1)

  • Hash Cond: ((t2._document300_idrref = t8._document300_idrref) AND (t2._fld7862 = t8._fld20143))
  • Buffers: shared hit=1516741 read=23641 dirtied=53
7. 952.096 8,402.951 ↑ 1.1 567,115 1

Hash Join (cost=907,896.29..1,292,740.47 rows=650,093 width=449) (actual time=4,067.196..8,402.951 rows=567,115 loops=1)

  • Hash Cond: ((t2._document300_idrref = t1._idrref) AND (t2._fld7862 = t20._fld17386))
  • Buffers: shared hit=1419521 read=23629 dirtied=50
8. 895.889 5,388.596 ↑ 1.0 2,613,741 1

Hash Join (cost=370,462.23..732,042.99 rows=2,613,947 width=287) (actual time=2,002.667..5,388.596 rows=2,613,741 loops=1)

  • Hash Cond: (t2._document300_idrref = t3._idrref)
  • Buffers: shared hit=610627
9. 1,792.320 2,496.629 ↑ 1.0 2,613,741 1

Hash Left Join (cost=222.98..325,861.96 rows=2,613,947 width=256) (actual time=2.033..2,496.629 rows=2,613,741 loops=1)

  • Hash Cond: (t2._fld17170 = t4._code)
  • Buffers: shared hit=276368
10. 702.328 702.328 ↑ 1.0 2,613,741 1

Seq Scan on _document300_vt7842 t2 (cost=0.00..308,892.34 rows=2,613,947 width=252) (actual time=0.021..702.328 rows=2,613,741 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=276218
11. 0.115 1.981 ↑ 1.0 507 1

Hash (cost=216.56..216.56 rows=513 width=15) (actual time=1.981..1.981 rows=507 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
  • Buffers: shared hit=144
12. 0.102 1.866 ↑ 1.0 507 1

Hash Join (cost=182.27..216.56 rows=513 width=15) (actual time=1.571..1.866 rows=507 loops=1)

  • Hash Cond: ("*SELECT* 1".q_001_f_000rref = t4._idrref)
  • Buffers: shared hit=144
13. 0.026 0.222 ↑ 1.0 507 1

Append (cost=0.00..27.23 rows=513 width=22) (actual time=0.021..0.222 rows=507 loops=1)

  • Buffers: shared hit=10
14. 0.031 0.186 ↑ 1.0 507 1

Subquery Scan on *SELECT* 1 (cost=0.00..20.41 rows=507 width=22) (actual time=0.020..0.186 rows=507 loops=1)

  • Buffers: shared hit=9
15. 0.155 0.155 ↑ 1.0 507 1

Seq Scan on _inforg20131 t6 (cost=0.00..15.34 rows=507 width=22) (actual time=0.020..0.155 rows=507 loops=1)

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

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

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

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

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

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

  • Index Cond: (_fld717 = '0'::numeric)
  • Buffers: shared hit=1
19. 0.263 1.542 ↑ 1.0 1,931 1

Hash (cost=158.14..158.14 rows=1,931 width=28) (actual time=1.542..1.542 rows=1,931 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 130kB
  • Buffers: shared hit=134
20. 1.279 1.279 ↑ 1.0 1,931 1

Seq Scan on _reference17080 t4 (cost=0.00..158.14 rows=1,931 width=28) (actual time=0.015..1.279 rows=1,931 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=134
21. 329.831 1,996.078 ↑ 1.0 1,439,128 1

Hash (cost=352,249.12..352,249.12 rows=1,439,210 width=37) (actual time=1,996.078..1,996.078 rows=1,439,128 loops=1)

  • Buckets: 2097152 Batches: 1 Memory Usage: 113357kB
  • Buffers: shared hit=334259
22. 1,666.247 1,666.247 ↑ 1.0 1,439,128 1

Seq Scan on _document300 t3 (cost=0.00..352,249.12 rows=1,439,210 width=37) (actual time=0.019..1,666.247 rows=1,439,128 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=334259
23. 256.786 2,062.259 ↑ 1.0 577,610 1

Hash (cost=528,752.34..528,752.34 rows=578,782 width=201) (actual time=2,062.259..2,062.259 rows=577,610 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 141878kB
  • Buffers: shared hit=808891 read=23629 dirtied=50
24. 376.174 1,805.473 ↑ 1.0 577,610 1

Merge Join (cost=40.97..528,752.34 rows=578,782 width=201) (actual time=0.510..1,805.473 rows=577,610 loops=1)

  • Merge Cond: (t20._fld17385rref = t1._idrref)
  • Buffers: shared hit=808891 read=23629 dirtied=50
25. 897.026 897.026 ↑ 1.0 577,610 1

Index Scan using _inforgs17461_bydims_rn on _inforgsl17461 t20 (cost=0.43..120,701.87 rows=578,782 width=39) (actual time=0.436..897.026 rows=577,610 loops=1)

  • Index Cond: (_fld717 = '0'::numeric)
  • Filter: (_fld17426rref <> '\\337\\2030Z:wL\\341\\021\\347J\\002e\\202\\372\\330'::bytea)
  • Rows Removed by Filter: 2046618
  • Buffers: shared hit=383900 read=23629 dirtied=50
26. 532.273 532.273 ↓ 1.1 1,622,864 1

Index Scan using _document300hpk on _document300 t1 (cost=0.43..397,257.78 rows=1,439,210 width=162) (actual time=0.063..532.273 rows=1,622,864 loops=1)

  • Index Cond: (_fld717 = '0'::numeric)
  • Buffers: shared hit=424991
27. 2.150 107.004 ↓ 2.0 8,717 1

Hash (cost=85,068.37..85,068.37 rows=4,358 width=39) (actual time=107.004..107.004 rows=8,717 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 733kB
  • Buffers: shared hit=97220 read=12 dirtied=3
28. 2.621 104.854 ↓ 2.0 8,717 1

Nested Loop Semi Join (cost=7.94..85,068.37 rows=4,358 width=39) (actual time=1.041..104.854 rows=8,717 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=97220 read=12 dirtied=3
29. 4.554 32.270 ↓ 1.0 8,717 1

Nested Loop (cost=0.43..21,089.05 rows=8,715 width=56) (actual time=0.026..32.270 rows=8,717 loops=1)

  • Buffers: shared hit=35143
30. 1.565 1.565 ↓ 1.0 8,717 1

Seq Scan on _document300_vt20140 t8 (cost=0.00..283.94 rows=8,715 width=42) (actual time=0.012..1.565 rows=8,717 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=175
31. 26.151 26.151 ↑ 1.0 1 8,717

Index Scan using _document300hpk on _document300 t10 (cost=0.43..2.38 rows=1 width=37) (actual time=0.003..0.003 rows=1 loops=8,717)

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

Materialize (cost=7.51..11.22 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=8,717)

  • Buffers: shared hit=23 read=1
33. 0.003 0.687 ↑ 1.0 1 1

Nested Loop (cost=7.51..11.21 rows=1 width=17) (actual time=0.687..0.687 rows=1 loops=1)

  • Buffers: shared hit=23 read=1
34. 0.002 0.671 ↑ 1.0 1 1

Nested Loop (cost=7.24..10.91 rows=1 width=38) (actual time=0.671..0.671 rows=1 loops=1)

  • Buffers: shared hit=20 read=1
35. 0.076 0.076 ↑ 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.076..0.076 rows=1 loops=1)

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

Nested Loop (cost=6.84..8.08 rows=1 width=57) (actual time=0.593..0.593 rows=1 loops=1)

  • Buffers: shared hit=13 read=1
37. 0.003 0.557 ↑ 1.0 1 1

HashAggregate (cost=6.42..6.43 rows=1 width=19) (actual time=0.557..0.557 rows=1 loops=1)

  • Group Key: t14._reference73_idrref
  • Buffers: shared hit=9 read=1
38. 0.003 0.554 ↓ 2.0 2 1

Nested Loop (cost=0.56..6.42 rows=1 width=19) (actual time=0.552..0.554 rows=2 loops=1)

  • Buffers: shared hit=9 read=1
39. 0.027 0.027 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t15 (cost=0.28..3.25 rows=2 width=24) (actual time=0.026..0.027 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 (...)
  • Heap Fetches: 2
  • Buffers: shared hit=4
40. 0.524 0.524 ↑ 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.262..0.262 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: 1
  • Buffers: shared hit=5 read=1
41. 0.032 0.032 ↑ 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.032..0.032 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
42. 0.013 0.013 ↑ 1.0 1 1

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t12._fld14847rref))
  • Heap Fetches: 0
  • Buffers: shared hit=3
43.          

SubPlan (forNested Loop Semi Join)

44. 8.717 69.736 ↑ 1.0 1 8,717

Nested Loop (cost=0.83..5.69 rows=1 width=0) (actual time=0.008..0.008 rows=1 loops=8,717)

  • Buffers: shared hit=61956 read=11 dirtied=3
45. 34.868 34.868 ↑ 1.0 1 8,717

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t17 (cost=0.42..2.85 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=8,717)

  • 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: 889
  • Buffers: shared hit=27087 read=11 dirtied=3
46. 26.151 26.151 ↑ 1.0 1 8,717

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t16 (cost=0.41..2.83 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=8,717)

  • 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: 8717
  • Buffers: shared hit=34869
47. 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
48. 0.227 0.227 ↓ 3.4 141 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t18_1 (cost=0.41..77.04 rows=42 width=17) (actual time=0.020..0.227 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: 5
  • Buffers: shared hit=98
49. 2,268.460 2,268.460 ↑ 1.0 1 567,115

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=567,115)

  • Index Cond: (t2._fld7845rref = _idrref)
  • Buffers: shared hit=2841277 read=254
50. 0.000 0.000 ↑ 1.0 1 567,115

Materialize (cost=7.51..11.22 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=567,115)

  • Buffers: shared hit=24
51. 0.003 0.096 ↑ 1.0 1 1

Nested Loop (cost=7.51..11.21 rows=1 width=17) (actual time=0.064..0.096 rows=1 loops=1)

  • Buffers: shared hit=24
52. 0.004 0.087 ↑ 1.0 1 1

Nested Loop (cost=7.24..10.91 rows=1 width=38) (actual time=0.056..0.087 rows=1 loops=1)

  • Buffers: shared hit=21
53. 0.013 0.013 ↑ 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.013 rows=1 loops=1)

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

Nested Loop (cost=6.84..8.08 rows=1 width=57) (actual time=0.041..0.070 rows=1 loops=1)

  • Buffers: shared hit=17
55. 0.005 0.030 ↓ 2.0 2 1

HashAggregate (cost=6.42..6.43 rows=1 width=19) (actual time=0.029..0.030 rows=2 loops=1)

  • Group Key: t33._reference73_idrref
  • Buffers: shared hit=10
56. 0.002 0.025 ↓ 2.0 2 1

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

  • Buffers: shared hit=10
57. 0.009 0.009 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t34 (cost=0.28..3.25 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 = 'L\\2230Z:wN\\241\\021\\350\\363\\316\\21 (...)
  • Heap Fetches: 2
  • Buffers: shared hit=4
58. 0.014 0.014 ↑ 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.006..0.007 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: 1
  • Buffers: shared hit=6
59. 0.018 0.018 ↓ 0.0 0 2

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=0 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t33._reference73_idrref) AND (_fld14846rref = t32._idrref))
  • Heap Fetches: 0
  • Buffers: shared hit=7
60. 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.005..0.006 rows=1 loops=1)

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

SubPlan (forNested Loop Semi Join)

62. 0.003 3,969.805 ↑ 1.0 1 567,115

Nested Loop (cost=0.83..5.69 rows=1 width=0) (actual time=0.007..0.007 rows=1 loops=567,115)

  • Buffers: shared hit=3995828 read=46 dirtied=5
63. 2,268.460 2,268.460 ↑ 1.0 1 567,115

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t36 (cost=0.42..2.85 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=567,115)

  • 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: 21356
  • Buffers: shared hit=1727371 read=46 dirtied=5
64. 1,701.342 1,701.342 ↑ 1.0 1 567,114

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t35 (cost=0.41..2.83 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=567,114)

  • 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: 567114
  • Buffers: shared hit=2268457
65. 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
66. 0.182 0.182 ↓ 3.4 141 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t37_1 (cost=0.41..77.04 rows=42 width=17) (actual time=0.008..0.182 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: 5
  • Buffers: shared hit=98
67. 0.000 0.000 ↑ 1.0 1 567,114

Materialize (cost=7.51..11.22 rows=1 width=17) (actual time=0.000..0.000 rows=1 loops=567,114)

  • Buffers: shared hit=21
68. 0.002 0.033 ↑ 1.0 1 1

Nested Loop (cost=7.51..11.21 rows=1 width=17) (actual time=0.033..0.033 rows=1 loops=1)

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

Nested Loop (cost=7.24..10.91 rows=1 width=38) (actual time=0.029..0.029 rows=1 loops=1)

  • Buffers: shared hit=18
70. 0.005 0.005 ↑ 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.005..0.005 rows=1 loops=1)

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

Nested Loop (cost=6.84..8.08 rows=1 width=57) (actual time=0.023..0.023 rows=1 loops=1)

  • Buffers: shared hit=14
72. 0.001 0.016 ↑ 1.0 1 1

HashAggregate (cost=6.42..6.43 rows=1 width=19) (actual time=0.016..0.016 rows=1 loops=1)

  • Group Key: t25._reference73_idrref
  • Buffers: shared hit=10
73. 0.006 0.015 ↓ 2.0 2 1

Nested Loop (cost=0.56..6.42 rows=1 width=19) (actual time=0.014..0.015 rows=2 loops=1)

  • Buffers: shared hit=10
74. 0.005 0.005 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t26 (cost=0.28..3.25 rows=2 width=24) (actual time=0.004..0.005 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\\217Z\\00 (...)
  • Heap Fetches: 2
  • Buffers: shared hit=4
75. 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: 1
  • Buffers: shared hit=6
76. 0.004 0.004 ↑ 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.004..0.004 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
77. 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: 0
  • Buffers: shared hit=3
78.          

SubPlan (forNested Loop Semi Join)

79. 0.000 3,402.684 ↑ 1.0 1 567,114

Nested Loop (cost=0.83..5.69 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=567,114)

  • Buffers: shared hit=3995870
80. 1,701.342 1,701.342 ↑ 1.0 1 567,114

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t28 (cost=0.42..2.85 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=567,114)

  • 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: 21355
  • Buffers: shared hit=1727413
81. 1,701.342 1,701.342 ↑ 1.0 1 567,114

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t27 (cost=0.41..2.83 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=567,114)

  • 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: 567114
  • Buffers: shared hit=2268457
82. 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
83. 0.107 0.107 ↓ 3.4 141 1

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t29_1 (cost=0.41..77.04 rows=42 width=17) (actual time=0.004..0.107 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: 5
  • Buffers: shared hit=98