{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["How to use this template","Vendor Short List","Vendor Scoring","Results","Helper Sheet"],"not_rendered":{"charts":4,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"How to use this template","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Vendor Evaluation Dashboard for "]
[null,"PostgreSQL Performance & Monitoring Tools"]
[null,"_____________________________________"]
[]
[null,"How to Use This Template"]
[]
[]
[null,"Selecting the right PostgreSQL performance and monitoring tool can be a daunting task. This guide simplifies the process by providing a structured approach to vendor evaluation. Whether you’re managing a small database or scaling up to handle complex workloads, our dashboard will help you identify the solution that best fits your needs. Follow the steps below to make an informed decision and ensure your PostgreSQL environment runs at peak performance."]
[]
[null,"Step 1"]
[null,"Come up with your short list of vendors. We recommend starting with this list of Postgres-centric solutions. "]
[]
[null,"Step 2"]
[null,"Add chosen vendors' information into the Vendor Short List tab. This list will populate on the following tab."]
[]
[null,"Step 3"]
[null,"Prioritize features as essential or preferred on the Vendor Scoring tab. Hide/edit/delete features according to your use case."]
[]
[null,"Step 4"]
[null,"Enter vendor scores through demos, evaluations, and trials, according to your benchmarks."]
[]
[null,"Step 5"]
[null,"Check the Results tab and select the solution most suited to your needs. "]
[]
[null,"Step 6"]
[null,"Ready to start again? Click the \"Clear Data\" button on the Results tab to reset the values on Vendor Scoring."]
[]
[]
[null,"courtesy of pganalyze - tour pganalyze today"]

{"sheet":"Vendor Short List","index":1,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,2],[9,1,9,2],[37,1,37,2]]}
[]
[null,"Vendor 1","pganalyze"]
[null,"website","www.pganalyze.com"]
[null,"Sales email","sales@pganalyze.com"]
[null,"Number of customers","550+"]
[null,"Product Version"]
[null,"Trial / PoC info"]
[null,"Trial start date"]
[null,"Trial end date"]
[]
[null,"Vendor 2","Enter Name 2"]
[null,"website"]
[null,"Sales email"]
[null,"Number of customers"]
[null,"Product Version"]
[null,"Trial / PoC info"]
[null,"Trial start date"]
[null,"Trial end date"]
[]
[null,"Vendor 3","Enter Name 3"]
[null,"website"]
[null,"Sales email"]
[null,"Number of customers"]
[null,"Product Version"]
[null,"Trial / PoC info"]
[null,"Trial start date"]
[null,"Trial end date"]
[]
[null,"Vendor 4","Enter Name 4"]
[null,"website"]
[null,"Sales email"]
[null,"Number of customers"]
[null,"Product Version"]
[null,"Trial / PoC info"]
[null,"Trial start date"]
[null,"Trial end date"]
[]
[]
[null,"courtesy of pganalyze - tour pganalyze today"]

{"sheet":"Vendor Scoring","index":2,"n_rows":88,"n_cols":10,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,1,2,2],[8,1,8,2],[13,1,13,2],[18,1,18,2],[23,1,23,2],[61,1,61,2],[64,1,64,2],[72,1,72,2],[76,1,76,2],[80,1,80,2],[84,0,84,4],[85,0,85,4],[29,1,29,2],[33,1,33,2],[37,1,37,2],[43,1,43,2],[51,1,51,2],[58,1,58,2]]}
[null,null,null,"Essential","Preferred",{"$f":"'Vendor Short List'!C2","v":"pganalyze"},{"$f":"'Vendor Short List'!C11","v":"Enter Name 2"},{"$f":"'Vendor Short List'!C20","v":"Enter Name 3"},{"$f":"'Vendor Short List'!C29","v":"Enter Name 4"},"Benchmark / Notes"]
["1. Features                                                       Category totals",null,null,null,null,{"$f":"SUM(F3:F28)","v":0},0,0,0]
[null,"Query Analysis"]
[null,null,"Captures full query text & plan node details",false,false]
[null,null,"Historical query performance analysis",false,false]
[null,null,"Query execution plan comparison",false,false]
[null,null,"Auto-explain log integration",false,false]
[null,null,"Query tagging for application-level insights",false,false]
[null,"Index Management"]
[null,null,"Intelligent index recommendations based on production workloads",false,false]
[null,null,"Historical query data analysis for indexing decisions",false,false]
[null,null,"Identification of missing and unused indexes",false,false]
[null,null,"CREATE / DROP INDEX statements pre-formulated for easy implementation",false,false]
[null,"Vacuum & Bloat Management"]
[null,null,"Automated vacuum monitoring and tuning recommendations",false,false]
[null,null,"Bloat detection with detailed reporting",false,false]
[null,null,"Transaction ID freezing monitoring and advice",false,false]
[null,null,"Historical bloat trend analysis",false,false]
[null,"Monitoring & Diagnostics"]
[null,null,"Single-pane-of-glass dashboard for all database metrics",false,false]
[null,null,"Comprehensive log analysis and filtering",false,false]
[null,null,"Real-time alerting for critical events (e.g., blocking queries, replication issues)",false,false]
[null,null,"Historical trend analysis for system resource usage (CPU, I/O, locking)",false,false]
[null,"Deployment & Scalability"]
[null,null,"Flexible deployment options (cloud-hosted, on-premise, Kubernetes)",false,false]
[null,null,"Scalable to handle large environments",false,false]
[null,null,"Enterprise features like SSO, LDAP/AD integration, SAML support",false,false]
[null,null,"Acceptable impact on performance",false,false]
["2. Usability & Support                                      Category totals",null,null,null,null,{"$f":"SUM(F30:F42)","v":0},0,0,0]
[null,"Compatibility"]
[null,null,"Integration with existing infrastructure (APM tools, DevOps workflows)",false,false]
[null,null,"API access for custom integrations",false,false]
[null,null,"Support for various PostgreSQL versions",false,false]
[null,"Ease of Use"]
[null,null,"Intuitive user interface",false,false]
[null,null,"Clear and logical navigation",false,false]
[null,null,"Customizable dashboards and alerts",false,false]
[null,"Documentation & Support"]
[null,null,"Comprehensive user guides and setup documentation",false,false]
[null,null,"Access to knowledge base and troubleshooting resources",false,false]
[null,null,"Availability of vendor support (email, phone, chat)",false,false]
[null,null,"Active user community",false,false]
["3. Security Considerations                                        Category totals",null,null,null,null,{"$f":"SUM(F44:F71)","v":0},{"$f":"SUM(G44:G71)","v":0},{"$f":"SUM(H44:H71)","v":0},{"$f":"SUM(I44:I71)","v":0}]
[null,"Data Protection and Compliance"]
[null,null,"Supports encryption for data at rest",false,false]
[null,null,"Supports encryption for data in transit (SSL/TLS)",false,false]
[null,null,"Provides customizable encryption settings",false,false]
[null,null,"Offers data masking features for sensitive information",false,false]
[null,null,"Allows customizable data masking rules",false,false]
[null,null,"Complies with relevant industry standards (e.g., GDPR, HIPAA, SOC 2)",false,false]
[null,null,"Vendor provides documentation and certifications for compliance",false,false]
[null,"Access Control"]
[null,null,"Supports role-based access control (RBAC)",false,false]
[null,null,"Allows fine-grained control over user permissions",false,false]
[null,null,"Includes predefined roles (e.g., read-only, admin)",false,false]
[null,null,"Integrates with Single Sign-On (SSO) solutions",false,false]
[null,null,"Supports multi-factor authentication (MFA)",false,false]
[null,null,"Offers flexible MFA options (e.g., SMS, authenticator apps, hardware tokens)",false,false]
[null,"Cloud Security"]
[null,null,"Vendor provides robust cloud security measures (e.g., data isolation, encryption)",false,false]
[null,null,"Complies with cloud security standards (e.g., ISO 27001, CSA STAR)",false,false]
[null,"Data Retention Policies"]
[null,null,"Documented data retention policies for logs and audit trails",false,false]
[null,null,"Supports secure deletion and archiving of logs after the retention period",false,false]
[null,"Vendor Security Practices"]
[null,null,"Vendor conducts regular security assessments and vulnerability testing",false,false]
[null,null,"Vendor provides information on incident response plans",false,false]
[null,null,"Regular and timely security patches and updates are provided",false,false]
[null,null,"Vendor addresses vulnerabilities promptly",false,false]
[null,null,"Vendor undergoes regular third-party security audits",false,false]
[null,null,"Audit reports or summaries are available for review",false,false]
["4. Cost vs. Value                                                        Category totals",null,null,null,null,{"$f":"SUM(F73:F83)","v":0},0,0,0]
[null,"Pricing"]
[null,null,"Transparent pricing model (subscription, perpetual license)",false,false]
[null,null,"How does pricing scale with usage or feature needs",false,false]
[null,null,"Free trial or proof-of-concept options",false,false]
[null,"Value for Money"]
[null,null,"Features solve current painpoints",false,false]
[null,null,"Features will support future needs / scale",false,false]
[null,null,"Competitive pricing compared to other tools",true,false]
[null,"Vendor Reputation"]
[null,null,"Case studies demonstrating success",false,false]
[null,null,"Active development and regular feature updates",false,false]
[]
["Total Score",null,null,null,null,{"$f":"SUM(F4:F28)+SUM(F30:F42)+SUM(F44:F71)+SUM(F73:F83)","v":0},{"$f":"SUM(G4:G28)+SUM(G30:G42)+SUM(G44:G71)+SUM(G73:G83)","v":0},{"$f":"SUM(H4:H28)+SUM(H30:H42)+SUM(H44:H71)+SUM(H73:H83)","v":0},{"$f":"SUM(I4:I28)+SUM(I30:I42)+SUM(I44:I71)+SUM(I73:I83)","v":0}]
["No. of Essential Features Flagged as Not Available",null,null,null,null,{"$f":"COUNTIFS(F4:F83,0,$D$4:$D$83,TRUE)","v":0},{"$f":"COUNTIFS(H4:H83,0,$D$4:$D$83,TRUE)","v":0},{"$f":"COUNTIFS(I4:I83,0,$D$4:$D$83,TRUE)","v":0},{"$f":"COUNTIFS(I4:I83,0,$D$4:$D$83,TRUE)","v":0}]
[]
[null,null,"courtesy of pganalyze - tour pganalyze today"]

{"sheet":"Results","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
[]
[]
[null,"Vendor Name","High Score"]
[null,{"$f":"_xlfn.XLOOKUP(C4,'Vendor Scoring'!F85:I85,'Vendor Scoring'!F1:I1,\"\",0)","v":"pganalyze"},{"$f":"MAX('Vendor Scoring'!F85:I85)","v":0}]
[]
[]
[]
[null,"Ready to start over?"]
[]
[]
[]
[]
[]
["courtesy of pganalyze - tour pganalyze today"]

{"sheet":"Helper Sheet","index":4,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Vendor Scoring'!F1","v":"pganalyze"},{"$f":"'Vendor Scoring'!F85","v":0},null,"Features",{"$f":"'Vendor Scoring'!F2","v":0},{"$f":"'Vendor Scoring'!G2","v":0},{"$f":"'Vendor Scoring'!H2","v":0},{"$f":"'Vendor Scoring'!I2","v":0}]
[{"$f":"'Vendor Scoring'!G1","v":"Enter Name 2"},{"$f":"'Vendor Scoring'!G85","v":0},null,"Usability & Support",{"$f":"'Vendor Scoring'!F29","v":0},{"$f":"'Vendor Scoring'!G29","v":0},{"$f":"'Vendor Scoring'!H29","v":0},{"$f":"'Vendor Scoring'!I29","v":0}]
[{"$f":"'Vendor Scoring'!H1","v":"Enter Name 3"},{"$f":"'Vendor Scoring'!H85","v":0},null,"Security Considerations",{"$f":"'Vendor Scoring'!F43","v":0},{"$f":"'Vendor Scoring'!G43","v":0},{"$f":"'Vendor Scoring'!H43","v":0},{"$f":"'Vendor Scoring'!I43","v":0}]
[{"$f":"'Vendor Scoring'!I1","v":"Enter Name 4"},{"$f":"'Vendor Scoring'!I85","v":0},null,"Cost vs. Value",{"$f":"'Vendor Scoring'!F72","v":0},{"$f":"'Vendor Scoring'!G72","v":0},{"$f":"'Vendor Scoring'!H72","v":0},{"$f":"'Vendor Scoring'!I72","v":0}]