Re: Slow response if pulling through pgadmin

On 11/10/2015 08:11 AM, Mammarelli, Joanne T wrote:
> Pgadmin is on the same server
>
> 316ms for a 'query analyze select * from table' when run from the command line (same directory psql is in)

I know of no such command 'query analyze..' in Postgres.

So are you using some other tool?

Or are you actually doing 'EXPLAIN ANALYZE ..'?

When you say psql are you referring to the command line client psql or
the Postgres server?

>
> The biggest concern is that we are hoping to hook up an external BI tool (such as QlikView, for example) and even with QlikView (through an odbc connector) it takes 3 minutes for the data to come back.
>
>
>
> -----Original Message-----
> From: Jim Nasby [mailto:Jim(dot)Nasby(at)BlueTreble(dot)com]
> Sent: Tuesday, November 10, 2015 11:08 AM
> To: Mammarelli, Joanne T; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Slow response if pulling through pgadmin
>
> On 11/10/15 9:39 AM, Mammarelli, Joanne T wrote:
>> Hi - same rookie user as before.
>>
>> We have one table
>>
>> 100,000 rows
>>
>> 80 columns
>>
>> When we try to retrieve the data (select * from table) using pgadmin,
>> we get a 193456 ms retrieve time.
>>
>> When I ran a query analyze in the command prompt, we get a 316ms
>> retrieve time.
>
> You mean EXPLAIN ANALYZE?
>
>> .. and finally. When we retrieve the data from the command line, we
>> get a 5720 ms retrieve time.
>
> What was psql doing with the output?
>
> Basically, pgAdmin and psql aren't meant for users to deal with huge data sets, because humans don't deal well with huge data sets.
> --
> Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com