pgadmin-org / pgadmin-org/pgadmin4
"One-Time Filter" is not prominent enough
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 3.8k
- Forks
- 891
- Avg merge
- 4d 7h
- Merged PRs (30d)
- 8
Description
When I am executing the command EXPLAIN SELECT * FROM T WHERE c = 1 AND c = 2 the result contains this line:
One-Time Filter: false
This is a very essential line, because it tells us that the execution path will actually not get executed, as the result is statically an empty result set. Hence, this line is rather optimal, as the execution time effectively is zero.
Unfortunately, pgadmin's graphical explain tool ingores that line. Instead, it draws a nice chart how the (never executed) execution path looks like, but it does conceal the fact that this execution path is never executed. Hence the user thinks that there is a need / possibility to optimize further, which is impossible. The user is forced to click on the terminating execution step to see its details, where somewhere among the diverse attributes the word "One-Time Filter: true" is actually found. This is way too hidden!
To Reproduce
Let pgadmin graphically explain: SELECT * FROM T WHERE c = 1 AND c = 2.
Expected behavior
The graphical execution path itself clearly tells the user that nothing will actually get executed in a prominent way.
For example, the execution path could be empty, or there could be some graphical representation like drawing in grey color etc.
Error message
N/A
Screenshots
N/A
Desktop (please complete the following information):
- OS: Debian Bookworm
- Version: Latest from Docker Hub
- Mode: Server
- Browser (if running in server mode): Chrome
- Package type: Container
Additional context
N/A
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The issue names pgAdmin's graphical explain tool and the SQL reproduction EXPLAIN SELECT * FROM T WHERE c = 1 AND c = 2, but no source files or tests. Reproduce the explain output first, trace how the One-Time Filter is represented in the graphical execution path, and define completion as making a statically unexecuted path prominent without requiring users to inspect node details.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- database, frontend
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100