Skip to content

Metric log rectification#6530

Merged
alexey-milovidov merged 3 commits intomasterfrom
metric-log-rectification
Aug 18, 2019
Merged

Metric log rectification#6530
alexey-milovidov merged 3 commits intomasterfrom
metric-log-rectification

Conversation

@alexey-milovidov
Copy link
Copy Markdown
Member

@alexey-milovidov alexey-milovidov commented Aug 18, 2019

Fix for #6363 (not yet released).

@alexey-milovidov
Copy link
Copy Markdown
Member Author

alexey-milovidov commented Aug 18, 2019

Now it looks Ok:

SELECT 
    event_date, 
    event_time, 
    milliseconds, 
    ProfileEvent_UserTimeMicroseconds, 
    ProfileEvent_SoftPageFaults
FROM system.metric_log
ORDER BY event_time ASC

┌─event_date─┬──────────event_time─┬─milliseconds─┬─ProfileEvent_UserTimeMicroseconds─┬─ProfileEvent_SoftPageFaults─┐
│ 2019-08-18 │ 2019-08-18 03:28:10 │           21 │                                 0 │                           0 │
│ 2019-08-18 │ 2019-08-18 03:28:11 │           21 │                                 0 │                           0 │
│ 2019-08-18 │ 2019-08-18 03:28:12 │           21 │                                 0 │                           0 │
│ 2019-08-18 │ 2019-08-18 03:28:13 │           21 │                                 0 │                           0 │
│ 2019-08-18 │ 2019-08-18 03:28:14 │           21 │                           6264000 │                        3773 │
│ 2019-08-18 │ 2019-08-18 03:28:15 │           21 │                          15396000 │                         660 │
│ 2019-08-18 │ 2019-08-18 03:28:16 │           21 │                          15620000 │                        2723 │
│ 2019-08-18 │ 2019-08-18 03:28:17 │           21 │                          15412000 │                        8536 │
│ 2019-08-18 │ 2019-08-18 03:28:18 │           21 │                          15536000 │                       10986 │
│ 2019-08-18 │ 2019-08-18 03:28:19 │           21 │                           7692000 │                        6276 │
│ 2019-08-18 │ 2019-08-18 03:28:20 │           21 │                              4000 │                          26 │
│ 2019-08-18 │ 2019-08-18 03:28:21 │           21 │                                 0 │                           0 │
│ 2019-08-18 │ 2019-08-18 03:28:22 │           21 │                                 0 │                           0 │
│ 2019-08-18 │ 2019-08-18 03:28:23 │           21 │                                 0 │                           0 │
│ 2019-08-18 │ 2019-08-18 03:28:24 │           21 │                                 0 │                           0 │
│ 2019-08-18 │ 2019-08-18 03:28:25 │           21 │                                 0 │                           0 │
│ 2019-08-18 │ 2019-08-18 03:28:26 │           21 │                              4000 │                          37 │

@alexey-milovidov alexey-milovidov merged commit 1c9fedb into master Aug 18, 2019
@KochetovNicolai KochetovNicolai added the pr-improvement Pull request with some product improvements label Sep 19, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@nikitamikhaylov nikitamikhaylov Awaiting requested review from nikitamikhaylov

Assignees

No one assigned

Labels

pr-improvement Pull request with some product improvements

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

2 participants

@alexey-milovidov @KochetovNicolai