tuhaihe commented on code in PR #1954: URL: https://github.com/apache/cloudberry/pull/1954#discussion_r3925299339
########## gpcontrib/gp_relaccess_stats/README.md: ########## @@ -0,0 +1,105 @@ +<!-- + Licensed to the Apache Software Foundation (ASF) under one + or more contributor license agreements. See the NOTICE file + distributed with this work for additional information + regarding copyright ownership. The ASF licenses this file + to you under the Apache License, Version 2.0 (the + "License"); you may not use this file except in compliance + with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, + software distributed under the License is distributed on an + "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + KIND, either express or implied. See the License for the + specific language governing permissions and limitations + under the License. +--> + +# gp_relaccess_stats: Table access monitoring tool for Greenplum + +## Features +gp_relaccess_stats is an extension that records access statistics for Greenplum tables and views. Allowing users to see what objects were used, when and by whom. For example, this allows DBAs to find objects that are not used anymore or objects that are being misused. + +Features include: +* support of both tables (regular, external or partitioned) and views +* separate tracking of select, insert, update and delete queries +* separate tracking of last read and write timestamps +* tracking of the last user who accessed the object +* per-database configuration +* in-memory stats survive server restarts (but not crashes) + +### Supported versions and platforms +For now it is being tested only for GP6 and Linux. Though, there are no apparent reasons why it should not be working on newer GP versions (or even PG with slight code modification) or other OSes. + +### Installation +Install from source: +```bash +# get the source code somewhere +git clone [email protected]:Smyatkin-Maxim/gp_relaccess_stats.git +cd gp_relaccess_stats +# Build it. Building would require GP installed nearby and sourcing greenplum_path.sh +source <path_to_gp>/greenplum_path.sh Review Comment: This also needs to be updated to reflect the latest env change: cloudberry-env.sh . -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
