The PostgreSQL cumulative-statistics framework — src/backend/utils/activity/pgstat.c (post-PG-15 shared-memory design). Loads when the user asks about pgstat views, cumulative stats, stat kinds (variable vs fixed), pending-vs-shared flush timing, adding a new stat counter, extending stats with a custom kind, wait events, backend status, IO/SLRU/WAL/replslot/subscription stats, or debugging "I ran a query but pgstat shows 0" surprises. Also use for pgstatprogress (in-progress command reporting via a separate shmem slot per backend), backendstatus.c (the process-level status the ps output + pgstatactivity read from), and waitevent.c (the taxonomy behind waiteventtype / waitevent). Skip when the ask is about extended-column statistics (pgstatistic / pgstatisticext — different subsystem: src/backend/statistics/, use extended-statistics-statext idiom), or about pgstatstatements contrib module (different, though it hooks in).
Install with
Claude CodeCodexCursorGitHub CopilotGemini CLI
Supported by the Atlas install prompt. Skill-specific requirements vary.
Skill stats
Skills1CategoryScience & researchStars0
About this skill
The PostgreSQL cumulative-statistics framework — src/backend/utils/activity/pgstat.c (post-PG-15 shared-memory design). Loads when the user asks about pgstat views, cumulative stats, stat kinds (variable vs fixed), pending-vs-shared flush timing, adding a new stat counter, extending stats with a custom kind, wait events, backend status, IO/SLRU/WAL/replslot/subscription stats, or debugging "I ran a query but pgstat shows 0" surprises. Also use for pgstatprogress (in-progress command reporting via a separate shmem slot per backend), backendstatus.c (the process-level status the ps output + pgstatactivity read from), and waitevent.c (the taxonomy behind waiteventtype / waitevent). Skip when the ask is about extended-column statistics (pgstatistic / pgstatisticext — different subsystem: src/backend/statistics/, use extended-statistics-statext idiom), or about pgstatstatements contrib module (different, though it hooks in).
Quick start
Copy the install prompt. Use the green button above this README.
Send it to your agent. Paste it into your coding agent’s chat and send.
Review the setup. Your agent checks the skill’s instructions, requirements, and installation scope.
The PostgreSQL cumulative-statistics framework — `src/backend/utils/activity/pgstat*.c` (post-PG-15 shared-memory design). Loads when the user asks about `pg_stat_*` views, cumulative stats, stat kinds (variable vs fixed), pending-vs-shared flush timing, adding a new stat counter, extending stats with a custom kind, wait events, backend status, IO/SLRU/WAL/replslot/subscription stats, or debugging "I ran a query but pg_stat shows 0" surprises. Also use for pgstat_progress_* (in-progress command reporting via a separate shmem slot per backend), backend_status.c (the process-level status the ps output + pg_stat_activity read from), and wait_event.c (the taxonomy behind `wait_event_type` / `wait_event`). Skip when the ask is about extended-column statistics (`pg_statistic` / `pg_statistic_ext` — different subsystem: `src/backend/statistics/`, use `extended-statistics-statext` idiom), or about `pg_stat_statements` contrib module (different, though it hooks in).
About this listing
Category
Science & research
Reported license
PostgreSQL
Listing language (estimated)
English
Review status
Not individually reviewed
Agent compatibility
Atlas installation supports Claude Code, Codex, and Cursor. Skill-specific dependencies and features are checked during setup.
Claude Code
Codex
Cursor
GitHub Copilot
Gemini CLI