stats

Statistics related to postgresql

Functions:

• get_all_stats –

  Function to run and return all stats defined above

• get_db_stats –

  Function to get DB stats

• get_estimate_records_count –

  Function to return estimated number of records

• get_exec_time –

  Function to return execution time

• get_network_latency –

  Function to get network latency between client and DB

• get_table_stats –

  Function to get table statistics

get_all_stats

get_all_stats() -> Dict[str, Any]

Function to run and return all stats defined above

Returns:

• Dict[str, Any] –

  All stats (dict)

get_db_stats

get_db_stats() -> Dict[str, str]

Function to get DB stats

Returns:

• Dict[str, str] –

  DB stats (dict)

get_estimate_records_count

get_estimate_records_count(table_: str | None = None) -> int

Function to return estimated number of records

Parameters:

• table_

  (str | None, default: None ) –

  Table to look up

Returns:

• int –

  Estimated number of records

get_exec_time

get_exec_time(table_: str | None = None, records_count: int = 1000) -> float

Function to return execution time

Parameters:

• table_

  (str | None, default: None ) –

  Table to look up

• records_count

  (int, default: 1000 ) –

  Number of records to look up

Returns:

• float –

  Execution time (in secs)

get_network_latency

get_network_latency() -> float

Function to get network latency between client and DB

Returns:

• float –

  Network latency

get_table_stats

get_table_stats(table_: str | None = None) -> Dict[str, str]

Function to get table statistics

Parameters:

• table_

  (str | None, default: None ) –

  Table to look up

Returns:

• Dict[str, str] –

  Table statistics (dict)