↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Statistics & Metrics

pg_stat_activity.query_start

Time when the currently active query was started, or if state is not active, when the last query was started

Reading PG 18·Select a recorded version

View
pg_stat_activity
Field
query_start
SQL type
timestamp with time zone
Units named in the field definition
Not specified
Reset observation
No stats_reset field is documented for this view
documented
true
field
query_start
manual path
/docs/18/monitoring-stats.html
signature
SELECT query_start FROM pg_catalog.pg_stat_activity;
source only
false
sql type
timestamp with time zone
units mentioned
Unknown
view
pg_stat_activity

Definition PG 18

Time when the currently active query was started, or if state is not active, when the last query was started

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f