matriv
commented
6 years ago @mfussenegger
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+-----------------------+----------------------+----------------------+
| statement | started | runtime_stats['mean'] | runtime_stats['min'] | runtime_stats['max'] |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+-----------------------+----------------------+----------------------+
| select id, name from articles union all select id, name from colors limit 100000 | 1511522711864 | 61.084568902 | 56.05933 | 177.01598 |
| select id, name from articles union all select id, name from colors limit 100000 | 1511522993906 | 61.238246462 | 56.18461 | 104.72393 |
| select id, name from articles union all select id, name from colors limit 100000 | 1511523281955 | 60.740635176 | 56.403282 | 79.595 |
| select id, name from articles union all select id, name from colors limit 100000 | 1511523569878 | 59.079783678 | 51.980526 | 97.90188 |
| select id, name from articles union all select id, name from colors order by 1, 2 limit 100000 | 1511522777872 | 274.06439332 | 255.77364 | 372.34415 |
| select id, name from articles union all select id, name from colors order by 1, 2 limit 100000 | 1511523060152 | 280.01144104 | 240.95377 | 411.05328 |
| select id, name from articles union all select id, name from colors order by 1, 2 limit 100000 | 1511523347966 | 272.69000652 | 246.19896 | 325.58798 |
| select id, name from articles union all select id, name from colors union all select id, name from articles union all select id,name from colors order by 1, 2 limit 400000 | 1511522863419 | 847.0720766000001 | 781.1391 | 917.6719 |
| select id, name from articles union all select id, name from colors union all select id, name from articles union all select id,name from colors order by 1, 2 limit 400000 | 1511523147565 | 856.9935406 | 799.8479 | 1011.6545 |
| select id, name from articles union all select id, name from colors union all select id, name from articles union all select id,name from colors order by 1, 2 limit 400000 | 1511523432982 | 885.9426827 | 804.84406 | 1395.6847 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+-----------------------+----------------------+----------------------+
@mfussenegger Please review