pgAdmin poor performance

General
1

i’m new to Yugabyte

table has 12500 rows

select id from public.vehicle_acceptance_service limit 5;

Successfully run. Total query runtime: 16 secs 49 msec.
5 rows affected.

when i try the query (graphiql) from hasura i get better results, but have same performance issue with the hasura console (unresponsive)

2

Hi @sasog23

Welcome to YugabyteDB Forum!

Can you paste the output of:

explain analyze select id from public.vehicle_acceptance_service limit 5;

Regards,
Dorian
Technical Support Engineer

3 
Limit (cost=0.00..0.50 rows=5 width=8) (actual time=57981.028..57981.038 rows=5 loops=1)"
" -> Foreign Scan on vehicle_acceptance_service (cost=0.00..100.00 rows=1000 width=8) (actual time=57981.025..57981.031 rows=5 loops=1)"
"Planning Time: 66.250 ms"
"Execution Time: 57983.139 ms
4

Can you mention your server-hardware ?
And a screenshot from http://<yb-admin-ip>:7000/tablet-servers ?