История анализов плана выполнения (пользователь: 0fa0e974)
| Время | ||||||||
|---|---|---|---|---|---|---|---|---|
| ID | Пользователь | SQL Запрос | Планирование | Выполнение | Всего | Дата | Действия | |
| 1 | #91 | 6a6b9ad5 |
Хеш: d41d8cd9...
|
0 µs | 567.00 ms | 567.00 ms | 06.05.26 08:54 |
|
| 2 | #90 | 6a6b9ad5 |
Хеш: d41d8cd9...
|
0 µs | 35.00 ms | 35.00 ms | 30.04.26 10:52 |
|
| 3 | #89 | 6a6b9ad5 |
Хеш: d41d8cd9...
|
0 µs | 194.00 ms | 194.00 ms | 30.04.26 10:42 |
|
| 4 | #88 | 6a6b9ad5 |
Хеш: d41d8cd9...
|
0 µs | 243.00 ms | 243.00 ms | 15.04.26 11:55 |
|
| 5 | #87 | 65d2db8e |
SELECT COUNT(DISTINCT("transaction"."transaction_id"))...
Хеш: 384a4991...
|
0 µs | 36.00 ms | 36.00 ms | 26.03.26 18:30 |
|
| 6 | #86 | 65d2db8e |
SELECT COUNT(DISTINCT("transaction"."transaction_id"))...
Хеш: 1f4800b0...
|
0 µs | 39.00 ms | 39.00 ms | 26.03.26 18:02 |
|
| 7 | #85 | 6a6b9ad5 |
Хеш: d41d8cd9...
|
0 µs | 35.00 ms | 35.00 ms | 19.03.26 08:37 |
|
| 8 | #84 | 65d2db8e |
explain analyze
SELECT DISTINCT d.owner_id AS...
Хеш: d357cd89...
|
0 µs | 47.00 ms | 47.00 ms | 18.03.26 12:19 |
|
| 9 | #83 | 4fe42a94 |
Хеш: d41d8cd9...
|
0 µs | 29.00 ms | 29.00 ms | 12.03.26 16:36 |
|
| 10 | #82 | 9b0e8b1b |
Хеш: d41d8cd9...
|
0 µs | 143.00 ms | 143.00 ms | 05.03.26 16:45 |
|
| 11 | #81 | 65d2db8e |
select * from station_columns
Хеш: 8f9d19b5...
|
0 µs | 4.00 ms | 4.00 ms | 25.02.26 17:09 |
|
| 12 | #80 | 65d2db8e |
select * from stations;
Хеш: 9fbe5822...
|
0 µs | 10.00 ms | 10.00 ms | 25.02.26 17:01 |
|
| 13 | #79 | 63ae63ee |
Хеш: d41d8cd9...
|
0 µs | 9.00 ms | 9.00 ms | 18.02.26 13:21 |
|
| 14 | #78 | 63ae63ee |
Хеш: d41d8cd9...
|
0 µs | 10.00 ms | 10.00 ms | 18.02.26 13:19 |
|
| 15 | #77 | 63ae63ee |
Хеш: d41d8cd9...
|
0 µs | 299.00 ms | 299.00 ms | 18.02.26 13:12 |
|
| 16 | #76 | ca6a6301 |
select *
from doc_title dt
where dt.external_id =...
Хеш: 16bba9bd...
|
0 µs | 150.00 ms | 150.00 ms | 29.01.26 18:46 |
|
| 17 | #75 | ca6a6301 |
select *
from doc_title dt
where dt.external_id =...
Хеш: 16bba9bd...
|
0 µs | 205.00 ms | 205.00 ms | 29.01.26 18:44 |
|
| 18 | #74 | 6a6b9ad5 |
Хеш: d41d8cd9...
|
0 µs | 61.00 ms | 61.00 ms | 23.01.26 10:17 |
|
| 19 | #73 | 9b0e8b1b |
Хеш: d41d8cd9...
|
0 µs | 218.00 ms | 218.00 ms | 22.01.26 20:34 |
|
| 20 | #72 | 9b0e8b1b |
Хеш: d41d8cd9...
|
0 µs | 28.00 ms | 28.00 ms | 22.01.26 18:58 |
|
| 21 | #71 | 532cd28f |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) SELECT 1
Хеш: 1978d96f...
|
0 µs | 7.00 ms | 7.00 ms | 22.01.26 18:37 |
|
| 22 | #70 | be3b4dc0 |
Хеш: d41d8cd9...
|
0 µs | 227.00 ms | 227.00 ms | 20.01.26 10:23 |
|
| 23 | #69 | be3b4dc0 |
Хеш: d41d8cd9...
|
0 µs | 393.00 ms | 393.00 ms | 20.01.26 10:11 |
|
| 24 | #68 | be3b4dc0 |
WITH
season_parametr as (
...
Хеш: aeee1f27...
|
0 µs | 298.00 ms | 298.00 ms | 20.01.26 10:10 |
|
| 25 | #67 | 7f191d6b |
SELECT
i.id
,i.date_cr
...
Хеш: 72865118...
|
0 µs | 189.00 ms | 189.00 ms | 19.01.26 23:55 |
|
| 26 | #66 | 7f191d6b |
SELECT
i.id
,i.date_cr
...
Хеш: 72865118...
|
0 µs | 175.00 ms | 175.00 ms | 19.01.26 23:47 |
|
| 27 | #65 | 7f191d6b |
WITH child_issues AS (
SELECT
c.id...
Хеш: 628265fc...
|
0 µs | 69.00 ms | 69.00 ms | 19.01.26 22:37 |
|
| 28 | #64 | 7f191d6b |
SELECT
s.*
,x.id_sprint
...
Хеш: 3e46b5d3...
|
0 µs | 44.00 ms | 44.00 ms | 19.01.26 22:18 |
|
| 29 | #63 | 7f191d6b |
SELECT
s.*
,x.id_sprint
...
Хеш: 3e46b5d3...
|
0 µs | 54.00 ms | 54.00 ms | 19.01.26 21:58 |
|
| 30 | #62 | 7f191d6b |
SELECT
s.*
,x.id_sprint
...
Хеш: f71e16b5...
|
0 µs | 77.00 ms | 77.00 ms | 19.01.26 21:45 |
|
| 31 | #61 | 7f191d6b |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) ...
Хеш: f69fd708...
|
0 µs | 10.00 ms | 10.00 ms | 19.01.26 21:40 |
|
| 32 | #60 | 7f191d6b |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) ...
Хеш: f69fd708...
|
0 µs | 17.00 ms | 17.00 ms | 19.01.26 21:37 |
|
| 33 | #59 | 7f191d6b |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON)...
Хеш: d4499325...
|
0 µs | 23.00 ms | 23.00 ms | 19.01.26 21:19 |
|
| 34 | #58 | 704d0325 |
SELECT u.id, u.name, u.email, p.title,...
Хеш: efa70e16...
|
0 µs | 9.00 ms | 9.00 ms | 16.01.26 17:19 |
|
| 35 | #57 | 2711ed08 |
SELECT u.id, u.name, u.email, p.title,...
Хеш: efa70e16...
|
0 µs | 8.00 ms | 8.00 ms | 16.01.26 17:19 |
|
| 36 | #56 | 2711ed08 |
SELECT u.id, u.name, u.email, p.title,...
Хеш: efa70e16...
|
0 µs | 8.00 ms | 8.00 ms | 16.01.26 17:15 |
|
| 37 | #55 | c3831cdc |
Хеш: d41d8cd9...
|
0 µs | 10.00 ms | 10.00 ms | 16.01.26 17:15 |
|
| 38 | #54 | 2711ed08 |
SELECT u.id, u.name, u.email, p.title,...
Хеш: efa70e16...
|
0 µs | 18.00 ms | 18.00 ms | 16.01.26 17:14 |
|
| 39 | #53 | 7f191d6b |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) SELECT...
Хеш: 5e59cb4e...
|
0 µs | 164.00 ms | 164.00 ms | 16.01.26 17:01 |
|
| 40 | #52 | 7f191d6b |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) SELECT...
Хеш: 2cf2f193...
|
0 µs | 148.00 ms | 148.00 ms | 16.01.26 15:06 |
|
| 41 | #51 | 7f191d6b |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) SELECT...
Хеш: 91d4989b...
|
0 µs | 148.00 ms | 148.00 ms | 16.01.26 14:30 |
|
| 42 | #50 | 7f191d6b |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) SELECT...
Хеш: 2cae32b7...
|
0 µs | 138.00 ms | 138.00 ms | 16.01.26 14:17 |
|
| 43 | #49 | 7f191d6b |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) SELECT...
Хеш: 2cae32b7...
|
0 µs | 127.00 ms | 127.00 ms | 16.01.26 14:15 |
|
| 44 | #48 | 7f191d6b |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) SELECT...
Хеш: 2cae32b7...
|
0 µs | 125.00 ms | 125.00 ms | 16.01.26 14:13 |
|
| 45 | #47 | be3b4dc0 |
Хеш: d41d8cd9...
|
0 µs | 190.00 ms | 190.00 ms | 16.01.26 11:51 |
|
| 46 | #46 | 7f191d6b |
EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON) SELECT...
Хеш: af6736ac...
|
0 µs | 106.00 ms | 106.00 ms | 16.01.26 11:29 |
|
| 47 | #45 | be3b4dc0 |
Хеш: d41d8cd9...
|
0 µs | 183.00 ms | 183.00 ms | 16.01.26 11:09 |
|
| 48 | #44 | f8762a29 |
SELECT
i.id
,i.date_cr
...
Хеш: f0414b82...
|
0 µs | 80.00 ms | 80.00 ms | 16.01.26 11:08 |
|
| 49 | #43 | f8762a29 |
Хеш: d41d8cd9...
|
0 µs | 80.00 ms | 80.00 ms | 16.01.26 11:07 |
|
| 50 | #42 | f8762a29 |
Хеш: d41d8cd9...
|
0 µs | 88.00 ms | 88.00 ms | 16.01.26 11:06 |
|