[pgAdmin][RM4590] Schema Backup fails with names that requires quoting

[Aditya Toshniwal]

Hi Hackers,

Attached is the patch to fix the schema backup with names that requires
double quotes.
Command line has special meaning for double quotes and so the command is
run without the double quotes if applied on objects. Code is changed to add
extra pairs of quotes to save our object quotes.

Also fixed a test case which was failing if certain paths had spaces in
between.

Kindly review.

-- 
Thanks and Regards,
Aditya Toshniwal
Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"


RM4590.patch
Description: Binary data

PATCH: RM #4778 - Query Plan Analyser

[Ashesh Vashi]

Hi Team,

I've implemented the query plan analyzer having similar functionality as
explain.depsez.com.

It now creates three tabs under the 'Explain' panel.
Graphical
-> Graphical Explain Plan
Table (similar to explain.depsez.com)
-> Table to analyse the plan in details.
-> Each row represents the statistics per Explain Node
-> It may contains columns like node information, exclusive timing (time
spent for this explain node excluding the child nodes), inclusive timing,
actual rows, plan rows, rowsx (misestimation between planned vs actual
rows), loop
-> Background color of exclusive, inclusive, rows changes based on their
values.
i.e.
if Percentage of exclusive, and inclusive timings of total query time is
> 90 - Red Color
> 50 - Orange (Between Red & Yellow Color)
> 10 - Yellow color
if planner misestimation for the rows is
> 1000 times - Red Color
> 100 times - Orange (Between Red & Yellow Color)
> 10 times - Yellow Color
Also - if actual rows >= plan rows then it shows up arrow, , else it shows
down arrow.

Statistics
-> It contains a HTML table for the statistics per Node Type, and a HTML
table for the statistics per table.

Please review it.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



*http://www.linkedin.com/in/asheshvashi*