Pg_notification_queue_usage () → double precision Returns the set of names of asynchronous notification channels that the current session is listening to. Returns true if a JIT compiler extension is available (see Chapter 32) and the jit configuration parameter is set to on. (This can be useful, for example, to exclude other sessions' temporary tables from a catalog display.) Returns true if the given OID is the OID of another session's temporary schema. Pg_is_other_temp_schema ( oid ) → boolean Returns the OID of the current session's temporary schema, or zero if it has none (because it has not created any temporary tables). The result reflects the contents of the current_logfiles file. The result is NULL if the log format requested is not configured in log_destination. To request information about a specific log file format, supply either csvlog, jsonlog or stderr as the value of the optional parameter. NULL is returned if no log file has any of these formats. When multiple log files exist, each in a different format, pg_current_logfile without an argument returns the path of the file having the first format found in the ordered list: stderr, csvlog, jsonlog. The result is NULL if the logging collector is disabled. The path includes the log_directory directory and the individual log file name. Returns the path name of the log file currently in use by the logging collector. Otherwise it is the time when the postmaster process re-read the configuration files. If the current session was alive at the time, this will be the time when the session itself re-read the configuration files (so the reading will vary a little in different sessions). Returns the time when the server configuration files were last loaded. Pg_conf_load_time () → timestamp with time zone Also note that when a prepared transaction holds a conflicting lock, it will be represented by a zero process ID.įrequent calls to this function could have some impact on database performance, because it needs exclusive access to the lock manager's shared state for a short time. As a result of that, there may be duplicated PIDs in the result. When using parallel queries the result always lists client-visible process IDs (that is, pg_backend_pid results) even if the actual lock is held or awaited by a child worker process. One server process blocks another if it either holds a lock that conflicts with the blocked process's lock request (hard block), or is waiting for a lock that would conflict with the blocked process's lock request and is ahead of it in the wait queue (soft block). Returns an array of the process ID(s) of the sessions that are blocking the server process with the specified process ID from acquiring a lock, or an empty array if there is no such server process or it is not blocked. Returns the process ID of the server process attached to the current session. Returns the IP port number on which the server accepted the current connection, or NULL if the current connection is via a Unix-domain socket. Returns the IP address on which the server accepted the current connection, or NULL if the current connection is via a Unix-domain socket. Returns the IP port number of the current client, or NULL if the current connection is via a Unix-domain socket. Returns the IP address of the current client, or NULL if the current connection is via a Unix-domain socket. Returns the user name of the current execution context. (Items in the current search_path setting that do not correspond to existing, searchable schemas are omitted.) If the Boolean argument is true, then implicitly-searched system schemas such as pg_catalog are included in the result. Returns an array of the names of all schemas presently in the effective search path, in their priority order. This is the schema that will be used for any tables or other named objects that are created without specifying a target schema.Ĭurrent_schemas ( include_implicit boolean ) → name Returns the name of the schema that is first in the search path (or a null value if the search path is empty). Returns the text of the currently executing query, as submitted by the client (which might contain more than one statement). (Databases are called “ catalogs” in the SQL standard, so current_catalog is the standard's spelling.) Returns the name of the current database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |