# pgAdmin poor performance

**URL:** <https://forum.yugabyte.com/t/pgadmin-poor-performance/807>\
**Category:** General\
**Created:** [August 22, 2020, 6:40am UTC](https://forum.yugabyte.com/t/pgadmin-poor-performance/807 "2020-08-22T06:40:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sasog23](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/sasog23/32/250_2.png) [@sasog23](https://forum.yugabyte.com/u/sasog23)\
**Post date:** [August 22, 2020, 6:40am UTC](https://forum.yugabyte.com/t/pgadmin-poor-performance/807/1 "2020-08-22T06:40:29Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)\
**Post date:** [August 24, 2020, 9:19am UTC](https://forum.yugabyte.com/t/pgadmin-poor-performance/807/2 "2020-08-24T09:19:40Z")

</div>

Hi @sasog23

Welcome to YugabyteDB Forum!

Can you paste the output of:

```auto
explain analyze select id from public.vehicle_acceptance_service limit 5;

```

Regards,  
Dorian  
Technical Support Engineer

---

<div class="post-metadata">

**Author:** ![sasog23](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/sasog23/32/250_2.png) [@sasog23](https://forum.yugabyte.com/u/sasog23)\
**Post date:** [August 24, 2020, 12:02pm UTC](https://forum.yugabyte.com/t/pgadmin-poor-performance/807/3 "2020-08-24T12:02:17Z")

</div>

```auto
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

```

---

<div class="post-metadata">

**Author:** ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)\
**Post date:** [August 24, 2020, 12:44pm UTC](https://forum.yugabyte.com/t/pgadmin-poor-performance/807/4 "2020-08-24T12:44:52Z")

</div>

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