pgAdmin4 remarkably slower for some queries

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.

Browse pgadmin-support by date

  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