Execution time is higher for a simple SQL even though i have a limit of 500 in SQL. This occur when a table has huge no of records.
Same SQL using PSQL execute in 100~200 msec, using Toad Edge 1500 ~2500 msec.
Explain plan is same in both the place. We notice there is wait event Client READ/Write when executing from TOAD Edge.
Postgres DB version -11.4
Please let us know if any information required.