Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.02.2021 01: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 17054664 kB
MemAvailable 31232076 kB
Buffers 0 kB
Cached 14621872 kB
SwapCached 4876 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 2021-02-01 01:27:15
DTS_END                         2021-02-01 01:27:15.3190
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34080
TRN_ID                          250915
ATT_ID                          733
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: 9441.73 17365 1133007
customer order: creation 183.66 333 22039
customer order: refuse 15.33 358 1839
order to supplier: creation 48.65 1208 5838
order to supplier: removal 3.66 82063 439
invoice (draft): creation 47.93 3191 5752
invoice (draft): removal 53.52 697 6422
invoice accept: apply 43.68 19160 5242
invoice accept: cancel 47.93 790 5752
customer reserve: creation 4011.58 192 481390
customer reserve: removal 4676.51 49 561181
realization accept: apply 88.43 160 10612
realization accept: cancel 83.42 96 10010
payment from customer: creation 63.31 110 7597
payment from customer: removal 5.78 65 693
payment to supplier: creation 51.52 110 6182
payment to supplier: removal 3.70 98 444
service: total inventory turnovers 5.42 1074 650
service: total monetary turnovers 6.83 26 820
service: aggregate perf. data 0.84 18548 101
service: refresh index statistics 0.03 218976 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-02-2021 01:28:10 to 01-02-2021 01:28:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2756
TEST_TIME 2 4788
TEST_TIME 3 5948
TEST_TIME 4 6423
TEST_TIME 5 6081
TEST_TIME 6 5889
TEST_TIME 7 5882
TEST_TIME 8 5869
TEST_TIME 9 6507
TEST_TIME 10 6408
TEST_TIME 11 6340
TEST_TIME 12 6286
TEST_TIME 13 6753
TEST_TIME 14 6780
TEST_TIME 15 6783
TEST_TIME 16 7011
TEST_TIME 17 7682
TEST_TIME 18 7894
TEST_TIME 19 7981
TEST_TIME 20 8269
TEST_TIME 21 8674
TEST_TIME 22 9007
TEST_TIME 23 9208
TEST_TIME 24 10009
TEST_TIME 25 9803
TEST_TIME 26 9689
TEST_TIME 27 9751
TEST_TIME 28 9731
TEST_TIME 29 10621
TEST_TIME 30 10384
TEST_TIME 31 10314
TEST_TIME 32 10351
TEST_TIME 33 10273
TEST_TIME 34 10081
TEST_TIME 35 10355
TEST_TIME 36 10376
TEST_TIME 37 10353
TEST_TIME 38 10456
TEST_TIME 39 10206
TEST_TIME 40 10048
TEST_TIME 41 10075
TEST_TIME 42 9925
TEST_TIME 43 9952
TEST_TIME 44 9911
TEST_TIME 45 9866
TEST_TIME 46 9913
TEST_TIME 47 9863
TEST_TIME 48 9750
TEST_TIME 49 9643
TEST_TIME 50 9577
TEST_TIME 51 9529
TEST_TIME 52 9515
TEST_TIME 53 9571
TEST_TIME 54 9696
TEST_TIME 55 9744
TEST_TIME 56 9694
TEST_TIME 57 9669
TEST_TIME 58 9799
TEST_TIME 59 9735
TEST_TIME 60 9778
TEST_TIME 61 9797
TEST_TIME 62 9807
TEST_TIME 63 9879
TEST_TIME 64 9892
TEST_TIME 65 9886
TEST_TIME 66 9871
TEST_TIME 67 9916
TEST_TIME 68 10018
TEST_TIME 69 9978
TEST_TIME 70 9882
TEST_TIME 71 9859
TEST_TIME 72 9831
TEST_TIME 73 9773
TEST_TIME 74 9805
TEST_TIME 75 9788
TEST_TIME 76 9763
TEST_TIME 77 9712
TEST_TIME 78 9706
TEST_TIME 79 9675
TEST_TIME 80 9624
TEST_TIME 81 9537
TEST_TIME 82 9568
TEST_TIME 83 9499
TEST_TIME 84 9562
TEST_TIME 85 9550
TEST_TIME 86 9521
TEST_TIME 87 9511
TEST_TIME 88 9580
TEST_TIME 89 9591
TEST_TIME 90 9623
TEST_TIME 91 9594
TEST_TIME 92 9658
TEST_TIME 93 9644
TEST_TIME 94 9651
TEST_TIME 95 9683
TEST_TIME 96 9708
TEST_TIME 97 9737
TEST_TIME 98 9787
TEST_TIME 99 9721
TEST_TIME 100 9678
TEST_TIME 101 9650
TEST_TIME 102 9648
TEST_TIME 103 9615
TEST_TIME 104 9596
TEST_TIME 105 9577
TEST_TIME 106 9566
TEST_TIME 107 9504
TEST_TIME 108 9518
TEST_TIME 109 9497
TEST_TIME 110 9458
TEST_TIME 111 9533
TEST_TIME 112 9503
TEST_TIME 113 9525
TEST_TIME 114 9525
TEST_TIME 115 9499
TEST_TIME 116 9548
TEST_TIME 117 9538
TEST_TIME 118 9528
TEST_TIME 119 9513
TEST_TIME 120 9442

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-02-2021 01:28:14 to 01-02-2021 01:28:17.

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 1578050 1578050 0 0.00 0 25431 6 0 0
doc_list_biud 1578050 1578050 0 0.00 0 36158 23 0 0
sp_add_invoice_to_stock 5380 5242 138 2.56 32 204514 19161 0 138
sp_cancel_adding_invoice 5752 5752 0 0.00 4 53491 791 0 0
sp_cancel_client_order 1839 1839 0 0.00 4 10382 358 0 0
sp_cancel_customer_reserve 561181 561181 0 0.00 1 26009 50 0 0
sp_cancel_pay_from_customer 693 693 0 0.00 2 3137 65 0 0
sp_cancel_pay_to_supplier 444 444 0 0.00 3 5371 98 0 0
sp_cancel_supplier_invoice 6435 6422 13 0.20 1 12443 698 0 13
sp_cancel_supplier_order 439 439 0 0.00 12 1136772 82063 0 0
sp_cancel_write_off 10010 10010 0 0.00 1 14060 97 0 0
sp_client_order 22039 22039 0 0.00 3 28832 334 0 0
sp_customer_reserve 481390 481390 0 0.00 0 77668 193 0 0
sp_fill_shopping_cart 33625 33625 0 0.00 1 16462 36 0 0
sp_fill_shopping_cart_clo_res 481390 481390 0 0.00 0 13210 11 0 0
sp_get_clo_for_invoice 5242 5242 0 0.00 0 29382 277 0 0
sp_kill_cost_storno 16899 16899 0 0.00 0 7076 49 0 0
sp_kill_qstorno_ret_qs2qd 1139233 1139233 0 0.00 0 36155 27 0 0
sp_kill_qty_storno 601497 601497 0 0.00 0 36157 60 0 0
sp_lock_selected_doc 21875 21875 0 0.00 0 9635 5 0 0
sp_make_cost_storno 29633 29633 0 0.00 0 24458 47 0 0
sp_multiply_rows_for_pdistr 29633 29633 0 0.00 0 7282 27 0 0
sp_multiply_rows_for_qdistr 22039 22039 0 0.00 0 11686 153 0 0
sp_pay_from_customer 7597 7597 0 0.00 4 13244 111 0 0
sp_pay_to_supplier 6182 6182 0 0.00 4 11301 111 0 0
sp_payment_common 13779 13779 0 0.00 1 13238 30 0 0
sp_qd_handle_on_cancel_clo 1839 1839 0 0.00 0 10372 333 0 0
sp_qd_handle_on_invoice_upd_sts 10994 10994 0 0.00 0 35215 349 0 0
sp_qd_handle_on_reserve_upd_sts 10612 10612 0 0.00 0 18106 53 0 0
sp_reserve_write_off 10612 10612 0 0.00 6 18159 160 0 0
sp_supplier_invoice 5752 5752 0 0.00 6 97181 3192 0 0
sp_supplier_order 5838 5838 0 0.00 5 44251 1209 0 0
srv_aggregate_perf_data 101 101 0 0.00 2565 286764 18549 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 1121 168434 30315 0 0
srv_find_qd_qs_mism 1082317 1082317 0 0.00 0 25426 6 0 0
srv_make_invnt_saldo 650 650 0 0.00 50 53288 1074 0 0
srv_make_money_saldo 820 820 0 0.00 1 2021 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 144431 336397 218976 0 0
t$perf-abend:sp_add_invoice_to_stock 138 138 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5242 5242 0 0.00 0 16588 187 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 0 4259 89 0 0
t$perf-norm:sp_cancel_client_order 1839 1839 0 0.00 0 5864 18 0 0
t$perf-norm:sp_cancel_customer_reserve 696 696 0 0.00 0 1547 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 693 693 0 0.00 0 1042 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 444 444 0 0.00 0 1684 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 427 427 0 0.00 0 3597 31 0 0
t$perf-norm:sp_cancel_supplier_order 439 439 0 0.00 0 22367 1372 0 0
t$perf-norm:sp_cancel_write_off 1051 1051 0 0.00 0 7331 20 0 0
t$perf-norm:sp_client_order 22039 22039 0 0.00 0 9962 21 0 0
t$perf-norm:sp_customer_reserve 1031 1031 0 0.00 0 369 2 0 0
t$perf-norm:sp_pay_from_customer 7597 7597 0 0.00 0 10050 14 0 0
t$perf-norm:sp_pay_to_supplier 6182 6182 0 0.00 0 7224 13 0 0
t$perf-norm:sp_reserve_write_off 10612 10612 0 0.00 0 8253 10 0 0
t$perf-norm:sp_supplier_invoice 5752 5752 0 0.00 0 7876 26 0 0
t$perf-norm:sp_supplier_order 5838 5838 0 0.00 0 3717 14 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 186 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 871 14 0 0
t$perf-norm:srv_make_invnt_saldo 650 650 0 0.00 0 4451 31 0 0
t$perf-norm:srv_make_money_saldo 820 820 0 0.00 0 4137 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10760 10484 276 2.56 0 3245 16 0 276
v_all_customers 40026 40026 0 0.00 0 50 1 0 0
v_all_suppliers 31724 31724 0 0.00 0 72 1 0 0
v_all_wares 44078 44078 0 0.00 0 208 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 2438 13 0 0
v_cancel_client_order 3678 3678 0 0.00 0 3949 7 0 0
v_cancel_customer_prepayment 1386 1386 0 0.00 0 3125 7 0 0
v_cancel_customer_reserve 1392 1392 0 0.00 0 3109 7 0 0
v_cancel_payment_to_supplier 888 888 0 0.00 0 2561 16 0 0
v_cancel_supplier_invoice 880 854 26 2.95 0 6762 30 0 26
v_cancel_supplier_order 878 878 0 0.00 0 3050 7 0 0
v_cancel_write_off 2102 2102 0 0.00 0 2831 14 0 0
v_max_id_clo_ord 5836 5836 0 0.00 0 398 1 0 0
v_max_id_clo_res 1031 1031 0 0.00 0 4457 13 0 0
v_max_id_ord_sup 5749 5749 0 0.00 0 4551 5 0 0
v_max_non_paid_invoice 1904 1904 0 0.00 0 3610 4 0 0
v_max_non_paid_realizn 4090 4090 0 0.00 0 4854 5 0 0
v_min_id_clo_ord 5836 5836 0 0.00 0 3780 8 0 0
v_min_id_clo_res 1031 1031 0 0.00 0 1079 3 0 0
v_min_id_ord_sup 5749 5749 0 0.00 0 5021 6 0 0
v_min_non_paid_invoice 6182 6182 0 0.00 0 10491 17 0 0
v_min_non_paid_realizn 7597 7597 0 0.00 0 10305 17 0 0
v_our_firm 11066 11066 0 0.00 0 18 1 0 0
v_reserve_write_off 21224 21224 0 0.00 0 3359 6 0 0
x_lock_depdocs_on_canc_invoice 11747 11747 0 0.00 0 32443 115 0 0
x_lock_depdocs_on_canc_sup_ord 439 439 0 0.00 0 6491 316 0 0
x_make_qstorno_1000_1200 5838 5838 0 0.00 2 44245 1126 0 0
x_make_qstorno_1200_2000 5752 5752 0 0.00 3 92151 3069 0 0
x_make_qstorno_2100_3300 481390 481390 0 0.00 0 77668 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-02-2021 01:28:18 to 01-02-2021 01:28:22.

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
22:57:19 2 8192000000 8802270352 8813711360 8233680 0.100 2 1 2 0 8353088 56848 62560
22:57:26 22360 8192000000 10271888096 10583695360 969045056 10.577 74 59 122 0 989910128 2595760 18269312
22:57:59 23058 8192000000 10347700688 10664689664 1399763024 14.593 100 82 164 0 1431891840 5092064 27036752
22:58:29 20063 8192000000 10397489408 10723717120 1434214784 14.899 100 85 170 0 1469038944 6889936 27934224
22:59:09 19536 8192000000 10419719328 10747514880 1470785152 15.221 100 88 176 0 1507835344 8539792 28510400
22:59:48 17097 8192000000 10439442544 10769973248 1490067328 15.389 100 86 172 2 1526895824 9174384 27654112
23:00:20 13633 8192000000 10452085104 10789801984 1504182944 15.513 100 83 166 0 1540944000 10099584 26661472
23:00:47 17754 8192000000 10469714912 10814906368 1527247776 15.713 100 80 160 1 1563078176 10241920 25588480
23:01:17 19063 8192000000 10519116032 10863738880 1557473856 15.974 100 79 158 1 1596696176 14708096 24514224
23:01:52 16245 8192000000 10529892736 10878816256 1586421056 16.223 100 85 169 1 1623305552 11034480 25850016
23:02:25 13325 8192000000 10559902064 10909265920 1608917488 16.415 100 85 171 1 1646783040 11525456 26340096
23:02:49 14068 8192000000 10572043696 10926780416 1624216464 16.546 100 83 166 1 1660878912 11522976 25139472
23:03:15 12717 8192000000 10579449024 10938269696 1640109488 16.681 100 79 159 1 1676740624 12692064 23939072
23:03:35 10178 8192000000 10601439120 10971361280 1661655728 16.863 100 76 152 1 1695971824 11681696 22634400
23:03:53 7710 8192000000 10623256368 10992697344 1685052096 17.060 100 69 138 0 1716334800 11152080 20130624
23:04:11 7247 8192000000 10648573296 11019251712 1715725264 17.317 100 75 150 0 1749831504 12757440 21348800
23:04:27 4538 8192000000 10662525136 11034947584 1722077600 17.370 100 81 162 2 1758937216 13660880 23198736
23:04:39 7397 8192000000 10667188720 11047989248 1730196608 17.437 100 71 142 1 1762983152 12741296 20045248
23:04:54 6517 8192000000 10680362096 11058941952 1747823712 17.584 100 79 158 0 1783165824 12411296 22930816
23:05:07 4397 8192000000 10702812896 11079409664 1756434160 17.655 100 75 151 2 1790105456 12287728 21383568
23:05:19 5187 8192000000 10706962160 11087687680 1766903824 17.741 100 82 164 1 1807650816 17506976 23240016
23:05:31 3342 8192000000 10724037024 11101061120 1782988144 17.874 100 90 180 0 1822738096 14287456 25462496
23:05:42 9285 8192000000 10721325696 11108900864 1787646784 17.912 100 76 152 1 1821840976 13335744 20858448
23:06:01 3176 8192000000 10741607920 11124584448 1797439040 17.993 100 82 165 1 1832471104 11914768 23117296
23:06:11 3787 8192000000 10741967712 11133825024 1814152432 18.130 100 75 149 1 1846792560 11872704 20767424
23:06:22 2648 8192000000 10750974096 11140182016 1817241136 18.155 100 82 164 1 1853374288 12367504 23765648
23:06:32 2289 8192000000 10765518256 11151134720 1823756848 18.208 100 82 165 1 1860959648 13633984 23568816
23:06:42 3022 8192000000 10778336848 11165278208 1834901456 18.299 100 81 162 0 1869962000 12245824 22814720
23:06:51 2868 8192000000 10788594672 11174760448 1845435600 18.385 100 82 162 3 1880578512 12744688 22398224
23:07:01 2015 8192000000 10788505168 11173752832 1844908672 18.381 100 83 163 1 1881044448 13249104 22886672
23:07:09 1685 8192000000 10798582944 11181617152 1852074720 18.439 100 91 181 1 1891578048 13548496 25954832
23:07:18 1535 8192000000 10794528896 11181338624 1854099424 18.455 100 93 186 0 1893964896 13296928 26568544
23:07:26 2301 8192000000 10805428112 11190968320 1855933264 18.470 100 83 166 0 1891454128 12423936 23096928
23:07:34 1876 8192000000 10808359600 11194531840 1862269392 18.522 100 94 183 1 1901823712 13761456 25792864
23:07:43 1031 8192000000 10803158608 11190079488 1861395184 18.515 100 96 193 1 1901935104 13629328 26910592
23:07:50 1380 8192000000 10812835504 11199574016 1863966368 18.535 100 91 183 2 1904819280 14516224 26336688
23:07:58 1908 8192000000 10812669424 11202215936 1867524800 18.564 100 93 189 1 1907462176 13737152 26200224
23:08:06 2094 8192000000 10818068656 11209056256 1876424976 18.636 100 93 187 1 1917066112 12903264 27737872
23:08:15 1371 8192000000 10827970592 11215011840 1877250464 18.643 100 95 189 1 1917331632 12855456 27225712
23:08:22 1771 8192000000 10823971584 11212152832 1881970480 18.681 100 98 197 0 1922433520 12802768 27660272
23:08:31 24230 8192000000 10778467584 11198812160 1869247968 18.578 100 50 101 0 1895298080 10985984 15064128
23:09:08 6399 8192000000 10800078000 11213348864 1875123968 18.626 100 45 90 1 1899052592 10002416 13926208
23:09:22 6196 8192000000 10782972640 11205136384 1874174320 18.618 100 33 66 0 1890604976 7005584 9425072
23:09:34 5321 8192000000 10782133008 11210821632 1871923136 18.600 100 21 42 4 1884317248 6669392 5724720
23:09:46 7567 8192000000 10796437200 11219607552 1877141200 18.642 100 28 56 4 1890425888 5046896 8237792
23:10:02 7733 8192000000 10790160944 11220443136 1881677088 18.679 100 25 48 2 1895318976 6747088 6894800
23:10:16 14767 8192000000 10783599792 11221176320 1881217040 18.675 100 11 22 2 1890072944 6044960 2810944
23:10:37 15223 8192000000 10790847344 11232059392 1887638432 18.727 100 9 18 1 1896363040 6053776 2670832
23:11:05 10169 8192000000 10792960800 11231477760 1892621824 18.767 100 19 38 1 1903794736 5631616 5541296
23:11:21 9410 8192000000 10804201136 11238662144 1896144496 18.795 100 19 38 1 1907636448 6349472 5142480
23:11:39 13547 8192000000 10798107376 11237322752 1896911152 18.801 100 7 14 0 1903948944 5174224 1863568
23:12:02 17484 8192000000 10816652512 11247558656 1902132256 18.843 100 32 65 1 1918412832 6576944 9703632
23:12:26 67893 8192000000 10820283648 11251503104 1902107312 18.843 100 26 49 2 1914486320 5379520 6999488
23:13:43 6664 8192000000 10827273200 11260764160 1901925856 18.842 100 22 42 3 1913950064 6447712 5576496
23:13:56 7916 8192000000 10833821632 11262087168 1908087216 18.891 100 28 52 2 1921218688 5140272 7991200
23:14:12 4798 8192000000 10812211504 11244945408 1896787488 18.800 100 34 68 3 1913306064 6317040 10201536
23:14:23 8127 8192000000 10815172912 11254083584 1904058080 18.859 100 32 63 3 1919257968 6138640 9061248
23:14:39 4253 8192000000 10818628560 11253166080 1905529536 18.871 100 34 68 0 1921700512 6849872 9321104
23:14:49 6782 8192000000 10819825296 11254378496 1902301968 18.845 100 16 31 2 1911827024 5431856 4093200
23:15:04 6372 8192000000 10818030464 11257331712 1906338448 18.877 100 21 43 4 1917479920 5387680 5753792
23:15:17 7453 8192000000 10818747472 11256086528 1907538784 18.887 100 26 52 4 1921462032 5448272 8474976
23:15:35 11915 8192000000 10805572768 11237482496 1874474864 18.620 99 23 46 2 1887043904 6103600 6465440
23:15:55 8556 8192000000 10802440464 11240689664 1879280944 18.659 99 25 50 2 1892714496 5381296 8052256
23:16:13 11513 8192000000 10798963984 11236593664 1872966384 18.608 99 12 24 1 1882202176 5898656 3337136
23:16:31 9229 8192000000 10793585936 11230625792 1870413488 18.588 99 27 55 4 1884452560 6012064 8027008
23:16:47 6254 8192000000 10796759728 11226562560 1862010288 18.520 99 17 34 0 1873395088 5997312 5387488
23:16:59 63062 8192000000 10826858880 11236298752 1866866944 18.559 99 35 65 2 1881131600 5276416 8988240
23:18:09 10890 8192000000 10764724592 11195437056 1801178928 18.024 96 19 39 1 1811998096 5513840 5305328
23:18:30 10172 8192000000 10737416160 11160317952 1745504032 17.564 94 24 48 2 1758830112 6383408 6942672
23:18:47 6689 8192000000 10746830544 11163246592 1805156544 18.056 99 24 48 1 1818715600 5891616 7667440
23:19:00 6310 8192000000 10739765520 11173236736 1820209600 18.179 99 24 46 2 1832804496 5943840 6651056
23:19:12 4476 8192000000 10743919216 11161493504 1821587040 18.191 100 33 66 1 1842774016 12072992 9113984
23:19:23 3869 8192000000 10677459984 11095506944 1686528496 17.072 93 29 56 0 1700230176 5767504 7934176
23:19:36 9914 8192000000 10703436144 11113836544 1720993744 17.360 96 26 53 1 1733847856 5027984 7826128
23:19:54 10308 8192000000 10708686736 11125534720 1749437696 17.597 97 22 44 3 1760868944 5349664 6081584
23:20:11 7252 8192000000 10720917776 11141431296 1787885008 17.914 99 25 50 4 1801654048 6111392 7657648
23:20:29 5841 8192000000 10737199744 11153416192 1783418816 17.878 98 33 66 0 1804068624 10735104 9914704
23:20:46 15088 8192000000 10714675536 11132358656 1759353936 17.679 97 27 54 0 1776520192 8951856 8214400
23:21:08 9338 8192000000 10736365664 11149037568 1799396864 18.009 99 28 55 3 1813349776 5637248 8315664
23:21:26 7833 8192000000 10708266848 11125342208 1768492224 17.755 98 19 39 1 1779413360 5724576 5196560
23:21:43 38558 8192000000 10733915840 11150012416 1782127904 17.867 98 24 48 1 1793712368 4856736 6727728
23:22:47 33731 8192000000 10741461344 11173191680 1815988128 18.145 99 22 43 2 1827415360 5447984 5979248
23:23:29 7481 8192000000 10765522944 11190366208 1842321440 18.360 100 24 47 0 1858733536 9455408 6956688
23:23:46 5402 8192000000 10767797024 11190784000 1847854048 18.405 100 39 79 0 1865879216 7380400 10644768
23:23:58 2546 8192000000 10780689936 11199442944 1858230048 18.489 100 53 107 2 1881680000 8335968 15113984
23:24:07 10317 8192000000 10772819616 11205414912 1858686336 18.493 100 25 50 1 1872028400 5789296 7552768
23:24:25 12062 8192000000 10783655904 11212890112 1865721776 18.550 100 28 56 1 1879090976 4613904 8755296
23:24:44 8096 8192000000 10795714640 11220254720 1868437680 18.572 100 26 49 1 1880997024 4802064 7757280
23:25:01 11382 8192000000 10780827168 11219955712 1872022784 18.601 100 13 26 1 1881627424 6015808 3588832
23:25:19 5468 8192000000 10796051648 11229741056 1882652432 18.687 100 37 75 1 1904334048 10987088 10694528
23:25:34 8632 8192000000 10800986864 11229040640 1879184816 18.659 100 22 44 5 1891469264 5242912 7041536
23:25:49 10784 8192000000 10793220016 11226771456 1880535584 18.669 100 23 45 1 1891909984 5090480 6283920
23:26:06 8518 8192000000 10798862368 11230806016 1881709696 18.679 100 16 30 0 1891438272 5474288 4254288
23:26:22 11857 8192000000 10790735184 11229040640 1881690384 18.679 100 19 38 1 1892715760 5463712 5561664
23:26:42 19878 8192000000 10813825328 11241172992 1888171792 18.731 100 14 28 0 1897703824 5071712 4460320
23:27:08 75160 8192000000 10839990016 11264778240 1890864608 18.753 99 31 60 0 1904426848 4930800 8631440
23:28:32 38598 8192000000 10855411408 11280035840 1907058064 18.883 99 53 106 0 1930984208 9105360 14820784
23:29:17 4677 8192000000 10876253904 11289366528 1934851808 19.106 100 67 134 1 1966212656 12975888 18384960
23:29:29 4612 8192000000 10879254704 11299987456 1938154192 19.132 100 62 124 0 1968652928 12984240 17514496
23:29:47 19510 8192000000 10874824896 11302514688 1937201040 19.124 100 45 90 1 1961968032 11888736 12878256
23:30:16 12433 8192000000 10869897712 11301568512 1922818144 19.009 99 53 106 1 1953550192 16087680 14644368
23:30:39 5945 8192000000 10886672160 11311554560 1942524544 19.167 100 49 97 3 1972028720 15647600 13856576
23:30:52 11849 8192000000 10889425856 11310309376 1933199808 19.092 99 59 118 2 1963807424 13314560 17293056
23:31:10 17244 8192000000 10889309344 11316396032 1951668544 19.240 100 52 103 2 1978736208 13141664 13926000
23:31:37 3463 8192000000 10922185824 11335401472 1958129344 19.291 100 81 160 1 1997101600 15472400 23499856
23:31:49 34582 8192000000 10898545472 11326730240 1953601888 19.255 100 61 122 3 1987891056 16614144 17675024
23:32:33 1742 8192000000 10895283088 11318886400 1953252464 19.252 100 61 122 0 1984009104 13021440 17735200
23:32:43 15950 8192000000 10893265856 11324391424 1959652416 19.303 100 59 118 0 1990774544 13644896 17477232
23:33:10 16944 8192000000 10913443008 11338665984 1964989024 19.346 100 59 116 1 1998536528 16884640 16662864
23:33:37 7863 8192000000 10906247808 11341041664 1966496096 19.358 100 47 93 0 1997169728 17586096 13087536
23:33:53 9542 8192000000 10923159440 11342725120 1970699824 19.391 100 60 118 1 2004664464 16970224 16994416
23:34:14 2492 8192000000 10914788784 11338338304 1968906128 19.377 100 59 116 2 2003817776 17664080 17247568
23:34:24 11674 8192000000 10911759120 11341799424 1974714848 19.423 100 53 106 0 2007958672 17637408 15606416
23:34:45 11359 8192000000 10914398240 11344449536 1972975216 19.409 100 54 108 1 2006582560 17696656 15910688
23:35:06 9410 8192000000 10921528384 11343409152 1968421376 19.373 100 61 122 2 2004886496 18938064 17527056
23:35:24 21355 8192000000 10905697680 11338489856 1951437840 19.238 99 47 94 0 1985506512 20493648 13575024
23:35:57 19561 8192000000 10898169776 11334418432 1940236272 19.149 99 53 106 0 1976952304 20495840 16220192
23:36:26 3340 8192000000 10923964384 11347771392 1969309552 19.380 100 58 112 3 2009138128 21549360 18279216
23:36:37 9514 8192000000 10913781008 11350351872 1974005232 19.417 100 52 104 2 2006964560 17420400 15538928
23:36:54 36487 8192000000 10897740288 11338891264 1953806480 19.257 99 37 74 1 1980470608 15152448 11511680
23:37:40 21453 8192000000 10899170976 11337105408 1936564064 19.119 98 43 86 0 1966325744 16836688 12924992
23:38:09 17645 8192000000 10911911632 11345088512 1948273344 19.213 99 39 77 2 1976907120 16758016 11875760
23:38:35 13419 8192000000 10918686112 11355627520 1976282096 19.435 100 44 88 2 2008112464 18211776 13618592
23:39:03 5702 8192000000 10927210048 11361615872 1978654560 19.454 100 46 91 0 2011152656 18973024 13525072
23:39:16 3981 8192000000 10930567632 11363586048 1984171472 19.498 100 56 109 2 2020332832 19008640 17152720
23:39:28 8715 8192000000 10938188752 11372023808 1987817504 19.527 100 51 102 0 2023739888 20280208 15642176
23:39:46 8104 8192000000 10898414080 11317329920 1929234880 19.061 97 62 124 0 1969739504 21468880 19035744
23:40:01 3652 8192000000 10951877408 11367219200 1984297664 19.499 100 73 146 1 2029907584 22031472 23578448
23:40:14 1736 8192000000 10969511936 11380162560 1995084512 19.584 100 82 164 1 2044274736 24539200 24651024
23:40:23 2400 8192000000 10961537344 11380776960 1989861696 19.543 100 72 144 0 2039342576 27531584 21949296
23:40:38 2332 8192000000 10970176544 11391242240 2001125872 19.632 100 78 156 0 2054798416 30094704 23577840
23:40:51 3129 8192000000 10982106976 11395706880 2009940144 19.701 100 87 175 1 2062388608 25895456 26553008
23:41:02 6953 8192000000 10963424448 11393658880 2004811632 19.661 100 74 148 0 2052252432 25436448 22004352
23:41:19 1120 8192000000 10948545024 11363921920 1975744704 19.431 99 88 176 2 2028554176 27144192 25665280
23:41:28 5040 8192000000 10966030336 11385724928 1995188208 19.585 100 79 156 2 2046241232 27633952 23419072
23:41:41 2893 8192000000 10968406992 11388010496 1998848368 19.614 100 86 170 4 2052016928 28504464 24664096
23:41:51 3422 8192000000 10971576640 11387559936 1997827360 19.606 100 86 172 2 2052286432 28790320 25668752
23:42:01 6196 8192000000 10966663056 11384201216 1983663584 19.494 99 83 163 3 2037748768 30338768 23746416
23:42:14 3259 8192000000 10981088176 11399151616 2003997888 19.654 100 86 170 4 2061872272 31925344 25949040
23:42:27 3112 8192000000 10958223184 11378286592 1978257744 19.451 99 83 164 0 2036268752 32469408 25541600
23:42:38 2696 8192000000 10953435888 11375673344 1981310528 19.475 100 70 140 1 2036429008 33253744 21864736
23:42:51 4849 8192000000 10955870864 11383873536 1989314080 19.538 100 68 134 1 2044546208 34271728 20960400
23:43:04 9507 8192000000 10942987072 11374579712 1952031792 19.243 98 57 114 2 2004702672 34251488 18419392
23:43:22 5459 8192000000 10963246256 11378708480 1964545904 19.342 99 78 156 3 2026505088 37235376 24723808
23:43:36 11277 8192000000 10947638512 11378810880 1959624544 19.303 99 65 130 1 2019868608 38982208 21261856
23:43:56 3635 8192000000 10956286048 11383246848 1979538064 19.461 100 70 140 1 2036963392 35883760 21541568
23:44:10 5450 8192000000 10950355760 11384356864 1982517584 19.485 100 65 132 0 2036417328 33381248 20518496
23:44:25 3774 8192000000 10946446144 11378225152 1963600224 19.335 99 60 119 1 2013305568 30966128 18739216
23:44:37 4757 8192000000 10949158944 11376574464 1981939264 19.480 100 66 133 0 2031923056 29243088 20740704
23:44:50 1829 8192000000 10941052976 11362979840 1961778208 19.320 99 79 156 3 2015208160 28580752 24849200
23:45:00 3244 8192000000 10935448496 11347300352 1948107424 19.211 99 73 146 2 2000529600 29998624 22423552
23:45:10 2983 8192000000 10920151152 11323985920 1912559360 18.927 98 82 163 3 1968177872 30375600 25242912
23:45:20 3528 8192000000 10921439312 11328303104 1928457312 19.055 99 88 174 3 1984746448 29992112 26297024
23:45:30 1172 8192000000 10905568896 11307048960 1923054096 19.011 99 92 184 1 1983023488 31558416 28410976
23:45:38 3764 8192000000 10910588256 11312254976 1919587920 18.984 99 82 164 1 1977288624 32568960 25131744
23:45:49 2627 8192000000 10922479792 11331035136 1940602576 19.152 100 82 164 1 1999286432 33708928 24974928
23:45:59 3631 8192000000 10897842208 11325349888 1937595040 19.128 100 62 122 0 1988535632 31916512 19024080
23:46:14 2333 8192000000 10917517936 11341971456 1951312528 19.237 100 68 136 1 2002539072 29762304 21464240
23:46:23 5350 8192000000 10917000272 11339280384 1935058672 19.107 99 73 145 1 1987053296 29341216 22653408
23:46:36 8434 8192000000 10924942608 11332239360 1940778272 19.153 100 80 160 1 1998703968 32814000 25111696
23:46:52 3031 8192000000 10928448976 11341795328 1946107568 19.195 100 79 154 1 2001464224 32261456 23095200
23:47:04 1423 8192000000 10941674432 11346247680 1948894032 19.218 100 92 184 2 2012801984 36280512 27627440
23:47:15 1824 8192000000 10932963280 11345235968 1953050512 19.251 100 78 156 1 2010993232 34413216 23529504
23:47:24 5278 8192000000 10920301792 11334524928 1925985536 19.035 99 77 154 2 1984748416 35148128 23614752
23:47:37 1948 8192000000 10928012496 11334926336 1947439472 19.206 100 87 175 2 2012913680 38798240 26675968
23:47:45 4066 8192000000 10923453296 11333922816 1940778048 19.153 100 76 149 1 2001478048 38027984 22672016
23:47:56 2895 8192000000 10931310496 11340185600 1945206704 19.188 100 86 170 3 2009086960 38373008 25507248
23:48:06 5236 8192000000 10881448640 11292205056 1891105536 18.755 98 75 149 2 1954399840 39725328 23568976
23:48:23 12900 8192000000 10874565888 11311259648 1912640576 18.928 100 41 82 0 1962872912 36895408 13336928
23:48:44 10433 8192000000 10869770704 11305484288 1899180752 18.820 99 33 66 0 1946099344 35522896 11395696
23:49:01 20456 8192000000 10882372432 11313836032 1894278608 18.780 99 27 53 2 1940663248 36880864 9503776
23:49:28 5403 8192000000 10905763216 11320303616 1917022288 18.963 100 65 130 2 1979670576 41585536 21062752
23:49:45 8634 8192000000 10891778448 11326169088 1920904512 18.994 100 44 88 0 1975325312 40523824 13896976
23:50:05 11266 8192000000 10867210208 11305390080 1895928448 18.794 99 25 50 2 1943615488 38322576 9364464
23:50:25 6593 8192000000 10910912928 11330162688 1921470096 18.999 100 55 111 0 1982427616 41954240 19003280
23:50:38 8742 8192000000 10875576816 11316834304 1912649968 18.928 100 34 67 0 1966344016 42042016 11652032
23:50:56 4125 8192000000 10892960608 11318095872 1912103488 18.924 100 37 74 2 1964575856 39471040 13001328
23:51:07 4439 8192000000 10923961712 11343298560 1929276144 19.061 100 70 138 1 1994653280 43896048 21481088
23:51:19 18132 8192000000 10888585536 11349766144 1931815728 19.081 100 24 48 0 1982318544 42583840 7918976
23:51:44 43473 8192000000 10892525888 11334787072 1942050992 19.163 100 38 74 2 1971712288 17823376 11837920
23:52:35 16303 8192000000 10903379824 11347398656 1950966512 19.234 100 37 72 1 1984070000 21697392 11406096
23:53:06 20089 8192000000 10903086096 11355369472 1959145344 19.299 100 29 58 3 1992555344 24900096 8509904
23:54:10 19228 8192000000 10896039104 11350556672 1912894544 18.930 98 22 44 0 1953832080 33739824 7197712
23:54:50 24003 8192000000 10876726880 11347550208 1929080640 19.060 100 13 26 1 1970298400 36755520 4462240
23:55:39 24987 8192000000 10896313280 11351113728 1932568224 19.087 100 14 28 1 1971512640 34118944 4825472
23:56:11 32883 8192000000 10883890832 11352109056 1937596976 19.128 100 12 24 2 1980591600 37923504 5071120
23:56:54 72532 8192000000 10914949024 11351195648 1959316480 19.301 100 23 46 2 1978304640 12321328 6666832
23:58:15 18574 8192000000 10933458768 11362648064 1978274000 19.451 100 45 89 1 1998941680 8453072 12214608
23:58:46 23777 8192000000 10905643616 11367116800 1974753840 19.423 100 28 56 1 1992845712 10214496 7877376
23:59:15 127281 8192000000 10914766912 11371757568 1915665840 18.952 97 8 16 0 1934313488 16712368 1935280
00:01:29 70510 8192000000 10946461952 11385061376 1969687856 19.383 100 13 26 0 1998847344 25414720 3744768
00:02:53 126701 8192000000 10922772000 11390124032 1947348976 19.205 98 9 18 1 1965406224 15728672 2328576
00:05:08 61720 8192000000 10927520912 11410391040 1999034176 19.615 100 9 18 1 2019749472 17605104 3110192
00:06:58 58514 8192000000 10942659936 11397349376 1983602736 19.493 99 41 80 2 2002470176 6788784 12078656
00:08:05 45490 8192000000 10925452848 11386335232 1958880048 19.297 98 35 66 4 1978705456 10215440 9609968
00:08:58 48666 8192000000 10928749184 11389095936 1991396256 19.555 100 26 52 2 2007534640 8645840 7492544
00:10:34 9485 8192000000 10932103072 11398590464 1999107200 19.616 100 52 105 0 2029000464 15405552 14487712
00:11:14 17576 8192000000 10916711152 11384532992 1968763920 19.376 99 15 30 0 1980616640 7571328 4281392
00:11:39 26351 8192000000 10930315280 11373359104 1953905968 19.258 98 42 84 3 1974439792 7890624 12643200
00:12:13 38054 8192000000 10921570208 11382472704 1969049232 19.378 99 31 62 0 1987220304 8748656 9422416
00:12:57 64317 8192000000 10908761664 11389825024 1973920160 19.417 99 17 34 1 1992101520 13214704 4966656
00:14:47 12157 8192000000 10900426576 11380813824 1974849664 19.424 100 10 20 2 1992039952 14400144 2790144
00:15:48 68432 8192000000 10917915632 11389251584 1976690784 19.438 99 13 26 1 1996182240 15599008 3892448
00:17:02 81452 8192000000 10917292368 11379871744 1937485056 19.127 97 20 40 0 1964682256 21344832 5852368
00:18:38 69031 8192000000 10906291808 11394093056 1977971248 19.449 100 17 34 1 2000944656 17341120 5632288
00:21:09 109399 8192000000 10871393264 11350974464 1872278400 18.603 95 12 24 0 1893465984 17315344 3872240
00:23:04 54279 8192000000 10877329152 11345911808 1881236080 18.675 96 21 42 0 1901628192 13582112 6810000
00:24:05 55505 8192000000 10905719024 11379679232 1961657520 19.319 100 13 26 0 1979881696 14366944 3857232
00:25:11 70423 8192000000 10891254016 11380998144 1935000320 19.107 98 21 42 2 1952986912 10753792 7232800
00:26:30 32542 8192000000 10916457344 11380146176 1953743456 19.256 99 23 45 1 1971054208 11466912 5843840
00:27:16 40877 8192000000 10933582224 11378200576 1923961920 19.019 97 25 50 1 1941874352 11160016 6752416
00:28:03 41204 8192000000 10915385520 11379195904 1955044512 19.267 99 31 62 1 1977254864 13676016 8534336
00:29:32 95813 8192000000 10894222896 11367944192 1862674000 18.525 94 11 22 0 1878054816 12912784 2468032
00:31:27 71561 8192000000 10833300128 11282870272 1686700928 17.074 86 14 28 0 1698852640 8936624 3215088
00:32:48 41590 8192000000 10872963472 11331203072 1872069056 18.601 97 24 48 1 1894269552 15131136 7069360
00:33:36 57606 8192000000 10914487040 11355402240 1908623328 18.896 98 38 76 0 1936109776 15896080 11590368
00:34:41 37899 8192000000 10884239136 11354664960 1889907536 18.745 97 38 76 1 1919807968 18955568 10944864
00:35:47 168434 8192000000 10867633968 11340218368 1883194096 18.691 97 21 42 1 1906613152 16775968 6643088
00:38:45 75374 8192000000 10886329696 11358851072 1942962720 19.170 100 31 62 0 1969993152 18450192 8580240
00:40:07 5489 8192000000 10890997216 11349811200 1950206320 19.228 100 47 94 0 1975837680 12482368 13148992
00:40:20 23556 8192000000 10904358960 11352059904 1934009312 19.099 99 42 84 1 1958196800 12660592 11526896
00:40:51 31853 8192000000 10886389744 11343998976 1916350000 18.958 98 54 108 3 1947592528 16096640 15145888
00:41:43 59338 8192000000 10840575680 11320938496 1884135392 18.698 97 10 20 0 1901728048 14676048 2916608
00:42:52 36837 8192000000 10858754320 11329773568 1914733264 18.945 99 12 24 1 1927331216 9326736 3271216
00:43:35 42169 8192000000 10881396368 11341406208 1945293056 19.189 100 42 85 3 1964392944 7092064 12007824
00:44:25 32762 8192000000 10882074352 11350302720 1950143136 19.228 100 27 54 1 1967373984 9478752 7752096
00:45:04 31292 8192000000 10863543056 11345403904 1929815248 19.065 99 12 24 1 1942153472 8702480 3635744
00:45:43 27666 8192000000 10850792336 11331936256 1919555936 18.983 99 10 20 1 1930908592 8131888 3220768
00:46:17 10331 8192000000 10839532912 11319480320 1910504480 18.911 99 8 16 0 1919185808 6476016 2205312
00:46:34 16469 8192000000 10855689664 11328634880 1931986848 19.083 100 9 18 2 1940322976 5948976 2387152
00:46:56 66656 8192000000 10864125024 11342553088 1926997200 19.043 99 17 34 3 1939227712 7276032 4954480
00:48:09 89297 8192000000 10866806192 11354488832 1933306752 19.093 99 13 26 0 1949815840 13116720 3392368
00:49:45 45707 8192000000 10869033088 11360178176 1945163584 19.188 100 6 12 1 1963061792 15676288 2221920
00:50:37 36240 8192000000 10895563680 11360800768 1928875872 19.058 99 5 10 1 1949352736 18967680 1509184
00:51:23 73188 8192000000 10850474112 11331567616 1831704288 18.273 94 11 22 0 1844134256 8848032 3581936
00:52:55 26791 8192000000 10870190640 11336470528 1937585680 19.127 100 30 60 4 1956591184 10191808 8813696
00:53:35 57761 8192000000 10884615904 11357200384 1950174672 19.228 100 24 48 0 1969744320 12706496 6863152
00:55:18 51062 8192000000 10888868000 11358658560 1927515232 19.047 98 26 52 2 1944543552 10070576 6957744
00:56:17 53704 8192000000 10878921040 11342204928 1918034464 18.971 98 17 34 0 1932247584 8942224 5270896
00:57:17 98690 8192000000 10926705168 11371835392 1894055760 18.778 96 18 36 2 1907941776 8838160 5047856
00:59:03 51237 8192000000 10901621008 11378827264 1957159200 19.283 99 29 58 0 1975277296 10491024 7627072
01:00:01 68385 8192000000 10905480880 11388555264 1941623920 19.160 98 13 26 0 1955259728 9926064 3709744
01:01:25 30503 8192000000 10890779024 11363999744 1919949888 18.986 97 9 18 0 1930539088 7807056 2782144
01:02:01 92935 8192000000 10905970528 11378823168 1927926496 19.050 98 10 20 0 1940957216 10328192 2702528
01:03:43 64349 8192000000 10914498688 11393748992 1959057856 19.299 99 12 24 0 1973654112 10910176 3686080
01:05:00 40936 8192000000 10913022320 11396714496 1950995600 19.234 98 28 56 2 1970550704 11346032 8209072
01:05:47 94749 8192000000 10911726656 11391033344 1976851168 19.440 100 10 20 1 1995184992 15512576 2821248
01:07:33 61065 8192000000 10904423312 11388911616 1945939104 19.194 98 18 34 1 1964752080 13871712 4941264
01:09:06 5364 8192000000 10894303264 11379949568 1965670304 19.351 100 10 20 1 1985850624 17652752 2527568
01:09:17 11260 8192000000 10900792608 11382497280 1948437776 19.214 99 5 10 0 1967006256 17150064 1418416
01:10:16 53304 8192000000 10864008176 11345870848 1923813280 19.017 99 8 16 1 1938774064 12516864 2443920
01:11:16 32337 8192000000 10854528944 11342401536 1897766528 18.808 98 8 16 0 1911728800 11539824 2422448
01:11:54 34281 8192000000 10883276272 11357241344 1945589056 19.191 100 21 42 1 1962288912 10504960 6194896
01:12:35 57727 8192000000 10851702480 11331911680 1876469392 18.637 96 13 25 1 1889505008 9038272 3997344
01:14:20 77526 8192000000 10862960400 11351412736 1905687648 18.872 98 13 26 1 1920920096 11279920 3952528
01:15:49 58700 8192000000 10879287424 11356991488 1914252224 18.941 98 18 36 1 1930672688 10651792 5768672
01:17:02 77759 8192000000 10885573312 11380838400 1957241792 19.284 100 15 30 0 1982690320 20991888 4456640
01:18:29 99328 8192000000 10819905600 11296223232 1821147152 18.187 93 10 20 0 1832542000 8915008 2479840
01:20:23 61492 8192000000 10851472912 11322171392 1867404368 18.563 97 18 35 1 1883188800 10997696 4786736
01:21:40 34815 8192000000 10864398336 11308650496 1851189824 18.432 96 35 70 1 1869119808 8911152 9018832
01:22:23 18886 8192000000 10855712208 11309793280 1844034048 18.374 96 40 80 1 1868964384 13857568 11072768
01:22:48 43326 8192000000 10861588992 11326144512 1866470368 18.556 97 44 87 4 1891002656 12788928 11743360
01:23:42 61960 8192000000 10858415696 11334795264 1867496576 18.564 97 26 49 2 1886390928 11934560 6959792
01:24:50 55685 8192000000 10876142176 11338899456 1895367200 18.789 98 37 74 1 1917095936 11881472 9847264
01:25:54 36598 8192000000 10870977936 11323346944 1901263856 18.836 98 35 70 1 1922618784 11860464 9494464
01:26:39 24555 8192000000 10898595216 11348434944 1921422320 18.998 99 48 95 1 1949255936 14776816 13056800
01:27:12 17192 8192000000 9161284016 9397284864 315966192 3.713 17 4 7 0 322179200 5235840 977168

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 01-02-2021 01:28:24 to 01-02-2021 01:28:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 138 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-02-2021 01:28:57 to 01-02-2021 01:28:59.

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          251333
MON$OLDEST_ACTIVE               251334
MON$OLDEST_SNAPSHOT             251334
MON$NEXT_TRANSACTION            251334
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                       2039392
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.33409 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33409 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33409 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33409 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'

01.02.21 01:29:00. 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
2021-02-01 01:29:03 No severe PSQL-related problems occured
01.02.21 01:29:04. End of report.