Azure Postgresql limit. What is using it?

Question

Azure Postgresql limit. What is using it?

Rusty 0

Hello!

I'm looking at my Azure Free services for 12 months. for my Azure Database for PostgreSQL, Flexible Server Storage it shows the following. usage/limit 128% 41.08 / 32 (1 GB/Month). I assume those numbers are in GB. I'm wondering how i can find out what is using the 41.08, since my main db is only 550MB.

Thank you much in advance!

User's image

Cloudoire Academy 23,595 Reputation points Volunteer Moderator

2023-08-09T04:07:32.3866667+00:00

Check temporary files, transaction logs, and the PostgreSQL server logs

1 answer

Your answer

Cloudoire Academy 23,595 Reputation points Volunteer Moderator

2023-08-09T04:07:32.3866667+00:00

Check temporary files, transaction logs, and the PostgreSQL server logs

Answer 1

Cloudoire Academy 23,595 Volunteer Moderator

The storage you provision is the amount of storage capacity available to your Azure Database for PostgreSQL server. The storage is used for the database files, temporary files, transaction logs, and the PostgreSQL server logs. The total amount of storage you provision also defines the I/O capacity available to your server.

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-compute-storage

Rusty 0 Reputation points

2023-08-09T06:12:54.2+00:00

@Cloudoire Academy , thank you much! how do i check temporary files, transaction logs, and the PostgreSQL server logs and what i am looking for in those?
Cloudoire Academy 23,595 Reputation points Volunteer Moderator

2023-08-09T16:46:11.2966667+00:00
In Azure PostgreSQL, you don't have direct access to the file system, including temporary files.

You can use the following query to determine the size of temporary files in PostgreSQL. This query will provide you with information about the current size of temporary files in your PostgreSQL database:

SELECT pg_size_pretty(pg_stat_get_temp_files() * current_setting('block_size')::bigint) AS temp_file_size;
Cloudoire Academy 23,595 Reputation points Volunteer Moderator

2023-08-09T16:46:58.71+00:00
In the "Logs" section, you can configure log retention settings and specify whether logs should be sent to Azure Storage.

If you enable log storage in Azure Storage, log files will be stored in a designated Azure Storage account and container.

Share via

Azure Postgresql limit. What is using it?

1 answer

Your answer