Can you run an explain query in both? And copy the results...
______________________
Saludos
Ing. Ricardo Martín Gomez
DBA - SysAdmin
De: Nikita Kiryanov <nikita@compulab.co.il> Enviado: miércoles, 6 de febrero de 2019 07:54 Para: 'Ricardo Martin Gomez'; pgadmin-support@lists.postgresql.org Asunto: RE: pgadmin3 incredibly slow over network
Hi Ricardo,
I tried to reverse the order (first HeidiSQL then pgAdmin), but the result was the same.
From: Ricardo Martin Gomez [mailto:rimartingomez@hotmail.com] Sent: Wednesday, February 6, 2019 12:43 PM To: Nikita Kiryanov <nikita@compulab.co.il>; pgadmin-support@lists.postgresql.org Subject: RE: pgadmin3 incredibly slow over network
Hi Nikita,
Are you run both querys in the same order always?
(First pgAdmin, second HeidiSQL or psql)?
Can you try run querys in different order?
(maybe the results are in memory, so it's faster the second run.)