view for the specified fs and dbid . You can set dbid to NULL instead of the ID of the current
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
view are shown in Table G.72 . Table G.72. pgpro_stats_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view are shown in Table F.26 . Table F.26. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
Viewing Statistics , pg_stat_database_conflicts pg_stat_file, Generic File Access Functions pg_stat_get_activity, Statistics Functions pg_stat_get_backend_activity, Statistics Functions pg_stat_get_backend_activity_start, Statistics Functions
view, returns a set of records containing all the available information about each backend process. Sometimes it may be more convenient to obtain just a subset of this information. In such cases, another
view for the specified queryid and dbid . You can set dbid to NULL instead of the ID of the current
view that shows the number of rows migrated so far: [user]postgres: select * from pathman_concurrent_part_tasks ; userid | pid | dbid
view are shown in Table F.27 . Table F.27. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
view are shown in Table F.25 . Table F.25. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
view, returns a set of records containing all the available information about each backend process. Sometimes it may be more convenient to obtain just a subset of this information. In such cases, an older
view. Table F.41 lists columns of this report table. Times are provided in seconds. Table F.41. Top SQL by elapsed time Column Description Field/Calculation Query ID Hex representation of queryid . The hash of the query
view are shown in Table F.91 . Table F.91. pgpro_stats_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view are shown in Table F.104 . Table F.104. pg_stat_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view. Most of these functions come in two variants, one of which can optionally “ pretty-print ” the result. The pretty-printed format is more readable, but the default format is more likely to be interpreted
view are shown in Table F.22 . Table F.22. pg_stat_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view are shown in Table F.23 . Table F.23. pg_stat_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view for the current database, omit dbid . To remove records from this view for all databases
view. Table G.28 lists columns of this report table. Times are provided in seconds. Table G.28. Top SQL by elapsed time Column Description Field/Calculation Query ID Hex representation of queryid . The hash of the query
view are shown in Table G.81 . Table G.81. pgpro_stats_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view are shown in Table F.43 . Table F.43. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
view are shown in Table G.79 . Table G.79. pgpro_result_cache_data Columns Name Type Description dbid
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
view SELECT * FROM pgpro_multiplan_captured_queries \gx dbid | 5 sql_hash | 6079808577596655075 plan_hash
view. Table G.26 lists columns of this report table. Times are provided in seconds. Table G.26. Top SQL by elapsed time Column Description Field/Calculation Query ID Hex representation of queryid . The hash of the query
view are shown in Table G.77 . Table G.77. pgpro_stats_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view are shown in Table G.89 . Table G.89. sr_plan_storage Columns Name Type Description dbid
view are shown in Table F.37 . Table F.37. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
view are shown in Table F.38 . Table F.38. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
view are shown in Table F.32 . Table F.32. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
view. Table F.47 lists columns of this report table. Times are provided in seconds. Table F.47. Top SQL by elapsed time Column Description Field/Calculation Query ID Hex representation of queryid . The hash of the query
view are shown in Table F.101 . Table F.101. pgpro_stats_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view are shown in Table F.114 . Table F.114. pg_stat_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view are shown in Table F.32 . Table F.32. pg_stat_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view are shown in Table F.33 . Table F.33. pg_stat_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view are shown in Table F.21 . Table F.21. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
view rather than its OID. (This is deprecated; use the OID variant instead.) pg_index_column_has_property ( index regclass , column integer , property text ) → boolean Tests whether an index column has the named property. Common
view are shown in Table F.22 . Table F.22. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
view are shown in Table F.20 . Table F.20. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
view are shown in Table F.21 . Table F.21. pg_stat_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
view are shown in Table F-20 . Table F-20. pg_stat_statements Columns Name Type References Description userid oid pg_authid .oid OID of user who executed the statement dbid
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
view are shown in Table F.23 . Table F.23. pg_stat_statements Columns Column Type Description userid oid (references pg_authid . oid ) OID of user who executed the statement dbid
Соглашаюсь с условиями обработки персональных данных
