temp

 SELECT 

    datname AS database_name,

    temp_files,

    temp_bytes / 1024 AS temp_kb

FROM 

    pg_stat_database

WHERE 

    temp_bytes > 0

ORDER BY 

    temp_bytes DESC;

SELECT 

    query,

    temp_blks_read * current_setting('block_size')::int / 1024 AS temp_read_kb,

    temp_blks_written * current_setting('block_size')::int / 1024 AS temp_written_kb

FROM 

    pg_stat_statements

WHERE 

    temp_blks_written > 0

ORDER BY 

    temp_written_kb DESC

LIMIT 10;

SELECT datname AS database_name, temp_files, temp_bytes / 1024 AS temp_kb FROM pg_stat_database WHERE temp_bytes > 0 ORDER BY temp_bytes DESC;