↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Predefined Roles

pg_stat_scan_tables

pg_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension).

Reading PG 18·Select a recorded version

Name
pg_stat_scan_tables
Manual terminology
Predefined roles

Definition PG 18

pg_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension).

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75

Text language: en · b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75