Monitoring Active Tables with SHOW OPEN TABLES in openGauss
Command Overview
The SHOW OPEN TABLES statement retrieves a list of all non-temporal tables currently opened within the database instance.
Important Distinction
When comparing this command to MySQL, note that while MySQL populates the Database field with the catalog name, openGauss fills this column with the schema name associated with the tabl ...
Posted on Wed, 16 Sep 2026 16:20:18 +0000 by AnarKy