SSD Performance Dashboard 

WITH write_4k AS (
    SELECT device, buffered_bw, direct_bw, buffered_iops, direct_iops, count
    FROM
    (
        VALUES
        ('Crucial_CT750MX300SSD1', 553260, 183169, 138315, 45792, 1),
        ('CT1000P5PSSD8', 2057752, 184133, 514438, 46033, 1),
        ('CT250MX500SSD4', 584018, 58884, 146004, 14721, 1),
        ('INTEL SSDSC2BB016T6', 524797, 165071, 131199, 41268, 1),
        ('INTEL SSDSC2BB800G4', 527433, 178580, 131858, 44645, 1),
        ('INTEL SSDSC2KB480G7', 408940, 184056, 102235, 46014, 1),
        ('INTEL SSDSC2KB480G8', 516621, 184821, 129155, 46205, 2),
        ('Micron_5100_MTFDDAV960TCB', 553489, 261468, 138372, 65367, 2),
        ('SAMSUNG MZ7KM480HMHQ-00005', 556298, 189078, 139075, 47270, 1),
        ('SAMSUNG MZ7LM960HMJP-00005', 550248, 186309, 137562, 46577, 1),
        ('Samsung SSD 980 PRO 1TB', 2046890, 23510, 511723, 5877, 1)
    ) data(device, buffered_bw, direct_bw, buffered_iops, direct_iops, count)
), device_pop AS (
    SELECT device, count, ((count::real / (SELECT sum(count) FROM write_4k)::real) * 100) AS percent
    FROM write_4k
)
SELECT vis.html(vis.visualise('SSD Performance',
    vis.dataset('write_4k', 'SSD Write Performance',(SELECT jsonb_agg(q.*) FROM write_4k q)),
    vis.dataset('device_pop', 'SSD Population', (SELECT jsonb_agg(q.*) FROM device_pop q)),
    vis.bar_chart('write-bw', 6, 'SSD Write Throughput (KiB/s)',
        vis.dataset('write_4k'),
        vis.series('Buffered IO Throughput', 'device', 'buffered_bw'),
        vis.series('Direct IO Throughput', 'device', 'direct_bw')
    ),
    vis.bar_chart('write-iops', 6, 'SSD Write IOPs',
        vis.dataset('write_4k'),
        vis.series('Buffered IO IOPs', 'device', 'buffered_iops'),
        vis.series('Direct IO IOPs', 'device', 'direct_iops')
    ),
    vis.line_chart('write-bw-line', 12, 'SSD Write Throughput (KiB/s)',
        vis.dataset('write_4k'),
        vis.series('Buffered IO Throughput', 'device', 'buffered_bw'),
        vis.series('Direct IO Throughput', 'device', 'direct_bw')
    ),
    vis.scatter_chart('write-bw-v-iops', 12, 'SSD Throughput vs IOPs',
        vis.dataset('write_4k'),
        vis.series('Buffered IO', 'buffered_iops', 'buffered_bw'),
        vis.series('Direct IO', 'direct_iops', 'direct_bw')
    ),
    vis.polar_area_chart('ssd-pop-pa', 4, 'SSD Population',
        vis.dataset('device_pop'),
        vis.series('Devices', 'device', 'count'),
        vis.option('maintainAspectRatio', true)
    ),
    vis.pie_chart('ssd-pop-pc', 4, 'SSD Population (%)',
        vis.dataset('device_pop'),
        vis.series('Devices (%)', 'device', 'percent'),
        vis.option('maintainAspectRatio', true)
    ),
    vis.data_table('ssds-tested', 4, 'SSDs Tested',
        vis.dataset('device_pop'),
        vis.column('Device Model', 'device'),
        vis.column('Samples', 'count')
    )
));