SELECT

    t.id_name,
    MAX(t.begin_time) AS begin_time,
    MAX(t.end_time) AS end_time,

    MAX(CASE WHEN (m.id_name = 'package-version') THEN v.VALUE END) AS package_version,
    MAX(CASE WHEN (m.id_name = 'database-vendor') THEN v.VALUE END) AS database_vendor,
    MAX(CASE WHEN (m.id_name = 'bean-name') THEN v.VALUE END) AS bean_name,
    MAX(CASE WHEN (m.id_name = 'request-distribution') THEN v.VALUE END) AS request_distribution,
    MAX(CASE WHEN (m.id_name = 'ycsb-workload') THEN v.VALUE END) AS ycsb_workload,
    MAX(CASE WHEN (m.id_name = 'record-count') THEN v.VALUE END) AS record_count,
    MAX(CASE WHEN (m.id_name = 'transaction-engine-count') THEN v.VALUE END) AS transaction_engine_count,
    MAX(CASE WHEN (m.id_name = 'transaction-engine-maxmem') THEN v.VALUE END) AS transaction_engine_maxmem,
    MAX(CASE WHEN (m.id_name = 'storage-manager-count') THEN v.VALUE END) AS storage_manager_count,
    MAX(CASE WHEN (m.id_name = 'test-instance-count') THEN v.VALUE END) AS test_instance_count,
    MAX(CASE WHEN (m.id_name = 'operation-count') THEN v.VALUE END) AS operation_count,
    MAX(CASE WHEN (m.id_name = 'update-percent') THEN v.VALUE END) AS update_percent,
    MAX(CASE WHEN (m.id_name = 'thread-count') THEN v.VALUE END) AS thread_count,

    MAX(CASE WHEN (d.id_name = 'tps') THEN r.VALUE END) AS tps,
    MAX(CASE WHEN (d.id_name = 'Memory') THEN r.VALUE END) AS memory,
    MAX(CASE WHEN (d.id_name = 'DiskWritten') THEN r.VALUE END) AS disk_written,
    MAX(CASE WHEN (d.id_name = 'PercentUserTime') THEN r.VALUE END) AS percent_user,
    MAX(CASE WHEN (d.id_name = 'PercentCpuTime') THEN r.VALUE END) AS percent_cpu,
    MAX(CASE WHEN (d.id_name = 'UserMilliseconds') THEN r.VALUE END) AS user_milliseconds,
    MAX(CASE WHEN (d.id_name = 'YcsbUpdateLatencyMicrosecs') THEN r.VALUE END) AS update_latency,
    MAX(CASE WHEN (d.id_name = 'YcsbReadLatencyMicrosecs') THEN r.VALUE END) AS read_latency,
    MAX(CASE WHEN (d.id_name = 'Updates') THEN r.VALUE END) AS updates,
    MAX(CASE WHEN (d.id_name = 'Deletes') THEN r.VALUE END) AS deletes,
    MAX(CASE WHEN (d.id_name = 'Inserts') THEN r.VALUE END) AS inserts,
    MAX(CASE WHEN (d.id_name = 'Commits') THEN r.VALUE END) AS commits,
    MAX(CASE WHEN (d.id_name = 'Rollbacks') THEN r.VALUE END) AS rollbacks,
    MAX(CASE WHEN (d.id_name = 'Objects') THEN r.VALUE END) AS objects,
    MAX(CASE WHEN (d.id_name = 'ObjectsCreated') THEN r.VALUE END) AS objects_created,
    MAX(CASE WHEN (d.id_name = 'FlowStalls') THEN r.VALUE END) AS flow_stalls,
    MAX(CASE WHEN (d.id_name = 'NodeApplyPingTime') THEN r.VALUE END) AS node_apply_ping_time,
    MAX(CASE WHEN (d.id_name = 'NodePingTime') THEN r.VALUE END) AS node_ping_time,
    MAX(CASE WHEN (d.id_name = 'ClientCncts') THEN r.VALUE END) AS client_connections,
    MAX(CASE WHEN (d.id_name = 'YcsbSuccessCount') THEN r.VALUE END) AS success_count,
    MAX(CASE WHEN (d.id_name = 'YcsbWarnCount') THEN r.VALUE END) AS warn_count,
    MAX(CASE WHEN (d.id_name = 'YcsbFailCount') THEN r.VALUE END) AS fail_count

FROM test AS t

    LEFT JOIN test_results AS r ON r.test_id = t.id
    LEFT JOIN test_variables AS v ON v.test_id = t.id
    LEFT JOIN metric_def AS d ON d.id = r.metric_def_id
    LEFT JOIN metadata_key AS m ON m.id = v.metadata_key_id

GROUP BY t.id_name

;

"GroupAggregate  (cost=5.87..225516.43 rows=926 width=81)"
"  ->  Nested Loop Left Join  (cost=5.87..53781.24 rows=940964 width=81)"
"        ->  Nested Loop Left Join  (cost=1.65..1619.61 rows=17235 width=61)"
"              ->  Index Scan using test_uc on test t  (cost=0.00..90.06 rows=926 width=36)"
"              ->  Hash Right Join  (cost=1.65..3.11 rows=19 width=29)"
"                    Hash Cond: (m.id = v.metadata_key_id)"
"                    ->  Seq Scan on metadata_key m  (cost=0.00..1.24 rows=24 width=21)"
"                    ->  Hash  (cost=1.41..1.41 rows=19 width=16)"
"                          ->  Index Scan using test_variables_test_id_idx on test_variables v  (cost=0.00..1.41 rows=19 width=16)"
"                                Index Cond: (test_id = t.id)"
"        ->  Hash Right Join  (cost=4.22..6.69 rows=55 width=28)"
"              Hash Cond: (d.id = r.metric_def_id)"
"              ->  Seq Scan on metric_def d  (cost=0.00..1.71 rows=71 width=20)"
"              ->  Hash  (cost=3.53..3.53 rows=55 width=16)"
"                    ->  Index Scan using test_results_test_id_idx on test_results r  (cost=0.00..3.53 rows=55 width=16)"
"                          Index Cond: (test_id = t.id)"