release/1.3.0 (python 3.7, sqlalchemy)¶
Environment Data¶
Fact |
Value |
---|---|
Date |
2020-06-30 19:35:19 |
Machine |
x86_64 |
Kernel |
Darwin Kernel Version 19.5.0: Tue May 26 20:41:44 PDT 2020; root:xnu-6153.121.2~2/RELEASE_X86_64 |
Processor |
Intel(R) Core(TM) i5-1038NG7 CPU @ 2.00GHz |
Cores |
4 |
Virtual CPUs |
8 |
Test Times¶
create_nodes: 23.90
delete_nodes: 28.72
workfunction: 98.93
calcjob-add-local: 299.66
workchain-multiadd-local: 203.90
calcjob-add-slurm: 492.76
Final Database Statistics¶
rows | table_size_mb | index_size_mb | scans | read | fetched | ||
---|---|---|---|---|---|---|---|
table | index | ||||||
alembic_version | alembic_version_pkc | 0.0 | 0.08192 | 0.16384 | 42 | 42 | 42 |
db_dbauthinfo | db_dbauthinfo_aiidauser_id_dbcomputer_id_key | 0.0 | 0.08192 | 0.16384 | 230 | 228 | 228 |
db_dbauthinfo_pkey | 0.0 | 0.08192 | 0.16384 | 391 | 391 | 391 | |
db_dbcomment | db_dbcomment_pkey | 0.0 | 0.00000 | 0.08192 | 0 | 0 | 0 |
db_dbcomment_uuid_key | 0.0 | 0.00000 | 0.08192 | 0 | 0 | 0 | |
db_dbcomputer | db_dbcomputer_name_key | 0.0 | 0.08192 | 0.16384 | 4 | 4 | 4 |
db_dbcomputer_pkey | 0.0 | 0.08192 | 0.16384 | 2525 | 2525 | 2525 | |
db_dbcomputer_uuid_key | 0.0 | 0.08192 | 0.16384 | 0 | 0 | 0 | |
db_dbgroup | db_dbgroup_label_type_string_key | 0.0 | 0.08192 | 0.16384 | 0 | 0 | 0 |
db_dbgroup_pkey | 0.0 | 0.08192 | 0.16384 | 2002 | 2002 | 2002 | |
db_dbgroup_uuid_key | 0.0 | 0.08192 | 0.16384 | 0 | 0 | 0 | |
ix_db_dbgroup_label | 0.0 | 0.08192 | 0.16384 | 2 | 1 | 1 | |
ix_db_dbgroup_type_string | 0.0 | 0.08192 | 0.16384 | 8 | 0 | 0 | |
db_dbgroup_dbnodes | db_dbgroup_dbnodes_dbgroup_id_dbnode_id_key | 0.0 | 0.00000 | 0.40960 | 1 | 0 | 0 |
db_dbgroup_dbnodes_dbgroup_id_idx | 0.0 | 0.00000 | 0.57344 | 0 | 0 | 0 | |
db_dbgroup_dbnodes_dbnode_id_idx | 0.0 | 0.00000 | 0.40960 | 2002 | 2002 | 1002 | |
db_dbgroup_dbnodes_pkey | 0.0 | 0.00000 | 0.40960 | 0 | 0 | 0 | |
db_dblink | db_dblink_pkey | 1001.0 | 0.98304 | 0.40960 | 0 | 0 | 0 |
ix_db_dblink_input_id | 1001.0 | 0.98304 | 0.57344 | 4957 | 3788 | 3788 | |
ix_db_dblink_label | 1001.0 | 0.98304 | 0.57344 | 28 | 108 | 108 | |
ix_db_dblink_output_id | 1001.0 | 0.98304 | 0.40960 | 4919 | 4273 | 4273 | |
ix_db_dblink_type | 1001.0 | 0.98304 | 0.65536 | 55 | 562 | 562 | |
db_dblog | db_dblog_pkey | 0.0 | 0.00000 | 0.08192 | 0 | 0 | 0 |
db_dblog_uuid_key | 0.0 | 0.00000 | 0.08192 | 0 | 0 | 0 | |
ix_db_dblog_levelname | 0.0 | 0.00000 | 0.08192 | 0 | 0 | 0 | |
ix_db_dblog_loggername | 0.0 | 0.00000 | 0.08192 | 0 | 0 | 0 | |
db_dbnode | db_dbnode_pkey | 1667.0 | 13.43488 | 0.73728 | 55043 | 54837 | 50489 |
db_dbnode_uuid_key | 1667.0 | 13.43488 | 0.98304 | 108 | 108 | 108 | |
ix_db_dbnode_label | 1667.0 | 13.43488 | 1.06496 | 3 | 3 | 3 | |
ix_db_dbnode_node_type | 1667.0 | 13.43488 | 2.21184 | 12 | 0 | 0 | |
ix_db_dbnode_process_type | 1667.0 | 13.43488 | 1.31072 | 2 | 0 | 0 | |
db_dbsetting | db_dbsetting_key_key | 3.0 | 0.08192 | 0.16384 | 0 | 0 | 0 |
db_dbsetting_pkey | 3.0 | 0.08192 | 0.16384 | 85 | 85 | 85 | |
ix_db_dbsetting_key | 3.0 | 0.08192 | 0.16384 | 111 | 102 | 102 | |
db_dbuser | db_dbuser_pkey | 0.0 | 0.08192 | 0.16384 | 5870 | 5870 | 5870 |
ix_db_dbuser_email | 0.0 | 0.08192 | 0.16384 | 11 | 10 | 10 |