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.