Questions tagged [timing]
6 questions
10
votes
1 answer
How to set 'timing on' permanently in PostgreSQL?
I work with PostgreSQL in the command line interface. I would like to activate a \timing command permanently for every database in the cluster so every time I connect to a database - this parameter is on.
I searched in postgresql.conf file, but I…
Yaroslav
- 405
- 5
- 10
2
votes
0 answers
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 statement?
Alexander Kleinhans
- 411
- 2
- 8
- 15
1
vote
1 answer
Set 'timing on' for the duration of the current `psql` session using command-line options
What is the equivalent of \timing on command in psql, using the psql command-line options? I am aware that this will enable timing for all psql sessions:
echo '\\timing on' >> ~/.psqlrc
I am executing an SQL file, and I am looking for an option…
Timur Shtatland
- 125
- 2
- 11
1
vote
1 answer
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?
molereddy
- 13
- 2
0
votes
1 answer
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, that has processed=0.
I have some situations…
Aris
- 113
- 4
0
votes
1 answer
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,...
Then we do a full backup for secondary…
igelr
- 2,162
- 3
- 26
- 56