Wiki / 统计与指标

Text of this backend's most recent query. If state is active this field shows the currently executing query. In all other states, it shows the last query that was executed. By default the query text is truncated at 1024 bytes; this value can be changed via the parameter track_activity_query_size.

此版本暂无所选语言的定义，以下显示原始英文内容。

View

pg_stat_activity

Field

query

SQL type

text

Units named in the field definition

bytes

Reset observation

No stats_reset field is documented for this view

documented

true

field

query

manual path

/docs/18/monitoring-stats.html

signature

SELECT query FROM pg_catalog.pg_stat_activity;

source only

false

sql type

text

units mentioned

bytes

view

pg_stat_activity