Method Sql.pgsql()->getstatistics()
- Method getstatistics
final
mapping
(string
:mixed
) getstatistics()- Returns
A set of statistics for the current session:
"warnings_dropped"
:int
Number of warnings/notices generated by the database but not collected by the application by using error() after the statements that generated them.
"skipped_describe_count"
:int
Number of times the driver skipped asking the database to describe the statement parameters because it was already cached. Only available if PG_STATS is compile-time enabled.
"used_prepared_statements"
:int
Number of times prepared statements were used from cache instead of reparsing in the current session. Only available if PG_STATS is compile-time enabled.
"current_prepared_statements"
:int
Cache size of currently prepared statements.
"current_prepared_statement_hits"
:int
Sum of the number hits on statements in the current statement cache.
"prepared_statement_count"
:int
Total number of prepared statements generated.
"portals_opened_count"
:int
Total number of portals opened, i.e. number of statements issued to the database. Only available if PG_STATS is compile-time enabled.
"bytes_received"
:int
Total number of bytes received from the database so far.
"messages_received"
:int
Total number of messages received from the database (one SQL-statement requires multiple messages to be exchanged).
"portals_in_flight"
:int
Currently still open portals, i.e. running statements.
- Note
This function is PostgreSQL-specific.