有没有可能知道数据库表在过去几天里每天的大小变化？

CREATE TABLE IF NOT EXISTS table_size_history (
    record_date DATE,
    table_name VARCHAR(255),
    data_length BIGINT,
    index_length BIGINT,
    total_length BIGINT
);

INSERT INTO table_size_history (record_date, table_name, data_length, index_length, total_length)
SELECT
    CURDATE() AS record_date,
    table_name,
    data_length,
    index_length,
    data_length + index_length AS total_length
FROM
    information_schema.tables
WHERE
    table_schema = 'your_database_name';

SELECT * FROM table_size_history WHERE table_name = 'your_table_name' ORDER BY record_date;

CREATE TABLE IF NOT EXISTS table_size_history (
    record_date DATE,
    table_name TEXT,
    total_size BIGINT
);

INSERT INTO table_size_history (record_date, table_name, total_size)
SELECT
    CURRENT_DATE AS record_date,
    relname AS table_name,
    pg_total_relation_size(relid) AS total_size
FROM
    pg_catalog.pg_statio_user_tables;

SELECT * FROM table_size_history WHERE table_name = 'your_table_name' ORDER BY record_date;

CREATE TABLE IF NOT EXISTS table_size_history (
    record_date DATE,
    table_name NVARCHAR(255),
    data_size BIGINT,
    index_size BIGINT,
    total_size BIGINT
);

INSERT INTO table_size_history (record_date, table_name, data_size, index_size, total_size)
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'";

SELECT * FROM table_size_history WHERE table_name = 'your_table_name' ORDER BY record_date;

CREATE TABLE table_size_history (
    record_date DATE,
    table_name VARCHAR2(255),
    total_size NUMBER
);

INSERT INTO table_size_history (record_date, table_name, total_size)
SELECT
    SYSDATE AS record_date,
    segment_name AS table_name,
    SUM(bytes) AS total_size
FROM
    dba_segments
WHERE
    segment_type = 'TABLE' AND owner = 'YOUR_SCHEMA_NAME'
GROUP BY
    segment_name;

SELECT * FROM table_size_history WHERE table_name = 'YOUR_TABLE_NAME' ORDER BY record_date;