query-stats

A command-line tool that runs a MySQL query and reports execution statistics such as row counts, data sizes, column-level metrics, and session status changes.

Usage

query-stats <dsn> [--set-var name=value ...] [--mode text|binary] [--ask-pass]

# Interactive prompt (Ctrl+D to run, Ctrl+C to abort)
query-stats mysql://address/dbname

# Pipe a query
echo "SELECT * FROM mydb.orders WHERE status = 'open'" | query-stats mysql://user:pass@address/

# Set a session variable
query-stats --set-var optimizer_switch=mrr=off mysql://user:pass@adress/

DSN Format

mysql://[user[:password]@]host[:port]/[database][?options]

If no user is specified, the current OS user is used. If no port is specified, 3306 is used.

DSN Options

Option	Description
defaultsFile=<path>	Read connection details from an ini file
defaultsGroup=<group>	Section to read from the defaults file (default: client)
ssl	Enable TLS for the connection
collation=<name>	Set the connection collation and implied character set

Size Measurement Modes

--mode text (default) - measures actual wire bytes as sent by MySQL over COM_QUERY. Integer and float column sizes vary with the value magnitude; temporal columns are their canonical string lengths (e.g. DATE is always 10 bytes).

--mode binary - reports type storage sizes as used in the binary protocol: fixed widths for integers and floats, disk-storage sizes for temporal types. Useful for estimating how much data a schema stores rather than how much a specific query transfers.

Example

=== Query Execution ===
  Execution time:   34.21 ms

=== Session Status Changes ===
  Rows Examined:
    Handler_read_key       1
    Handler_read_rnd_next  10001

  Temp Tables:
    Created_tmp_tables  1

=== Result Summary ===
  Rows returned:    10000
  Total data size:  683.6 KB

  Min row size:     27 B
  Avg row size:     69 B
  Max row size:     211 B

=== Column Statistics ===
  Column      Type     MinLen  MaxLen  AvgLen  Total     Empty  Null
  ----------  -------  ------  ------  ------  --------  -----  ----
  id          BIGINT        1       5       4   41.0 KB      -     -
  email       VARCHAR       9      36      23  226.6 KB      0     0
  status      VARCHAR       4       8       6   60.5 KB      0     0
  created_at  DATETIME     19      19      19  185.5 KB      -     -
  deleted_at  DATETIME     19      19      19  170.1 KB      -   823