↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Statistics & Metrics

pg_stat_user_tables.last_analyze

Last time at which this table was manually analyzed

Reading PG 18·Select a recorded version

View
pg_stat_user_tables
Field
last_analyze
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
last_analyze
manual path
/docs/18/monitoring-stats.html
signature
SELECT last_analyze FROM pg_catalog.pg_stat_user_tables;
source only
false
sql type
timestamp with time zone
units mentioned
Unknown
view
pg_stat_user_tables

Definition PG 18

Last time at which this table was manually analyzed

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f