Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.12.2020 19:27
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17261784 kB
MemAvailable 31573232 kB
Buffers 0 kB
Cached 14408152 kB
SwapCached 1968 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-04 19:27:06
DTS_END                         2020-12-04 19:27:06.9610
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33108
TRN_ID                          248991
ATT_ID                          646
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9723.78 19979 1166853
customer order: creation 183.15 337 21978
customer order: refuse 15.78 363 1894
order to supplier: creation 48.92 1252 5870
order to supplier: removal 3.29 101154 395
invoice (draft): creation 48.92 3314 5870
invoice (draft): removal 55.08 659 6609
invoice accept: apply 44.75 18550 5370
invoice accept: cancel 49.48 921 5938
customer reserve: creation 4132.75 184 495930
customer reserve: removal 4826.34 54 579161
realization accept: apply 90.71 183 10885
realization accept: cancel 86.73 113 10407
payment from customer: creation 62.34 112 7481
payment from customer: removal 5.59 99 671
payment to supplier: creation 52.38 130 6286
payment to supplier: removal 3.94 86 473
service: total inventory turnovers 5.13 1107 616
service: total monetary turnovers 7.41 34 889
service: aggregate perf. data 1.05 14767 126
service: refresh index statistics 0.03 256164 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-12-2020 19:27:45 to 04-12-2020 19:27:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8598
TEST_TIME 2 7111
TEST_TIME 3 6976
TEST_TIME 4 6698
TEST_TIME 5 6063
TEST_TIME 6 5858
TEST_TIME 7 5617
TEST_TIME 8 6003
TEST_TIME 9 6352
TEST_TIME 10 6848
TEST_TIME 11 7129
TEST_TIME 12 7322
TEST_TIME 13 7740
TEST_TIME 14 7737
TEST_TIME 15 8188
TEST_TIME 16 8710
TEST_TIME 17 8888
TEST_TIME 18 9167
TEST_TIME 19 9273
TEST_TIME 20 9546
TEST_TIME 21 9791
TEST_TIME 22 9802
TEST_TIME 23 10134
TEST_TIME 24 10346
TEST_TIME 25 10514
TEST_TIME 26 10386
TEST_TIME 27 10264
TEST_TIME 28 10546
TEST_TIME 29 10671
TEST_TIME 30 11089
TEST_TIME 31 11489
TEST_TIME 32 11261
TEST_TIME 33 11120
TEST_TIME 34 11068
TEST_TIME 35 11001
TEST_TIME 36 10940
TEST_TIME 37 10765
TEST_TIME 38 10746
TEST_TIME 39 10541
TEST_TIME 40 10446
TEST_TIME 41 10327
TEST_TIME 42 10245
TEST_TIME 43 10516
TEST_TIME 44 10451
TEST_TIME 45 10297
TEST_TIME 46 10268
TEST_TIME 47 10295
TEST_TIME 48 10246
TEST_TIME 49 10292
TEST_TIME 50 10228
TEST_TIME 51 10108
TEST_TIME 52 10044
TEST_TIME 53 10026
TEST_TIME 54 9955
TEST_TIME 55 9879
TEST_TIME 56 9949
TEST_TIME 57 9835
TEST_TIME 58 9971
TEST_TIME 59 9951
TEST_TIME 60 9889
TEST_TIME 61 9988
TEST_TIME 62 10046
TEST_TIME 63 10007
TEST_TIME 64 9998
TEST_TIME 65 10110
TEST_TIME 66 10012
TEST_TIME 67 10067
TEST_TIME 68 10127
TEST_TIME 69 10144
TEST_TIME 70 10158
TEST_TIME 71 10140
TEST_TIME 72 10110
TEST_TIME 73 10034
TEST_TIME 74 10020
TEST_TIME 75 9946
TEST_TIME 76 9929
TEST_TIME 77 9889
TEST_TIME 78 9910
TEST_TIME 79 9851
TEST_TIME 80 9778
TEST_TIME 81 9698
TEST_TIME 82 9644
TEST_TIME 83 9746
TEST_TIME 84 9798
TEST_TIME 85 9758
TEST_TIME 86 9780
TEST_TIME 87 9789
TEST_TIME 88 9759
TEST_TIME 89 9781
TEST_TIME 90 9773
TEST_TIME 91 9760
TEST_TIME 92 9846
TEST_TIME 93 9823
TEST_TIME 94 9903
TEST_TIME 95 9851
TEST_TIME 96 9911
TEST_TIME 97 9891
TEST_TIME 98 9816
TEST_TIME 99 9781
TEST_TIME 100 9774
TEST_TIME 101 9725
TEST_TIME 102 9729
TEST_TIME 103 9680
TEST_TIME 104 9631
TEST_TIME 105 9602
TEST_TIME 106 9559
TEST_TIME 107 9579
TEST_TIME 108 9674
TEST_TIME 109 9677
TEST_TIME 110 9676
TEST_TIME 111 9673
TEST_TIME 112 9653
TEST_TIME 113 9654
TEST_TIME 114 9768
TEST_TIME 115 9738
TEST_TIME 116 9725
TEST_TIME 117 9744
TEST_TIME 118 9797
TEST_TIME 119 9813
TEST_TIME 120 9734

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-12-2020 19:27:48 to 04-12-2020 19:27:52.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1623803 1623803 0 0.00 0 35641 7 0 0
doc_list_biud 1623803 1623803 0 0.00 0 76809 25 0 0
sp_add_invoice_to_stock 5561 5370 191 3.43 23 170889 18551 0 191
sp_cancel_adding_invoice 5938 5938 0 0.00 5 85221 921 0 0
sp_cancel_client_order 1894 1894 0 0.00 4 19815 364 0 0
sp_cancel_customer_reserve 579161 579161 0 0.00 1 76810 54 0 0
sp_cancel_pay_from_customer 671 671 0 0.00 3 8879 100 0 0
sp_cancel_pay_to_supplier 473 473 0 0.00 3 6026 86 0 0
sp_cancel_supplier_invoice 6624 6609 15 0.22 1 16003 660 0 15
sp_cancel_supplier_order 395 395 0 0.00 7 975377 101154 0 0
sp_cancel_write_off 10407 10407 0 0.00 1 12786 113 0 0
sp_client_order 21978 21978 0 0.00 3 11656 338 0 0
sp_customer_reserve 495930 495930 0 0.00 0 80934 184 0 0
sp_fill_shopping_cart 33712 33712 0 0.00 1 10781 34 0 0
sp_fill_shopping_cart_clo_res 495920 495920 0 0.00 0 15924 11 0 0
sp_get_clo_for_invoice 5353 5353 0 0.00 0 28942 246 0 0
sp_kill_cost_storno 17489 17489 0 0.00 0 9502 54 0 0
sp_kill_qstorno_ret_qs2qd 1175733 1175733 0 0.00 0 76728 29 0 0
sp_kill_qty_storno 620642 620642 0 0.00 0 76809 64 0 0
sp_lock_selected_doc 22364 22364 0 0.00 0 11674 6 0 0
sp_make_cost_storno 30005 30005 0 0.00 0 14341 54 0 0
sp_multiply_rows_for_pdistr 30005 30005 0 0.00 0 11399 27 0 0
sp_multiply_rows_for_qdistr 21978 21978 0 0.00 0 11504 140 0 0
sp_pay_from_customer 7481 7481 0 0.00 4 13545 113 0 0
sp_pay_to_supplier 6286 6286 0 0.00 4 27028 131 0 0
sp_payment_common 13766 13766 0 0.00 1 27021 33 0 0
sp_qd_handle_on_cancel_clo 1894 1894 0 0.00 0 19785 323 0 0
sp_qd_handle_on_invoice_upd_sts 11291 11291 0 0.00 0 50544 363 0 0
sp_qd_handle_on_reserve_upd_sts 10885 10885 0 0.00 0 19177 61 0 0
sp_reserve_write_off 10885 10885 0 0.00 6 19208 184 0 0
sp_supplier_invoice 5870 5870 0 0.00 7 126755 3314 0 0
sp_supplier_order 5870 5870 0 0.00 5 28026 1253 0 0
srv_aggregate_perf_data 127 126 1 0.78 2590 102807 14768 0 1
srv_fill_mon_cache_memory 172 172 0 0.00 1117 175990 30603 0 0
srv_find_qd_qs_mism 1114772 1114772 0 0.00 0 35628 6 0 0
srv_make_invnt_saldo 616 616 0 0.00 45 64458 1108 0 0
srv_make_money_saldo 889 889 0 0.00 1 6956 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 140259 401162 256164 0 0
t$perf-abend:sp_add_invoice_to_stock 191 191 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5370 5370 0 0.00 0 27592 178 0 0
t$perf-norm:sp_cancel_adding_invoice 440 440 0 0.00 0 7036 108 0 0
t$perf-norm:sp_cancel_client_order 1894 1894 0 0.00 0 7306 19 0 0
t$perf-norm:sp_cancel_customer_reserve 770 770 0 0.00 0 3151 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 671 671 0 0.00 0 3866 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 473 473 0 0.00 0 1878 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 2152 33 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 22226 1791 0 0
t$perf-norm:sp_cancel_write_off 1048 1048 0 0.00 0 4915 22 0 0
t$perf-norm:sp_client_order 21978 21978 0 0.00 0 20365 23 0 0
t$perf-norm:sp_customer_reserve 1069 1069 0 0.00 0 3442 7 0 0
t$perf-norm:sp_pay_from_customer 7481 7481 0 0.00 0 8090 10 0 0
t$perf-norm:sp_pay_to_supplier 6286 6286 0 0.00 0 12799 18 0 0
t$perf-norm:sp_reserve_write_off 10885 10885 0 0.00 0 6496 10 0 0
t$perf-norm:sp_supplier_invoice 5870 5870 0 0.00 0 21426 23 0 0
t$perf-norm:sp_supplier_order 5870 5870 0 0.00 0 14826 20 0 0
t$perf-norm:srv_aggregate_perf_data 126 126 0 0.00 0 531 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 19811 151 0 0
t$perf-norm:srv_make_invnt_saldo 616 616 0 0.00 0 1960 22 0 0
t$perf-norm:srv_make_money_saldo 889 889 0 0.00 0 874 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 15 5 0 0
v_add_invoice_to_stock 11088 10706 382 3.44 0 8326 23 0 382
v_all_customers 39944 39944 0 0.00 0 20 1 0 0
v_all_suppliers 32368 32368 0 0.00 0 26 1 0 0
v_all_wares 43956 43956 0 0.00 0 36 1 0 0
v_cancel_adding_invoice 880 880 0 0.00 0 679 7 0 0
v_cancel_client_order 3788 3788 0 0.00 0 6896 9 0 0
v_cancel_customer_prepayment 1342 1342 0 0.00 0 1734 8 0 0
v_cancel_customer_reserve 1540 1540 0 0.00 0 1751 4 0 0
v_cancel_payment_to_supplier 946 946 0 0.00 0 4432 14 0 0
v_cancel_supplier_invoice 902 872 30 3.32 0 813 13 0 30
v_cancel_supplier_order 790 790 0 0.00 0 5627 23 0 0
v_cancel_write_off 2096 2096 0 0.00 0 1974 15 0 0
v_max_id_clo_ord 5869 5869 0 0.00 0 179 1 0 0
v_max_id_clo_res 1069 1069 0 0.00 0 1570 12 0 0
v_max_id_ord_sup 5865 5865 0 0.00 0 3129 3 0 0
v_max_non_paid_invoice 1835 1835 0 0.00 0 661 3 0 0
v_max_non_paid_realizn 4000 4000 0 0.00 0 4917 5 0 0
v_min_id_clo_ord 5869 5869 0 0.00 0 3957 5 0 0
v_min_id_clo_res 1069 1069 0 0.00 0 1188 4 0 0
v_min_id_ord_sup 5865 5865 0 0.00 0 8615 10 0 0
v_min_non_paid_invoice 6285 6285 0 0.00 0 27018 20 0 0
v_min_non_paid_realizn 7481 7481 0 0.00 0 6573 19 0 0
v_our_firm 10974 10974 0 0.00 0 14 1 0 0
v_reserve_write_off 21768 21768 0 0.00 0 6902 8 0 0
x_lock_depdocs_on_canc_invoice 12111 12111 0 0.00 0 24833 120 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 16805 352 0 0
x_make_qstorno_1000_1200 5870 5870 0 0.00 2 28009 1172 0 0
x_make_qstorno_1200_2000 5870 5870 0 0.00 3 126744 3200 0 0
x_make_qstorno_2100_3300 495930 495930 0 0.00 0 80930 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-12-2020 19:27:53 to 04-12-2020 19:27:57.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:17 15509 8192000000 10252854128 10562875392 858168592 9.482 66 52 104 1 877213984 2311024 16734368
16:57:41 37846 8192000000 10363900800 10685480960 1404186608 14.632 100 81 162 1 1435211408 5023792 26001008
16:58:30 21475 8192000000 10405650528 10732421120 1454891312 15.081 100 85 170 0 1489884384 7292240 27700832
16:58:59 28779 8192000000 10436086112 10770497536 1488487136 15.376 100 94 188 0 1526858304 8061344 30309824
16:59:38 21588 8192000000 10465109648 10800381952 1515255648 15.609 100 84 168 1 1550985856 9160672 26569536
17:00:15 15882 8192000000 10476911008 10814889984 1530371088 15.740 100 92 184 1 1569824608 9978896 29474624
17:00:39 17946 8192000000 10492542000 10836647936 1542992832 15.849 100 82 164 1 1579453056 10505072 25955152
17:01:06 21006 8192000000 10511955824 10857066496 1565199920 16.041 100 86 172 0 1602768688 11002896 26565872
17:01:35 13926 8192000000 10530863968 10882568192 1578194672 16.153 100 82 164 1 1615027360 11666048 25166640
17:01:59 19727 8192000000 10551892032 10907140096 1600455408 16.343 100 82 164 0 1637563264 12173344 24934512
17:02:30 9528 8192000000 10567905232 10924670976 1625081824 16.553 100 76 152 0 1659844832 12183680 22579328
17:02:46 12459 8192000000 10596746000 10955227136 1645661872 16.728 100 84 168 1 1683176096 12735152 24779072
17:03:06 11015 8192000000 10603373344 10970001408 1659520928 16.845 100 79 158 3 1695787392 12937872 23328592
17:03:30 10453 8192000000 10629598960 10996158464 1679394464 17.012 100 85 169 1 1717034304 12108256 25531584
17:03:48 9666 8192000000 10636697600 11011026944 1701398832 17.197 100 80 160 2 1735427584 11376544 22652208
17:04:05 6579 8192000000 10651939504 11027431424 1713973792 17.302 100 79 158 0 1749071776 11775888 23322096
17:04:21 7437 8192000000 10666524480 11044720640 1721637584 17.366 100 67 134 0 1752031824 11386320 19007920
17:04:36 6972 8192000000 10689266864 11067330560 1744118736 17.553 100 77 154 0 1778057248 11841968 22096544
17:04:50 5254 8192000000 10708408400 11084271616 1761061744 17.693 100 83 167 2 1796358560 12037920 23258896
17:05:03 3694 8192000000 10700816208 11083497472 1764941248 17.725 100 79 158 1 1800594432 13244496 22408688
17:05:14 3661 8192000000 10710365872 11092942848 1776003280 17.817 100 82 161 0 1811704032 12894048 22806704
17:05:24 5253 8192000000 10724504496 11103797248 1782918576 17.874 100 82 164 1 1819200544 13440720 22841248
17:05:36 3422 8192000000 10723333184 11109728256 1790153872 17.933 100 83 164 3 1827698672 14066624 23478176
17:05:46 5178 8192000000 10737817216 11122376704 1799228448 18.008 100 83 166 1 1835496928 13078480 23190000
17:05:58 3963 8192000000 10743580368 11132440576 1809398576 18.091 100 88 175 1 1847289328 13234320 24656432
17:06:08 3026 8192000000 10753349760 11140374528 1815276608 18.139 100 78 155 0 1849613440 12371584 21965248
17:06:18 2637 8192000000 10762690336 11149733888 1824817120 18.217 100 93 184 3 1863046112 11575840 26653152
17:06:27 3953 8192000000 10760735120 11147599872 1828348304 18.246 100 82 163 2 1862896048 11405200 23142544
17:06:38 6292 8192000000 10776041984 11164532736 1830721776 18.265 100 86 172 1 1868501040 13787776 23991488
17:06:51 1745 8192000000 10789795312 11178471424 1846671168 18.395 100 92 184 1 1885891264 13580048 25640048
17:07:00 1603 8192000000 10790788096 11179778048 1848165728 18.407 100 89 178 1 1886454288 13130704 25157856
17:07:08 2038 8192000000 10795775040 11185811456 1854911168 18.462 100 84 168 1 1891280272 12978784 23390320
17:07:16 2239 8192000000 10799166464 11189858304 1859687728 18.501 100 91 181 1 1897874672 13138992 25047952
17:07:25 2213 8192000000 10797542800 11191668736 1862984352 18.527 100 84 166 2 1899562288 12581424 23996512
17:07:33 1336 8192000000 10813594016 11200966656 1866616208 18.557 100 87 174 0 1905057168 14192848 24248112
17:07:41 1503 8192000000 10816155456 11209162752 1873445744 18.612 100 93 184 2 1911575472 13081168 25048560
17:07:49 1611 8192000000 10809041232 11204268032 1870205744 18.586 100 91 181 1 1910414624 13639360 26569520
17:07:57 1333 8192000000 10821968000 11214266368 1878149200 18.650 100 94 192 0 1916344896 11718784 26476912
17:08:05 3633 8192000000 10802307104 11211436032 1876663296 18.638 100 74 147 1 1910211280 13269168 20278816
17:08:21 4417 8192000000 10817153488 11212873728 1880881104 18.672 100 70 138 3 1911071952 10140864 20049984
17:08:32 2000 8192000000 10808910720 11215507456 1880969520 18.673 100 60 120 0 1910561808 11082640 18509648
17:08:40 2731 8192000000 10819491552 11223027712 1884091344 18.698 100 66 132 0 1913128288 10549472 18487472
17:08:49 5764 8192000000 10800395680 11223252992 1886558784 18.718 100 55 110 1 1911754880 9784352 15411744
17:09:03 4961 8192000000 10801951376 11223822336 1888544080 18.734 100 40 80 0 1908227568 8440112 11243376
17:09:14 6105 8192000000 10806342640 11225235456 1890968096 18.754 100 45 89 2 1911595760 6807200 13820464
17:09:28 7830 8192000000 10798518000 11228667904 1890485792 18.750 100 28 57 2 1910125248 10878416 8761040
17:09:42 5850 8192000000 10805196544 11230654464 1894057808 18.778 100 39 77 4 1913348800 8634304 10656688
17:09:54 3718 8192000000 10802772816 11231744000 1894789552 18.784 100 40 79 1 1914254992 7779936 11685504
17:10:04 5017 8192000000 10811200176 11235803136 1894663984 18.783 100 39 78 0 1914465760 9036576 10765200
17:10:16 13689 8192000000 10821568464 11231608832 1900041968 18.827 100 29 57 0 1913732048 5383600 8306480
17:10:37 69575 8192000000 10808942464 11245285376 1895183408 18.788 100 27 54 0 1912701024 10008592 7509024
17:11:53 12077 8192000000 10817037680 11245690880 1896109984 18.795 100 21 42 2 1908447824 6695872 5641968
17:12:12 6102 8192000000 10816931840 11246227456 1899801808 18.825 100 22 44 1 1911737920 5307728 6628384
17:12:25 5841 8192000000 10818855152 11249405952 1900138096 18.827 100 34 66 2 1916595584 6548592 9908896
17:12:37 8425 8192000000 10823027456 11254595584 1902116736 18.843 100 23 46 0 1914189552 5373120 6699696
17:12:54 5621 8192000000 10812329040 11251666944 1903406288 18.854 100 27 54 1 1917958800 6452000 8100512
17:13:09 5327 8192000000 10825592688 11256864768 1905491968 18.870 100 32 64 2 1920182544 6029824 8660752
17:13:21 5225 8192000000 10812891840 11254546432 1903970080 18.858 100 22 44 1 1917320352 6899216 6451056
17:13:36 10116 8192000000 10808493056 11251355648 1902904432 18.850 100 16 33 3 1913602560 6331056 4367072
17:13:54 7930 8192000000 10821045744 11260182528 1913788176 18.937 100 28 57 4 1928559056 6437936 8332944
17:14:12 8736 8192000000 10823975968 11257757696 1892431216 18.765 99 22 43 0 1904640608 5804544 6404848
17:14:27 8025 8192000000 10819429328 11259817984 1910860256 18.914 100 16 33 4 1920648176 5641920 4146000
17:14:42 7591 8192000000 10822708304 11263549440 1913421072 18.934 100 19 38 0 1924327872 5583088 5323712
17:14:58 13718 8192000000 10811693632 11255726080 1892415488 18.765 99 13 24 2 1901456432 5236416 3804528
17:15:18 29600 8192000000 10829323472 11267428352 1917626048 18.968 100 27 54 2 1931937328 6093616 8217664
17:16:16 18510 8192000000 10875101904 11278372864 1907371008 18.886 99 72 145 2 1936785424 7584896 21829520
17:16:40 16560 8192000000 10806135600 11247271936 1858249968 18.489 97 12 24 1 1867753024 5691968 3811088
17:17:05 7489 8192000000 10827259936 11265257472 1912412720 18.926 100 33 65 3 1929308768 8163296 8732752
17:17:19 5145 8192000000 10827546512 11253805056 1877773120 18.647 98 39 78 2 1896122288 6536544 11812624
17:17:32 7214 8192000000 10789376512 11218046976 1843898496 18.373 98 32 64 1 1859409104 6654512 8856096
17:17:46 6889 8192000000 10802423312 11231666176 1862167472 18.521 99 35 69 0 1878554688 6446320 9940896
17:18:00 7665 8192000000 10786093952 11214929920 1844540976 18.378 98 25 50 2 1858625696 7014064 7070656
17:18:15 8009 8192000000 10783180928 11208929280 1826634544 18.232 97 29 58 1 1841003520 5945216 8423760
17:18:33 6372 8192000000 10764023840 11180912640 1787226784 17.909 96 23 46 1 1799469040 5630544 6611712
17:18:47 7060 8192000000 10762483632 11189321728 1843157744 18.367 100 29 58 2 1858377968 7434896 7785328
17:19:01 5391 8192000000 10736545776 11154542592 1787346016 17.910 97 20 40 3 1800122992 5517056 7259920
17:19:15 11018 8192000000 10708715712 11120013312 1749511376 17.598 96 24 48 0 1762218144 5777632 6929136
17:19:34 7163 8192000000 10695114448 11115249664 1754480832 17.639 97 31 62 1 1769648160 6365648 8801680
17:19:48 11162 8192000000 10706255168 11123093504 1705618976 17.232 94 18 36 1 1716313584 5069680 5624928
17:20:12 67112 8192000000 10662533136 11080134656 1670645056 16.939 93 22 44 1 1683040672 5762992 6632624
17:21:26 14068 8192000000 10698319936 11119370240 1774567952 17.805 99 15 30 1 1784913424 5645600 4699872
17:21:46 5972 8192000000 10717761040 11130429440 1758433280 17.671 97 21 42 1 1769457232 4963440 6060512
17:22:00 5701 8192000000 10726912816 11143245824 1775615280 17.813 98 38 73 4 1792101136 6105216 10380640
17:22:12 9887 8192000000 10740035232 11159326720 1816707408 18.151 100 21 42 1 1829024448 6312512 6004528
17:22:32 8620 8192000000 10739384752 11163226112 1826239120 18.229 100 28 56 1 1840460816 6286944 7934752
17:22:49 10438 8192000000 10738575840 11170697216 1832819456 18.282 100 20 39 1 1844455456 5530624 6105376
17:23:11 9251 8192000000 10749445856 11177607168 1839718976 18.339 100 21 40 3 1851247776 5234656 6294144
17:23:29 7683 8192000000 10764812704 11190300672 1848996688 18.414 100 28 56 0 1862695968 6194064 7505216
17:23:45 6971 8192000000 10769257040 11184893952 1831871056 18.275 99 17 34 1 1841127488 4832784 4423648
17:23:58 10209 8192000000 10759822720 11192901632 1851508032 18.434 100 19 38 1 1862705904 5596800 5601072
17:24:16 7512 8192000000 10778802160 11200278528 1856665552 18.476 100 17 34 2 1868055536 6103552 5286432
17:24:30 8903 8192000000 10775657488 11202232320 1860862512 18.510 100 15 30 1 1870350768 5004496 4483760
17:24:48 10923 8192000000 10772233744 11207389184 1861520304 18.516 100 13 26 2 1870964928 5328736 4115888
17:25:06 57859 8192000000 10793170608 11214962688 1869073712 18.577 100 23 47 3 1881198224 4922672 7201840
17:26:10 33589 8192000000 10782810688 11216322560 1875003376 18.625 100 34 66 1 1895819072 11262080 9553616
17:26:53 8459 8192000000 10805880448 11228217344 1876751744 18.639 100 28 56 1 1891039024 6291488 7995792
17:27:12 14789 8192000000 10833583776 11250520064 1904021856 18.859 100 47 88 4 1923209840 7159152 12028832
17:27:34 1421 8192000000 10862636480 11273457664 1920426272 18.990 100 70 140 2 1950404208 9090176 20887760
17:27:49 40390 8192000000 10863612144 11284058112 1922248928 19.005 100 56 112 0 1951330048 13810240 15270880
17:28:39 16624 8192000000 10867287312 11290349568 1933530592 19.095 100 57 113 0 1961720240 12328800 15860848
17:29:09 17073 8192000000 10875455376 11298770944 1934134112 19.100 100 46 92 1 1959534896 11988048 13412736
17:29:36 16607 8192000000 10883613440 11304943616 1940862144 19.154 100 52 104 1 1969090192 12972976 15255072
17:30:24 38053 8192000000 10876097632 11316174848 1948778208 19.217 100 33 66 3 1972034000 13512784 9743008
17:31:15 21466 8192000000 10888687744 11319488512 1953741280 19.256 100 27 51 2 1973209568 11594992 7873296
17:31:43 17805 8192000000 10889161120 11325169664 1961952496 19.322 100 48 96 1 1988199840 11513712 14733632
17:32:10 41561 8192000000 10903778576 11336503296 1950049600 19.227 99 47 94 0 1979122480 14771952 14300928
17:33:06 8808 8192000000 10906664128 11343114240 1946268048 19.197 99 42 83 0 1979410368 21274464 11867856
17:33:30 41947 8192000000 10919206192 11351277568 1978576736 19.453 100 48 96 4 2009936240 17311328 14048176
17:34:19 5250 8192000000 10926914640 11359830016 1983617920 19.493 100 43 86 1 2017367232 20397664 13351648
17:34:49 12417 8192000000 10938457840 11370815488 1992912848 19.567 100 49 96 1 2028964368 21815952 14235568
17:35:11 6067 8192000000 10942582496 11372937216 1994368528 19.578 100 52 104 2 2032591280 22600368 15622384
17:35:26 6665 8192000000 10949523104 11379986432 1996451232 19.595 100 54 107 1 2034923216 21454528 17017456
17:35:39 6017 8192000000 10934931520 11353571328 1977683632 19.446 99 72 143 0 2021434736 22761872 20989232
17:35:53 4972 8192000000 10947749264 11375710208 1990140288 19.545 100 60 120 1 2034991760 27136496 17714976
17:36:07 2668 8192000000 10954286416 11377561600 1996082336 19.592 100 71 143 0 2041389744 23925072 21382336
17:36:17 2039 8192000000 10956108816 11381989376 1998988896 19.615 100 72 142 1 2046147744 24951776 22207072
17:36:26 1820 8192000000 10969594672 11385806848 2003837040 19.653 100 83 161 0 2053134192 25969904 23327248
17:36:35 15355 8192000000 10958709504 11390459904 2003974144 19.654 100 62 124 1 2047290608 25029008 18287456
17:37:09 11008 8192000000 10963956080 11403829248 2014778160 19.739 100 59 118 0 2062558448 28977792 18802496
17:37:29 12076 8192000000 10971402112 11411640320 2013795840 19.731 100 47 94 1 2056279136 27796672 14686624
17:37:49 5060 8192000000 10979203584 11415699456 2018669328 19.770 100 50 99 1 2065955008 31411888 15873792
17:38:08 4582 8192000000 10979185008 11409068032 2017050640 19.757 100 60 120 2 2062300128 27283952 17965536
17:38:20 4658 8192000000 10970385968 11399450624 2010917840 19.709 100 65 131 1 2054777808 24521856 19338112
17:38:32 4442 8192000000 10959386224 11383070720 1996396064 19.594 100 71 142 1 2042793872 24859808 21538000
17:38:45 1765 8192000000 10969427504 11381329920 1996557584 19.596 100 92 184 0 2050523952 27930464 26035904
17:38:54 2919 8192000000 10973542608 11390418944 1997400368 19.602 100 80 159 0 2049944592 28900560 23643664
17:39:10 13001 8192000000 10963024176 11393724416 1998842400 19.614 100 65 130 1 2048606816 29981488 19782928
17:39:31 5402 8192000000 10962730416 11390316544 2003054352 19.647 100 71 142 2 2056062352 30388192 22619808
17:39:43 4457 8192000000 10937785136 11358982144 1964055936 19.338 98 69 138 2 2011868688 27407984 20404768
17:39:56 1733 8192000000 10952905216 11375828992 1986611408 19.517 100 75 151 0 2037094960 27330496 23153056
17:40:06 1477 8192000000 10957637648 11367780352 1980320240 19.467 100 89 175 2 2034837232 27649552 26867440
17:40:14 2212 8192000000 10955369072 11376541696 1989778816 19.542 100 79 158 4 2038771600 26143232 22849552
17:40:25 6265 8192000000 10945796736 11374755840 1990937472 19.551 100 60 119 2 2035627408 26344480 18345456
17:40:38 2893 8192000000 10941174048 11369648128 1980075648 19.465 100 62 124 0 2023572144 24759280 18737216
17:40:49 7893 8192000000 10940254512 11369271296 1970003584 19.385 99 53 105 2 2011937376 24983712 16950080
17:41:04 2546 8192000000 10950423104 11371204608 1974328736 19.420 99 70 140 1 2022190752 26210592 21651424
17:41:15 4348 8192000000 10941332688 11376885760 1986044000 19.513 100 55 109 1 2029852368 26438512 17369856
17:41:29 1931 8192000000 10954306416 11370348544 1987945952 19.528 100 81 160 0 2038104912 26216976 23941984
17:41:38 6702 8192000000 10948130272 11376140288 1974077456 19.418 99 63 126 0 2021662400 28657136 18927808
17:41:53 2405 8192000000 10970774336 11387187200 1991940336 19.559 100 82 162 1 2046533968 29987904 24605728
17:42:05 1858 8192000000 10972051680 11391582208 2000520752 19.627 100 86 169 0 2057503888 31325920 25657216
17:42:14 3440 8192000000 10950489632 11378311168 1971377856 19.396 99 66 132 0 2024025872 31182144 21465872
17:42:27 5068 8192000000 10957012224 11378774016 1988997728 19.536 100 77 154 3 2044300096 32344720 22957648
17:42:39 2290 8192000000 10971213968 11379990528 1970508064 19.389 99 84 169 1 2030782864 34704784 25570016
17:42:48 7737 8192000000 10928465488 11364245504 1941929296 19.162 98 46 90 1 1990475936 33535696 15010944
17:43:03 9546 8192000000 10907873952 11352346624 1925136512 19.028 98 36 73 0 1970719392 33449344 12133536
17:43:23 16263 8192000000 10914341472 11362516992 1942525584 19.167 99 30 60 1 1983367024 30815968 10025472
17:43:48 11864 8192000000 10925663136 11370242048 1967266032 19.364 100 37 74 3 2014021568 34598864 12156672
17:44:07 7072 8192000000 10875157600 11296706560 1895974080 18.794 97 67 133 1 1949893232 33455584 20463568
17:44:21 3877 8192000000 10899149408 11325087744 1935399680 19.110 100 62 124 0 1982556192 28089824 19066688
17:44:32 9725 8192000000 10890470416 11324940288 1934478048 19.103 100 53 105 1 1981877520 31326704 16072768
17:44:49 2639 8192000000 10921907760 11342434304 1946951632 19.202 100 71 141 3 2001570320 31904832 22713856
17:44:58 3598 8192000000 10915638064 11336966144 1934813952 19.105 99 70 137 2 1989919184 33554192 21551040
17:45:13 6725 8192000000 10912660128 11321495552 1921357456 18.998 99 78 156 1 1978195600 32579920 24258224
17:45:27 7329 8192000000 10910144368 11325992960 1919430816 18.982 99 65 130 1 1975040816 35306576 20303424
17:45:44 1591 8192000000 10945351712 11347013632 1950133392 19.228 100 90 179 2 2015183184 37741744 27308048
17:45:53 1115 8192000000 10944783344 11350118400 1953886496 19.257 100 94 188 0 2023399840 39861328 29652016
17:46:00 6027 8192000000 10919257824 11345141760 1936279616 19.117 99 71 142 3 1995609776 37202064 22128096
17:46:16 5044 8192000000 10921383728 11340386304 1931780480 19.081 99 62 123 0 1984706128 33238672 19686976
17:46:28 4288 8192000000 10909751824 11338559488 1927193760 19.044 99 47 94 1 1975767008 33360064 15213184
17:46:41 6715 8192000000 10916254464 11335561216 1938230544 19.133 100 57 115 1 1991027184 34609984 18186656
17:46:57 2708 8192000000 10923519568 11335524352 1942004304 19.163 100 73 145 0 2001244800 35990592 23249904
17:47:07 3678 8192000000 10923328848 11335233536 1937956368 19.130 100 81 153 2 2001766864 39846304 23964192
17:47:17 3565 8192000000 10940423872 11346935808 1947980304 19.210 100 76 152 3 2012812752 41480608 23351840
17:47:29 3001 8192000000 10938697328 11354734592 1942546928 19.167 99 81 162 0 2010597216 42799328 25250960
17:47:43 7100 8192000000 10932850976 11357900800 1960028400 19.306 100 75 150 0 2022412320 38202128 24181792
17:47:57 13527 8192000000 10913462000 11359322112 1955490624 19.270 100 42 84 2 2000856512 31485376 13880512
17:48:21 17332 8192000000 10898595696 11331883008 1913250064 18.933 98 35 71 1 1952955744 28843664 10862016
17:48:46 14177 8192000000 10882879440 11318972416 1884640800 18.703 97 30 59 1 1924933408 30274640 10017968
17:49:12 3120 8192000000 10925294320 11341164544 1952815024 19.249 100 78 157 1 2010838688 33645456 24378208
17:49:22 4865 8192000000 10920192832 11340763136 1948376896 19.214 100 67 133 0 2003118528 34277920 20463712
17:49:34 2750 8192000000 10936609792 11349692416 1956948672 19.282 100 84 164 0 2017964976 35462496 25553808
17:49:43 2435 8192000000 10913716320 11334668288 1936659264 19.120 99 67 134 0 1996875808 39841792 20374752
17:49:56 8859 8192000000 10904808640 11340365824 1935281968 19.109 100 33 66 2 1984167840 38140352 10745520
17:50:14 17949 8192000000 10897021184 11346448384 1928317296 19.053 99 27 54 1 1978126864 40673808 9135760
17:50:40 9242 8192000000 10908056240 11331555328 1922401744 19.006 99 26 52 3 1966930064 35783568 8744752
17:50:58 10704 8192000000 10901202928 11345756160 1942464976 19.166 100 30 60 1 1989167392 35399600 11302816
17:51:18 13182 8192000000 10896366928 11344625664 1927716976 19.049 99 24 48 1 1969616720 33750304 8149440
17:51:42 7611 8192000000 10911264912 11332796416 1938886448 19.138 100 54 106 2 1984406640 29254224 16265968
17:51:57 4657 8192000000 10922602208 11350020096 1956836336 19.281 100 67 134 2 2009677040 32717680 20123024
17:52:10 6534 8192000000 10927040848 11366318080 1960771184 19.312 100 47 92 2 2013035552 38657120 13607248
17:52:26 17239 8192000000 10921433184 11365654528 1958088736 19.291 100 27 54 1 2000830560 33936352 8805472
17:53:01 15845 8192000000 10909556480 11354116096 1940955552 19.154 99 40 80 0 1986322432 32991376 12375504
17:53:39 23427 8192000000 10914584032 11353280512 1939147744 19.140 99 35 70 0 1977849088 28021024 10680320
17:54:10 6377 8192000000 10916128448 11358736384 1958629424 19.295 100 50 99 1 2004341168 30687344 15024400
17:54:23 9180 8192000000 10923622272 11363352576 1957079664 19.283 100 39 78 1 2007222240 37789680 12352896
17:54:39 18273 8192000000 10912991264 11359469568 1934678928 19.104 99 26 52 0 1983477824 39825360 8973536
17:55:31 21854 8192000000 10909612208 11367608320 1947840160 19.209 100 24 48 1 1994604704 38555040 8209504
17:55:59 12509 8192000000 10896565200 11358027776 1931976720 19.083 99 24 48 0 1977712976 37866416 7869840
17:56:41 14313 8192000000 10869104736 11323908096 1900855392 18.833 98 17 34 0 1937458304 31064880 5538032
17:57:02 36155 8192000000 10868164240 11316805632 1895467280 18.790 98 18 36 0 1934198816 32736016 5995520
17:57:47 32554 8192000000 10877388880 11326873600 1926458848 19.039 99 28 54 3 1953488416 18935152 8094416
17:58:27 33934 8192000000 10857744784 11330310144 1919487584 18.983 99 13 26 3 1948202736 24447456 4267696
17:59:13 43607 8192000000 10889504192 11329740800 1945645456 19.192 100 23 46 0 1959724432 7660144 6418832
18:00:06 69876 8192000000 10897171728 11358105600 1968309936 19.372 100 30 61 1 1984794432 8350160 8134336
18:01:22 64690 8192000000 10898307136 11364876288 1950758752 19.233 99 6 11 1 1964175920 11360272 2056896
18:02:35 87514 8192000000 10916158880 11380514816 1940667888 19.152 98 7 14 0 1956717824 14117440 1932496
18:04:09 101439 8192000000 10901663696 11364548608 1907742352 18.889 96 25 45 2 1928269024 14209408 6317264
18:06:04 25285 8192000000 10923986240 11377889280 1985859984 19.511 100 30 60 2 2004848432 9847904 9140544
18:06:35 46387 8192000000 10939608256 11397971968 1999325936 19.617 100 29 59 3 2022666432 14496032 8844464
18:07:37 175990 8192000000 10940214016 11398549504 1991552288 19.556 100 33 66 2 2019526480 17697728 10276464
18:10:41 28581 8192000000 10926110224 11378360320 1956153760 19.275 98 39 78 1 1979654000 12294320 11205920
18:11:24 88895 8192000000 10926672240 11395055616 1996778528 19.597 100 29 58 0 2013450768 7698416 8973824
18:13:00 24119 8192000000 10940794864 11401445376 2004481664 19.658 100 36 72 1 2024521648 9514624 10525360
18:13:36 46659 8192000000 10954266080 11412451328 2004031280 19.655 100 21 42 0 2026334640 16163056 6140304
18:14:33 41521 8192000000 10942801056 11399626752 1965271728 19.348 98 43 86 1 1985295088 7464592 12558768
18:15:22 22409 8192000000 10943349920 11395510272 2003408144 19.650 100 50 95 2 2025701984 8995952 13297888
18:15:51 13301 8192000000 10953493424 11409711104 2004170048 19.656 100 48 96 0 2029309616 9736448 15403120
18:16:16 46292 8192000000 10934017344 11416854528 2006555328 19.674 100 30 61 1 2031762720 16735936 8471456
18:17:23 97040 8192000000 10915526368 11389468672 1941555888 19.159 97 18 36 0 1958561696 11898288 5107520
18:19:06 34307 8192000000 10907514864 11390824448 1952900752 19.250 98 10 20 1 1969344848 13420352 3023744
18:20:22 50917 8192000000 10895698640 11372429312 1923296800 19.013 97 20 40 0 1941484816 12449568 5738448
18:21:25 76192 8192000000 10903481840 11382575104 1957247488 19.284 99 18 36 0 1978164144 15282224 5634432
18:25:14 48250 8192000000 10910005968 11407564800 1956588400 19.279 98 19 38 1 1976129840 13995024 5546416
18:26:08 123790 8192000000 10902918320 11391422464 1804847760 18.054 91 8 16 0 1820352624 13373568 2131296
18:28:18 97596 8192000000 10875843056 11355754496 1900881328 18.833 96 12 24 0 1920259072 16156240 3221504
18:30:02 110895 8192000000 10913261552 11380207616 1898162464 18.812 96 9 18 0 1917858176 17041296 2654416
18:31:59 55714 8192000000 10886980624 11364978688 1917140384 18.964 97 15 30 1 1938449744 17070352 4239008
18:33:01 39995 8192000000 10926389664 11376582656 1957250368 19.284 99 25 49 1 1976050080 11891472 6908240
18:33:55 27895 8192000000 10884446336 11337936896 1911807712 18.921 97 36 72 1 1936512832 14752880 9952240
18:34:32 58453 8192000000 10884332496 11358187520 1916065216 18.955 98 17 34 0 1935853856 15107248 4681392
18:35:45 114594 8192000000 10884376880 11351105536 1910690368 18.912 98 10 20 0 1926639792 12857008 3092416
18:37:54 57929 8192000000 10879075040 11329798144 1857912368 18.486 95 40 80 1 1881120128 11368064 11839696
18:39:00 43615 8192000000 10866344176 11314413568 1841407392 18.352 95 33 66 3 1863662160 12965904 9288864
18:39:53 61470 8192000000 10850214688 11308883968 1898441008 18.814 98 45 89 0 1920505184 9920976 12143200
18:41:20 57779 8192000000 10843002400 11295531008 1851074256 18.431 96 17 33 0 1863230560 7432704 4723600
18:42:26 46264 8192000000 10853108816 11311742976 1870606784 18.589 97 28 56 2 1891463616 12251664 8605168
18:43:42 28294 8192000000 10866566368 11322220544 1924186416 19.020 100 26 48 2 1939936192 9094288 6655488
18:44:20 75204 8192000000 10854586512 11341221888 1927230368 19.045 99 33 66 2 1945954736 9237424 9486944
18:45:55 39131 8192000000 10870555856 11338645504 1929067424 19.059 99 17 35 1 1942785072 9138576 4579072
18:46:41 65276 8192000000 10866060992 11332907008 1894762368 18.784 97 14 28 0 1909239312 10407376 4069568
18:47:59 68909 8192000000 10870211760 11343400960 1934803712 19.105 99 23 46 0 1955521696 14140064 6577920
18:49:30 69832 8192000000 10883724672 11361759232 1948342064 19.213 100 20 40 0 1976369088 21342128 6684896
18:50:52 67478 8192000000 10871263760 11354198016 1906581712 18.879 98 13 26 0 1931430832 21352240 3496880
18:52:20 21740 8192000000 10874484800 11333390336 1927711056 19.049 99 22 44 1 1942193360 8267360 6214944
18:52:48 43789 8192000000 10875845776 11348848640 1942884208 19.170 100 33 64 1 1962513680 10986944 8642528
18:53:57 44239 8192000000 10859959024 11333009408 1906169216 18.876 98 19 38 1 1919616816 8191184 5256416
18:54:52 90344 8192000000 10870694032 11331485696 1888366224 18.733 97 14 28 0 1906254656 13726288 4162144
18:56:29 8979 8192000000 10897345728 11349016576 1955090816 19.267 100 49 98 0 1982665904 13880976 13694112
18:56:53 11759 8192000000 10884913680 11335692288 1942695088 19.168 100 26 51 0 1957042496 7743936 6603472
18:57:10 17750 8192000000 10885377648 11333746688 1940182544 19.148 99 36 70 2 1958407008 8550160 9674304
18:57:35 11333 8192000000 10893211040 11346067456 1955490672 19.270 100 46 92 1 1978633728 10955616 12187440
18:57:53 13114 8192000000 10901295952 11354718208 1960412192 19.309 100 36 72 2 1982906640 12815776 9678672
18:58:14 33887 8192000000 10911380336 11365638144 1964141488 19.339 100 34 68 0 1986736176 13457424 9137264
18:58:55 55310 8192000000 10878829056 11357855744 1908095216 18.891 97 15 30 1 1928008560 16178112 3735232
19:00:01 42410 8192000000 10911727744 11363041280 1963766032 19.336 100 25 50 0 1981514560 10956816 6791712
19:00:51 48886 8192000000 10903800880 11375693824 1949212208 19.220 99 18 36 1 1968908416 14510752 5185456
19:01:46 56975 8192000000 10921154512 11373752320 1972988864 19.409 100 27 54 2 1995827232 14062720 8775648
19:02:52 24590 8192000000 10923091024 11388870656 1987127616 19.521 100 35 71 1 2013935616 17276000 9532000
19:03:28 128078 8192000000 10889802736 11364286464 1879585360 18.662 95 17 33 2 1899178128 15391456 4201312
19:06:03 81522 8192000000 10905442800 11370233856 1952651360 19.248 99 22 42 0 1964863584 6724240 5487984
19:07:36 66985 8192000000 10893812464 11361665024 1958222880 19.292 99 34 68 0 1979605088 11582976 9799232
19:08:50 26289 8192000000 10899770608 11368947712 1955296208 19.269 99 30 60 0 1974715936 10813168 8606560
19:09:34 40139 8192000000 10871399088 11343380480 1898877024 18.817 96 15 30 2 1913981760 10881504 4223232
19:10:30 80001 8192000000 10886435744 11358302208 1863310480 18.530 95 13 26 1 1879803152 12543696 3948976
19:11:56 98196 8192000000 10901684672 11385053184 1968022480 19.370 100 10 20 1 1991970240 20640528 3307232
19:13:41 65008 8192000000 10895442032 11384483840 1939998832 19.147 99 19 38 0 1967382704 21530960 5852912
19:14:54 38172 8192000000 10845430880 11327664128 1892942800 18.769 97 10 20 0 1910933872 14223312 3767760
19:15:39 38896 8192000000 10834103664 11293360128 1817843392 18.160 94 22 44 1 1835355088 11314800 6196896
19:16:29 49007 8192000000 10838286496 11298054144 1875170640 18.626 98 29 56 1 1890517600 7085760 8261200
19:17:33 36627 8192000000 10861392016 11323576320 1927135072 19.044 100 25 50 0 1944800416 10166640 7498704
19:18:17 36464 8192000000 10871629680 11317751808 1873337520 18.611 97 13 26 1 1884631296 7648784 3644992
19:19:03 24211 8192000000 10855841488 11319967744 1911518528 18.919 99 31 62 1 1928239968 8540064 8181376
19:19:38 56883 8192000000 10895576496 11349962752 1903487152 18.854 98 32 64 1 1925657632 13069280 9101200
19:20:47 89865 8192000000 10857859904 11341430784 1864970112 18.544 96 18 36 2 1890032640 20153104 4909424
19:22:23 93028 8192000000 10871996336 11332755456 1861249712 18.513 96 21 42 0 1887148752 20289200 5609840
19:24:03 88846 8192000000 10883247984 11370774528 1929892496 19.066 99 18 36 1 1954067584 19030736 5144352
19:25:52 84762 8192000000 9244312112 9497391104 396547856 4.617 21 3 6 0 400520032 3388816 583360

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 04-12-2020 19:27:59 to 04-12-2020 19:28:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 191 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-12-2020 19:28:32 to 04-12-2020 19:28:34.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          249296
MON$OLDEST_ACTIVE               249297
MON$OLDEST_SNAPSHOT             249297
MON$NEXT_TRANSACTION            249297
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2056160
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33396 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33396 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33396 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33396 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

04.12.20 19:28:35. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-12-04 19:28:37 No severe PSQL-related problems occured
04.12.20 19:28:39. End of report.