pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard
verified publisher icon pgadmin-org

Unable to view 15 MB Json data which I stored as JSONB data type in pgadmin4 version 7.1

Open Ravisankar97 opened this issue 2 years ago • 3 comments

I am using timescale db to store timeseries data and json data. Why I unable to view 15 MB json data in table column which is JSONB datatype in pgadmin tool ? I am usning timescale db to store timeseries data and json data. but i could see 2 MB json data.

Ravisankar97 avatar Jun 28 '23 18:06 Ravisankar97

Hi Team,

Any updates on this ?

Ravisankar97 avatar Jul 06 '23 06:07 Ravisankar97

Did some debugging for the issue, I tried with a 25 MB JSON file, and it loads slowly but I can view it. This issue is more related to browser/nwjs as I also tried for text type on textarea with a 10 MB file which I can read easily on Firefox but on Chrome page crashes.

pravesh-sharma avatar Nov 30 '23 12:11 pravesh-sharma

This is still present issue on pgAdmin 7.8; it is impacting a lot - you can't work with large JSON. We have following observation:

This is reproducable on: Windows 10 Home with 7.8 and 8.2 MacOS Ventura 13.6.3 reproduced on 7.8

But, this bug does not exists on MacOS Ventura 13.6.3 and pgAdmin4 8.2.

jbeynar avatar Feb 06 '24 17:02 jbeynar

Hi @pravesh-sharma Found some css issues while testing with different themes.

Image Image Image Image Image Image

anilsahoo20 avatar May 23 '25 12:05 anilsahoo20

Tested and verified on snapshot build: https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2025-05-27/ Package: arm64 Environment: macOs Sonoma 14.7.1

anilsahoo20 avatar May 27 '25 06:05 anilsahoo20