Browse categories
Explore
Fiverr Pro
English
$
USD
I will optimize postgresql queries and consult on apache age
About this Gig
Slow reports or timeouts? Find where PostgreSQL spends its time and get a clear plan to improve the query.
You receive execution-plan analysis, useful SQL rewrites, index recommendations and a concise report. With representative data or a suitable test environment, I compare execution and verify result equivalence. I explain storage and write tradeoffs before recommending an index.
I am an Apache AGE committer and PMC member. Cypher query review, graph modelling and AGE integration advice are available through a separately agreed custom scope.
Send your queries, PostgreSQL version, table/index definitions and current plans before ordering. We will confirm the query list and acceptance checks.
Revisions apply to the agreed queries. Server administration, application rewrites and deployment are separate. Performance depends on the workload; no fixed speedup is promised.
My freelance services are independent and are not endorsed by or provided on behalf of the Apache Software Foundation or the Apache AGE project.
Apache, Apache AGE and AGE are trademarks of the Apache Software Foundation.
Database type:
Graph database
•
Relational database
Platform:
PostgreSQL
Expertise:
SQL
•
Performance
•
Query optimization
My Portfolio
Other Databases Services I Offer
FAQ
What does each query package cover?
Basic covers 1 SELECT and up to 5 distinct tables. Standard covers up to 3 SELECTs and Premium up to 5, across 10 distinct tables total in one database. All include plan analysis, useful SQL/index recommendations and findings. Revisions cover the agreed queries.
Can you review queries without direct database access?
Yes. Start with sanitized queries, schema, indexes and existing execution plans. A measured before/after comparison needs representative data or a suitable test environment. I state what I could execute and verify; a plan-only review does not establish a measured speedup.
Is Apache AGE consultancy included in these packages?
Apache AGE consulting has a separate custom scope. I can review a Cypher query, graph model or PostgreSQL/AGE integration issue. Send your versions, relevant schema and expected result so we can agree on the question, deliverable and price before work starts.
