Running queries from pgAdmin - faster than PT4?

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Running queries from pgAdmin - faster than PT4?

Postby Hellos » Tue Oct 23, 2012 7:51 am

Currently, when I run a report, it usually takes over an hour to get results in PT4. I've also noticed that CPU usage during that time is minimal for PT4. Would it be quicker to copy the query from the log files and run it straight from pgAdmin in order to make it faster?

If so, how can I export the results of the query as CSV rather than just having them displayed in the console?
Hellos
 
Posts: 45
Joined: Thu Dec 09, 2010 1:17 pm

Re: Running queries from pgAdmin - faster than PT4?

Postby WhiteRider » Tue Oct 23, 2012 11:30 am

If you run the exact same query then it should take the same amount of time - both PT4 and pgAdmin pass the query to the PostgreSQL service.
You may find that pgAdmin displays the results slightly faster since it is using an unformatted table, but I wouldn't expect it to be significant.

I wouldn't expect any reports in PT4 to take anywhere near that long - do you have a very large database and a system near or below our Minimum Requirements?
Is this one of the built-in reports or a custom report in My Reports? Is this for all reports or just some? Which ones?
If it is built-in reports, have you added any stats? Some stats can cause unusual grouping in reports and generate a huge amount more data - try right clicking the report and using Reset to Defaults.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 32 guests

cron