Broken paging on ROWS tables view

sosedoff / pgweb

Cross-platform client for PostgreSQL databases

https://sosedoff.github.io/pgweb

MIT License

8.59k stars 724 forks source link

Closed Quake4 closed 6 months ago

Quake4 commented 6 months ago

sosedoff commented 6 months ago

Is there anything else you can share about the "broken view"? The screenshot alone does not give me much info your issue.

Quake4 commented 6 months ago

Must be a around 1000 rows on page, now 30k rows on page is too much.

Must be around 88 pages, but not 3.

(there was always a wrong one, strangely, it seemed to me that there were 1000 rows.)

Well, or we need a setting where i'm can set 1k rows.

sosedoff commented 6 months ago

Not sure whats going on tbh, maybe we can try to narrow this down. Could you try:

Right-click on the database name (top-left) and select "Show tables stats". This should display list of all your tables and their stats (estimated number of rows) so you can confirm size of the table in question.
Click on the pagination button when you browse table rows. It will open up a modal with current pagination setting. Default is 100, but maybe you have a different value set.

Quake4 commented 6 months ago

sorry, working...