viewer dbid - Search results

Documentation (162)

G.4. pgpro_multiplan — save a specific plan of a parameterized query for future usage

view for the current database, omit dbid . To remove records from this view for all databases

F.2. aqo — cost-based query optimization

view for the specified fs and dbid . You can set dbid to NULL instead of the ID of the current

J.5. citus — distributed database and columnar storage functionality

view in Postgres Pro , which tracks statistics about query speed. Name Type Description queryid bigint Identifier (good for pg_stat_statements joins) userid oid User who ran the query dbid

F.45. pg_pathman — an optimized partitioning solution for large and distributed databases

view that shows the number of rows migrated so far: [user]postgres: select * from pathman_concurrent_part_tasks ; userid | pid | dbid

F.7. pgpro_stats — a means for tracking planning and execution statistics of all SQL statements

view are shown in Table F.8 . Table F.8. pgpro_stats_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid

G.1. pgpro_pwr — workload reports

view. Table G.21 lists columns of this report table. Times are provided in seconds. Table G.21. Top SQL by elapsed time Column Description Field/Calculation Query ID Hex representation of queryid . The hash of the query

Blog and News (1)

PostgreSQL 18: part 1 or CommitFest 2024-07

view. The patch makes linking child and parent contexts more convenient and reliable. There is a new column path , which holds an array of context IDs. The first element of the array is always

Mailing lists

In progress...