Translation:

checked translation

1 files changed, 36 insertions, 0 deletions

diff --git a/ydb/docs/en/core/troubleshooting/_includes/system_views/top-overload-partitions.md b/ydb/docs/en/core/troubleshooting/_includes/system_views/top-overload-partitions.md
index 9c10fb6d055..e0d041acf15 100644
--- a/ydb/docs/en/core/troubleshooting/_includes/system_views/top-overload-partitions.md
+++ b/ydb/docs/en/core/troubleshooting/_includes/system_views/top-overload-partitions.md
@@ -22,3 +22,39 @@ Both tables have the same set of fields:
 | `RowCount` | Approximate row count during the peak load.<br>Type: `Uint64`. |
 | `IndexSize` | Partition index size per tablet during the peak load.<br>Type: `Uint64`. |
 | `InFlightTxCount` | The number of in-flight transactions during the peak load.<br>Type: `Uint32`. |
+
+Examples:
+
+The following query returns partitions with CPU usage of more than 70% in the specified interval, with tablet IDs and sizes as of the time when the percentage was exceeded. The query is made to the `.sys/top_partitions_one_minute` table with data over the last six hours split into one-minute intervals:
+
+> ```yql
+> SELECT
+>    IntervalEnd,
+>    CPUCores,
+>    Path,
+>    TabletId,
+>    DataSize
+> FROM .sys/top_partitions_one_minute
+> WHERE CPUCores > 0.7
+> AND IntervalEnd BETWEEN Timestamp("YYYY-MM-DDThh:mm:ss.uuuuuuZ") AND Timestamp("YYYY-MM-DDThh:mm:ss.uuuuuu")
+> ORDER BY IntervalEnd desc, CPUCores desc
+> ```
+
+* `"YYYY-MM-DDTHH:MM:SS.UUUUUUZ"`: Time in the UTC 0 zone (`YYYY` stands for year, `MM`, for month, `DD`, for date, `hh`, for hours, `mm`, for minutes, `ss`, for seconds, and `uuuuuu`, for microseconds). For example, `"2023-01-26T13:00:00.000000Z"`.
+
+The following query returns partitions with CPU usage of over 90% in the specified interval, with tablet IDs and sizes as of the time when the percentage was exceeded. The query is made to the `.sys/top_partitions_one_hour` table with data over the last two weeks split into one-hour intervals:
+
+> ```yql
+> SELECT
+>    IntervalEnd,
+>    CPUCores,
+>    Path,
+>    TabletId,
+>    DataSize
+> FROM .sys/top_partitions_one_hour
+> WHERE CPUCores > 0.9
+> AND IntervalEnd BETWEEN Timestamp("YYYY-MM-DDThh:mm:ss.uuuuuuZ") AND Timestamp("YYYY-MM-DDThh:mm:ss.uuuuuu")
+> ORDER BY IntervalEnd desc, CPUCores desc
+> ```
+
+* `"YYYY-MM-DDTHH:MM:SS.UUUUUUZ"`: Time in the UTC 0 zone (`YYYY` stands for year, `MM`, for month, `DD`, for date, `hh`, for hours, `mm`, for minutes, `ss`, for seconds, and `uuuuuu`, for microseconds). For example, `"2023-01-26T13:00:00.000000Z"`.