From: | johannes graën <johannes(at)selfnet(dot)de> |
---|---|
To: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | pgAdmin4 remarkably slower for some queries |
Date: | 2016-11-15 14:57:18 |
Message-ID: | CA++JNSfY0xwD86DofMF2eoBGksORMVXX7N6AG_hsERdDzMb_nQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi there,
I just stumbled upon a query that executes fast in Navicat but needs
remarkably more time in pgAdmin4. So far I hadn't noticed any
difference in both programs.
Out of curiosity, I decided to crosscheck the timings I got with other
tools. You find the results below.
Altogether, the query takes roughly 0.4 seconds when executed via psql
command line tool, using Navicat or via the Adminer web frontend.
phpPgAdmin needs about twice the time, but pgAdmin4 about four times
more. Is this due to the client server architecture? Is there a way to
get similar performance to the other tools?
Best
Johannes
[psql 9.5.5]
(9729 rows)
Time: 334.753 ms
[Navicat 11.2.15]
9729 records
0.36 sec elapsed
[Adminer 4.2.5]
9,729 rows
(0.365 s)
[phpPgAdmin 5.1]
9729 row(s)
Total runtime: 761.667 ms
SQL executed.
[pgAdmin4 1.1 (on OS X 10.11.6)]
Total query runtime: 2 secs.
9729 rows retrieved.
From | Date | Subject | |
---|---|---|---|
Next Message | Johannes Lochmann | 2016-11-15 16:00:26 | Re: PostgreSQL Audit question |
Previous Message | Doraiswamy, Balaji | 2016-11-15 14:27:57 | PostgreSQL Audit question |