Skip to content
The latest version of DbVisualizer was released 2025-07-03DOWNLOAD HERE ->

Using Max Rows and Max Chars for Queries

Max Rows

DbVisualizer by default limits the number of rows shown in the result set tab to 20000 rows. This is done to conserve memory. If this limit prevents you from seeing the data of interest, you should first consider: 1) Using a WHERE clause in the query to only retrieve the rows of interest, 2) Exporting the table to a file.

If you really need to look at more than 20000 rows, you can change the value in the Max Rows field in the SQL Commander toolbar. Use a value of 0 or -1 to get all rows.

Roger: REPLACESQL Commander toolbar in DbVisualizer

Max Chars

Values presented in grids may be very long, potentially consuming lots of memory and affecting performance. By default, DbVisualizer visually truncates values at 1000 characters, and when it happens, there is an indicator below the grid. The Max Chars setting can be modified in Tool Properties / Data Formats category.

When the grid data is limited due to either the Max Rows or Max Chars settings, you get an indication about this in the rows/columns field in the grid status bar.

Roger: REPLACEGrid status bar showing row/column limit warnings in DbVisualizer

Along with the highlighted field, a warning pops up close to the field. You can disable this behavior in the Tool Properties dialog, in the Grid category under the General tab.