Database Manager

Usage

database_manager.get_query_statistics(qry: str)

Description

Get the query statistics for a given SQL query. The function uses the get_explain_result function from the duckdb_stats module to analyze the query.

Parameters:

qry (str) – The SQL query to analyze.

Returns:

A dictionary containing the query statistics.

Return type:

dict

Installation

DuckDB Installation: https://duckdb.org/docs/installation/?version=stable&environment=cli&platform=macos&download_method=direct

pip install duckdb