pgadmin-org / pgadmin-org/pgadmin4

"One-Time Filter" is not prominent enough

Open
#6,655 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Feature
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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.