pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

Data Output can't handle large columns

Open ggcampinho opened this issue 11 months ago • 0 comments

I have some events with large JSONs (average 0.8MB per JSON) stored in a table and when I try to visualize those, the Data Output interface gets flaky, blank rectangles are drawn over the next rows and it keeps freezing.

Steps to reproduce the behavior:

  1. Create a table with uuid and a jsonb
  2. Insert rows with 1MB in the jsonb field
  3. Select the table in the query tool

Expected behavior

I would expect to have the view truncating the data and rendering all the rows in a usable manner.

Screenshots

https://github.com/user-attachments/assets/ecb57cd0-784e-40e5-9de6-2ce9204e533a

Desktop:

  • Version: 9.0
  • Application Mode: Desktop
  • Commit: b02e210c68dceccc3225b1863f535d9c29e252cd 2025-02-06
  • Python Version: 3.12.8
  • Electron Version: 33.3.2
  • Browser: Chrome 130.0.6723.191
  • Operating System: macOS-15.1.1-x86_64-i386-64bit

ggcampinho avatar Feb 12 '25 12:02 ggcampinho