flame-explain
flame-explain copied to clipboard
A PostgreSQL EXPLAIN ANALYZE visualizer with advanced quirk correction algorithms.
My input is too long, I'll include as a file. [tree.explain.txt](https://github.com/felixge/flame-explain/files/13848752/tree.explain.txt)
Here is the request ``` EXPLAIN (ANALYZE, FORMAT JSON, VERBOSE, BUFFERS) with ordered_candles as ( select *, RANK () OVER ( PARTITION BY symbol, length ORDER BY open_time desc )...
In the plan below the index scan on repo is looped over 200k times, but it doesn't get taken into account into the total time calculation. ```json [ { "Plan":...
# Problem Sometimes the UI needs to display big numbers, e.g. 1500000 rows like shown below: ![image](https://user-images.githubusercontent.com/15000/90109844-a98c0400-dd4c-11ea-8609-c1955b619917.png) https://flame-explain.com/visualize/treetable?gist=d95c6de7296070383aaacbd67c3c3a52 This can be difficult to read. Is it 1.5 million, or 15...
This commit implements normalizePlan which allows users to paste the raw output of psql into FlameExplain without having to first manually normalize it (i.e. remove + characters and anything else...
# Problem psql is the command line PostgreSQL client that is part of PostgreSQL itself, so it's very popular. However, when using it with `EXPLAIN ANALYZE`, it adds a lot...
# Problem 1. Select an example on the input tab, e.g. "CTESimple" 2. Go back to the input tab. 3. Click into the JSON textarea on the left, then hit...
# Problem In Safari, the grey placeholder text doesn't look right. It's missing all the newlines: ![image](https://user-images.githubusercontent.com/15000/90112540-6b90df00-dd50-11ea-9072-42befcde4342.png) This is a [known issue](https://stackoverflow.com/questions/7312623/insert-line-break-inside-placeholder-attribute-of-a-textarea), and as far as I can tell Safari...
# Problem For complex queries, the tree table may show many rows (e.g. 20+), however some of them are very unimportant compared to others. E.g. rows that take up less...
# Problem Right now the only way to reorder the columns of the tree table is to click the little arrows that appear when hovering over the header: ![image](https://user-images.githubusercontent.com/15000/90110886-2a97cb00-dd4e-11ea-921a-2be22c59e5c3.png) This...