Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[YSQL] Enhancement to pg_stat_statment #15290

Open
sushantrmishra opened this issue Dec 12, 2022 · 1 comment
Open

[YSQL] Enhancement to pg_stat_statment #15290

sushantrmishra opened this issue Dec 12, 2022 · 1 comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue

Comments

@sushantrmishra
Copy link

sushantrmishra commented Dec 12, 2022

Jira Link: DB-4447

Description

Enhancement to pg_stat_statment :

Name Type Description Comments
storage_rows_read bigint Total number of rows read in storage layer rows tracks the rows returned or written. With storage_rows_read/storage_filtered_rows/query_filtered_rows shows the complete execution in terms of rows execution
storage_filtered_rows   Rows removed by filter on storage layer
query_filtered_rows   Rows filtered in Query layer
storage_write_request bigint Total number of write request issued to storage layer  
storage_read_request_time double precision Total time the statement spent in storage read request, in milliseconds (if track_io_timing is enabled, otherwise zero) Should we break it for the main table and index table ??
storage_write_request_time doubleprecision Total time the statement spent in storage write request , in milliseconds (if track_io_timing is enabled, otherwise zero)  
catalog_read_request bigint Total number of Catalog request  
catalog_read_request_time double precision Total time the statement spent in catalog read request , in milliseconds (if track_io_timing is enabled, otherwise zero)  
statement_retries bigint Number of times this statement is retried  
Histogram TBD    
storage_next bigint    
storage_seek bigint    
@sushantrmishra sushantrmishra added area/ysql Yugabyte SQL (YSQL) status/awaiting-triage Issue awaiting triage labels Dec 12, 2022
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug status/awaiting-triage Issue awaiting triage labels Dec 12, 2022
@sushantrmishra
Copy link
Author

statement retries is added via #15372

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
None yet
Development

No branches or pull requests

2 participants