about 1 year ago by shiqi
- Enable users to highlight high cost tables in the sql editor of query history detail page:
- High cost table would be marked in orange color.
- The editor would auto scroll so the high cost table is at the middle of the view port.
- Enable users to view query history detail of queries that have not been imported from the preview table of the import flow.
- Highlight attribute field at the action center of query history detail page as JSON.
- Change layout of numeric fields in all tables to right aligned
about 1 year ago by shiqi
- Show scan cost in query detail page.
- Add action center to query detail page, which can show some useful suggestion to optimize query, like creating mv for high scan cost table, remove duplicates for explosion join and so on.
- Revamp the import flow to make it more intuitive.
about 1 year ago by shiqi
- Add unit to bytes.
- Display row count in a more friendly way.
- Add scan cost to insight page.
- Add an explanation section about fields that can be used to filter queries before import.
- Add a checkebox in simple mode of import modal to enable users to exclude queries whose signatures have been imported in this month already.
- Use consistent UX to display covered queries in materialized view detail page.
about 1 year ago by shiqi
- Allow users to specify a name for an import.
- Allow users to add a description to an import.
- Enable users to write SQL directly to filter queries for an import.
- Enhance the logic for generating similar filter groups.
- Optimize the performance of the query list component.
about 1 year ago by shiqi
- Refined the algorithm for forming Similar Filter Groups.
- Added JSON mode support to Similar Filter Groups.
- Added JSON mode support for "JOIN" column usage in the table detail page.
- Added JSON mode support for "GROUP BY" column usage in the table detail page.
- Added JSON mode support for "ORDER BY" column usage in the table detail page.
about 1 year ago by shiqi
- Add JSON mode to the "Where" column usages in the Schema tab of the Table Detail page.
- Enable sorting by column and unused column in the Insight page.
about 1 year ago by shiqi
- Turn on json mode by default
- Add column level to the column usage modal
- Do not do dedup in leaf node levels
- Enable the user to go directly to query detail page by clicking the leaf node
- Refine the table headers in schema tab of table detail page