Questions tagged [timing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
15 views

Measuring timing over many commands in psql

The \timing command finds time needed for each individual update/query. But I have a .sql file with 10000 inserts and I want to see how much time it takes. How can I achieve this?
0
votes
1answer
24 views

mysql database update possible timing issue

I have a strange situation. I have a cronjob running queue tasks one after the other. I have a delay of 1s between the tasks. After a task is run, it sets processed=1, and continues with the next one,...
2
votes
0answers
75 views

Postgres returning timing of query within actual query?

Is it possible to return the time taken for a query in postgres? Normally you would use \timing in psql, but is it possible to get this value from a query alone, i.e. that I would use in a prepared ...
0
votes
1answer
61 views

Timing issues for backups during recovery

Let's say we did a full database backup of the PRIMARY filegroup at 10:20 am. It finished at 10:45 am. We also took log backups every 5 minutes, hence 10:15, 10:20, 10:25, 10:30, 10:35, 10:40, 10:45,....