ollama_ps()

List currently running Ollama models and their resource usage

List all models currently loaded and running on your Ollama server. This function shows active models, when they will expire from memory, and how much VRAM they are using.

Samples

List running models

See which models are currently loaded:

SELECT * FROM ai.ollama_ps();

Returns:

    name     |    model     |    size    | expires_at          | size_vram
-------------+--------------+------------+---------------------+-----------
 llama2      | llama2:latest| 3825819519 | 2024-01-15 14:30:00 | 4096000000

Monitor model expiration

Check when models will unload from memory:

SELECT
    name,
    expires_at,
    expires_at - now() AS time_until_unload
FROM ai.ollama_ps()
WHERE expires_at IS NOT NULL
ORDER BY expires_at;

Check VRAM usage

See how much video memory models are consuming:

SELECT
    name,
    pg_size_pretty(size_vram) AS vram_usage,
    pg_size_pretty(size) AS total_size
FROM ai.ollama_ps()
ORDER BY size_vram DESC;

Connect to specific host

Monitor models on a remote Ollama server:

SELECT * FROM ai.ollama_ps(
    host => 'http://ollama-server:11434'
);

Total resource usage

Calculate total VRAM used by all running models:

SELECT
    count(*) AS running_models,
    pg_size_pretty(sum(size_vram)) AS total_vram
FROM ai.ollama_ps();

Arguments

Name	Type	Default	Required	Description
host	TEXT	NULL	✖	Ollama server URL (defaults to http://localhost:11434)
verbose	BOOLEAN	FALSE	✖	Enable verbose logging for debugging

Returns

TABLE: A table with the following columns:

Column	Type	Description
name	TEXT	Model name (e.g., llama2, mistral:7b)
model	TEXT	Full model identifier
size	BIGINT	Model size in bytes
digest	TEXT	SHA256 digest of the model
parent_model	TEXT	Parent model if this is a derivative
format	TEXT	Model format (typically gguf)
family	TEXT	Model family (e.g., llama, mistral)
families	JSONB	Array of model families
parameter_size	TEXT	Number of parameters (e.g., 7B, 13B)
quantization_level	TEXT	Quantization level (e.g., Q4_0, Q5_K_M)
expires_at	TIMESTAMPTZ	When the model will unload from memory
size_vram	BIGINT	VRAM usage in bytes

Related functions

• ollama_list_models(): see all installed models
• ollama_embed(): generate embeddings with a model
• ollama_chat_complete(): chat with a model