You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by "adnanhamdussalam (via GitHub)" <gi...@apache.org> on 2026/08/25 16:42:12 UTC
[I] Info Required : pg_stat_statements [cloudberry]
adnanhamdussalam opened a new issue, #1926:
URL: https://github.com/apache/cloudberry/issues/1926
Hi,
Which queries are doing most of IO how can I get it from cloudberry can we use pg_stat_statement if yes then can you share the steps for this extension or any document or is there any other tool available?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org
Re: [I] Info Required : pg_stat_statements [cloudberry]
Posted by "leborchuk (via GitHub)" <gi...@apache.org>.
leborchuk commented on issue #1926:
URL: https://github.com/apache/cloudberry/issues/1926#issuecomment-5491926009
Hi, try https://github.com/open-gpdb/yagpcc
It's fully support Apache Cloudberry
We're in the state of transfer to https://github.com/apache/cloudberry-command-center (need some time to complete whole process, so right now link is to private repo)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org
Re: [I] Info Required : pg_stat_statements [cloudberry]
Posted by "liang8283 (via GitHub)" <gi...@apache.org>.
liang8283 commented on issue #1926:
URL: https://github.com/apache/cloudberry/issues/1926#issuecomment-5490933566
pg_stat_statement cannot be used for cloudberry because it only saves the performance statistics for a single node. It cannot summarize the stats across all the nodes for cloudberry.
The open source version of cloudberry does not have built-in tools for monitoring IO. Here are some alternatives for your reference:
- If the Resource Group is enabled, you can get the IO stats via the query: `SELECT * FROM gp_toolkit.gp_resgroup_iostats_per_host;`
- If you mostly use heap tables, the view `pg_statio_all_tables` can also be used.
```
SELECT relname,
sum(heap_blks_read) AS heap_read,
sum(heap_blks_hit) AS heap_hit,
sum(idx_blks_read) AS idx_read
FROM gp_dist_random('pg_statio_all_tables')
GROUP BY relname
ORDER BY heap_read DESC limit 10;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org