Sometimes the sys or user timings come as 0

percona / pg_stat_monitor

Query Performance Monitoring Tool for PostgreSQL

https://docs.percona.com/pg-stat-monitor/

Other

477 stars 59 forks source link

Sometimes the sys or user timings come as 0 #411

Closed dutow closed 4 months ago

dutow commented 1 year ago

Even in cases with hundreds of executions, the user or sys time being zero is not correct. Therefore, this needs more review. This could be an issue any because of poor handling of query nesting.

It seems, due to same problem, for INSERT queries at times PGSM shows (cpu_sys_time + cpu_user_time > total_exec_time)

https://jira.percona.com/browse/PG-612

ImTheKai commented 4 months ago

Will be tracked here https://jira.percona.com/browse/PG-612