Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.03.2021 16:29
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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17615504 kB
MemAvailable 31520604 kB
Buffers 0 kB
Cached 14097796 kB
SwapCached 0 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-03-29 16:27:26
DTS_END                         2021-03-29 16:27:26.2840
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51480
TRN_ID                          245427
ATT_ID                          632
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: 9135.44 18866 1096253
customer order: creation 176.90 390 21228
customer order: refuse 14.78 334 1774
order to supplier: creation 46.77 1394 5612
order to supplier: removal 3.43 96971 412
invoice (draft): creation 47.13 3260 5656
invoice (draft): removal 50.68 756 6082
invoice accept: apply 42.83 18381 5140
invoice accept: cancel 44.86 782 5383
customer reserve: creation 3996.93 180 479631
customer reserve: removal 4411.22 59 529346
realization accept: apply 85.93 160 10312
realization accept: cancel 82.04 124 9845
payment from customer: creation 61.19 117 7343
payment from customer: removal 5.48 65 657
payment to supplier: creation 49.08 129 5889
payment to supplier: removal 3.51 70 421
service: total inventory turnovers 5.02 1052 602
service: total monetary turnovers 6.86 25 823
service: aggregate perf. data 0.78 18953 93
service: refresh index statistics 0.03 234108 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-03-2021 16:30:15 to 29-03-2021 16:30:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2383
TEST_TIME 2 3155
TEST_TIME 3 3696
TEST_TIME 4 3864
TEST_TIME 5 3437
TEST_TIME 6 3574
TEST_TIME 7 4084
TEST_TIME 8 4038
TEST_TIME 9 4481
TEST_TIME 10 4957
TEST_TIME 11 5186
TEST_TIME 12 5232
TEST_TIME 13 5733
TEST_TIME 14 6819
TEST_TIME 15 6933
TEST_TIME 16 7120
TEST_TIME 17 7202
TEST_TIME 18 8362
TEST_TIME 19 8609
TEST_TIME 20 8734
TEST_TIME 21 9130
TEST_TIME 22 9459
TEST_TIME 23 9527
TEST_TIME 24 9261
TEST_TIME 25 10070
TEST_TIME 26 10792
TEST_TIME 27 10553
TEST_TIME 28 10679
TEST_TIME 29 10543
TEST_TIME 30 10388
TEST_TIME 31 10253
TEST_TIME 32 10284
TEST_TIME 33 10121
TEST_TIME 34 10043
TEST_TIME 35 9856
TEST_TIME 36 9714
TEST_TIME 37 9679
TEST_TIME 38 9539
TEST_TIME 39 9536
TEST_TIME 40 9711
TEST_TIME 41 9569
TEST_TIME 42 9504
TEST_TIME 43 9516
TEST_TIME 44 9431
TEST_TIME 45 9369
TEST_TIME 46 9266
TEST_TIME 47 9277
TEST_TIME 48 9352
TEST_TIME 49 9380
TEST_TIME 50 9368
TEST_TIME 51 9398
TEST_TIME 52 9472
TEST_TIME 53 9516
TEST_TIME 54 9464
TEST_TIME 55 9453
TEST_TIME 56 9600
TEST_TIME 57 9548
TEST_TIME 58 9600
TEST_TIME 59 9478
TEST_TIME 60 9405
TEST_TIME 61 9339
TEST_TIME 62 9286
TEST_TIME 63 9282
TEST_TIME 64 9203
TEST_TIME 65 9257
TEST_TIME 66 9236
TEST_TIME 67 9264
TEST_TIME 68 9254
TEST_TIME 69 9211
TEST_TIME 70 9229
TEST_TIME 71 9267
TEST_TIME 72 9229
TEST_TIME 73 9273
TEST_TIME 74 9392
TEST_TIME 75 9405
TEST_TIME 76 9422
TEST_TIME 77 9393
TEST_TIME 78 9331
TEST_TIME 79 9288
TEST_TIME 80 9217
TEST_TIME 81 9259
TEST_TIME 82 9197
TEST_TIME 83 9178
TEST_TIME 84 9164
TEST_TIME 85 9151
TEST_TIME 86 9163
TEST_TIME 87 9247
TEST_TIME 88 9223
TEST_TIME 89 9237
TEST_TIME 90 9232
TEST_TIME 91 9239
TEST_TIME 92 9234
TEST_TIME 93 9265
TEST_TIME 94 9307
TEST_TIME 95 9336
TEST_TIME 96 9342
TEST_TIME 97 9308
TEST_TIME 98 9252
TEST_TIME 99 9209
TEST_TIME 100 9243
TEST_TIME 101 9212
TEST_TIME 102 9156
TEST_TIME 103 9153
TEST_TIME 104 9117
TEST_TIME 105 9092
TEST_TIME 106 9189
TEST_TIME 107 9164
TEST_TIME 108 9234
TEST_TIME 109 9239
TEST_TIME 110 9196
TEST_TIME 111 9240
TEST_TIME 112 9276
TEST_TIME 113 9257
TEST_TIME 114 9261
TEST_TIME 115 9253
TEST_TIME 116 9298
TEST_TIME 117 9294
TEST_TIME 118 9222
TEST_TIME 119 9175
TEST_TIME 120 9137

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 29-03-2021 16:30:18 to 29-03-2021 16:30:22.

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 1539157 1539157 0 0.00 0 33215 6 0 0
doc_list_biud 1539156 1539156 0 0.00 0 35624 26 0 0
sp_add_invoice_to_stock 5258 5140 118 2.24 13 164897 18382 0 118
sp_cancel_adding_invoice 5383 5383 0 0.00 3 57284 783 0 0
sp_cancel_client_order 1774 1774 0 0.00 4 9353 334 0 0
sp_cancel_customer_reserve 529346 529346 0 0.00 1 20637 59 0 0
sp_cancel_pay_from_customer 657 657 0 0.00 3 3305 66 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 3 3705 70 0 0
sp_cancel_supplier_invoice 6090 6082 8 0.13 1 15918 757 0 8
sp_cancel_supplier_order 412 412 0 0.00 7 1130855 96972 0 0
sp_cancel_write_off 9845 9845 0 0.00 1 14254 125 0 0
sp_client_order 21228 21228 0 0.00 3 25867 390 0 0
sp_customer_reserve 479631 479631 0 0.00 0 97489 181 0 0
sp_fill_shopping_cart 32484 32484 0 0.00 1 13229 39 0 0
sp_fill_shopping_cart_clo_res 479629 479629 0 0.00 0 16047 16 0 0
sp_get_clo_for_invoice 5136 5136 0 0.00 0 20619 327 0 0
sp_kill_cost_storno 16306 16306 0 0.00 0 10093 57 0 0
sp_kill_qstorno_ret_qs2qd 1075031 1075031 0 0.00 0 20613 32 0 0
sp_kill_qty_storno 568290 568290 0 0.00 0 35620 69 0 0
sp_lock_selected_doc 21225 21225 0 0.00 0 8840 5 0 0
sp_make_cost_storno 28680 28680 0 0.00 0 33209 51 0 0
sp_multiply_rows_for_pdistr 28680 28680 0 0.00 0 11875 31 0 0
sp_multiply_rows_for_qdistr 21228 21228 0 0.00 0 16959 173 0 0
sp_pay_from_customer 7343 7343 0 0.00 4 30916 118 0 0
sp_pay_to_supplier 5889 5889 0 0.00 5 33291 129 0 0
sp_payment_common 13232 13232 0 0.00 1 30896 23 0 0
sp_qd_handle_on_cancel_clo 1774 1774 0 0.00 0 8447 305 0 0
sp_qd_handle_on_invoice_upd_sts 10519 10519 0 0.00 0 35615 336 0 0
sp_qd_handle_on_reserve_upd_sts 10312 10312 0 0.00 0 20416 51 0 0
sp_reserve_write_off 10312 10312 0 0.00 6 20452 160 0 0
sp_supplier_invoice 5656 5656 0 0.00 7 87463 3260 0 0
sp_supplier_order 5612 5612 0 0.00 5 35617 1395 0 0
srv_aggregate_perf_data 94 93 1 1.06 2588 157441 18953 0 1
srv_fill_mon_cache_memory 156 156 0 0.00 1054 141723 34395 0 0
srv_find_qd_qs_mism 1046572 1046572 0 0.00 0 25563 6 0 0
srv_make_invnt_saldo 602 602 0 0.00 43 119038 1052 0 0
srv_make_money_saldo 823 823 0 0.00 1 4806 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 123063 307277 234109 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 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 5140 5140 0 0.00 0 48968 165 0 0
t$perf-norm:sp_cancel_adding_invoice 366 366 0 0.00 1 11182 109 0 0
t$perf-norm:sp_cancel_client_order 1774 1774 0 0.00 0 15256 24 0 0
t$perf-norm:sp_cancel_customer_reserve 716 716 0 0.00 0 1322 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 657 657 0 0.00 0 1794 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 2088 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 2660 31 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 21920 1584 0 0
t$perf-norm:sp_cancel_write_off 1019 1019 0 0.00 0 1049 5 0 0
t$perf-norm:sp_client_order 21228 21228 0 0.00 0 45651 19 0 0
t$perf-norm:sp_customer_reserve 1024 1024 0 0.00 0 2682 7 0 0
t$perf-norm:sp_pay_from_customer 7343 7343 0 0.00 0 21903 14 0 0
t$perf-norm:sp_pay_to_supplier 5889 5889 0 0.00 0 10069 16 0 0
t$perf-norm:sp_reserve_write_off 10312 10312 0 0.00 0 12876 9 0 0
t$perf-norm:sp_supplier_invoice 5656 5656 0 0.00 0 10796 19 0 0
t$perf-norm:sp_supplier_order 5612 5612 0 0.00 0 8791 15 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 803 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 3587 26 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 888 18 0 0
t$perf-norm:srv_make_money_saldo 823 823 0 0.00 0 10832 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10504 10268 236 2.24 0 5885 18 0 236
v_all_customers 38638 38638 0 0.00 0 16 1 0 0
v_all_suppliers 31054 31054 0 0.00 0 28 1 0 0
v_all_wares 42454 42454 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 732 732 0 0.00 0 1723 10 0 0
v_cancel_client_order 3548 3548 0 0.00 0 3349 6 0 0
v_cancel_customer_prepayment 1314 1314 0 0.00 0 3290 6 0 0
v_cancel_customer_reserve 1432 1432 0 0.00 0 1889 6 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 3622 7 0 0
v_cancel_supplier_invoice 844 828 16 1.89 0 244 13 0 16
v_cancel_supplier_order 824 824 0 0.00 0 2730 11 0 0
v_cancel_write_off 2038 2038 0 0.00 0 3631 13 0 0
v_max_id_clo_ord 5609 5609 0 0.00 0 374 1 0 0
v_max_id_clo_res 1024 1024 0 0.00 0 1877 14 0 0
v_max_id_ord_sup 5646 5646 0 0.00 0 4369 4 0 0
v_max_non_paid_invoice 1617 1617 0 0.00 0 3716 6 0 0
v_max_non_paid_realizn 3910 3910 0 0.00 0 1970 3 0 0
v_min_id_clo_ord 5609 5609 0 0.00 0 5270 11 0 0
v_min_id_clo_res 1024 1024 0 0.00 0 6024 13 0 0
v_min_id_ord_sup 5646 5646 0 0.00 0 4974 6 0 0
v_min_non_paid_invoice 5889 5889 0 0.00 0 4339 10 0 0
v_min_non_paid_realizn 7343 7343 0 0.00 0 30893 16 0 0
v_our_firm 10682 10682 0 0.00 0 31 1 0 0
v_reserve_write_off 20624 20624 0 0.00 0 3382 5 0 0
x_lock_depdocs_on_canc_invoice 11051 11051 0 0.00 0 25358 121 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 13949 376 0 0
x_make_qstorno_1000_1200 5612 5612 0 0.00 1 35611 1315 0 0
x_make_qstorno_1200_2000 5656 5656 0 0.00 2 85854 3122 0 0
x_make_qstorno_2100_3300 479631 479631 0 0.00 0 97474 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-03-2021 16:30:23 to 29-03-2021 16:30:27.

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
13:57:29 6 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:35 6955 8192000000 10111607120 10398044160 908233792 9.980 75 59 117 2 930865088 2433040 20198256
13:57:49 27005 8192000000 10295288672 10608418816 1327898032 13.948 100 79 158 0 1358410720 4108496 26404192
13:58:25 20452 8192000000 10355187296 10673778688 1417599552 14.751 100 83 166 0 1449650064 5243552 26806960
13:58:56 5793 8192000000 10368697472 10688626688 1429368160 14.856 100 88 176 0 1465124560 6307648 29448752
13:59:09 18793 8192000000 10389001472 10710298624 1442681456 14.973 100 88 176 0 1477682064 6728672 28271936
13:59:40 24455 8192000000 10424809792 10752491520 1471271248 15.225 100 87 174 0 1506954384 7446416 28236720
14:00:17 15750 8192000000 10433120928 10762764288 1487342128 15.366 100 87 174 0 1523907136 8427520 28137488
14:00:42 15829 8192000000 10453782864 10786549760 1500288544 15.479 100 88 176 0 1536705168 8565520 27851104
14:01:08 17616 8192000000 10468477696 10802806784 1521319760 15.662 100 90 179 0 1559073568 9237760 28516048
14:01:38 12614 8192000000 10489157840 10835099648 1543308144 15.852 100 83 166 2 1578769040 9554400 25906496
14:02:01 9607 8192000000 10508972048 10855333888 1569426288 16.077 100 83 166 0 1605297488 9750192 26121008
14:02:18 14362 8192000000 10533047216 10886107136 1581497184 16.181 100 75 148 2 1613622016 9223488 22901344
14:02:40 13242 8192000000 10563719280 10916917248 1614530544 16.463 100 75 148 0 1646412192 9694224 22187424
14:03:02 10112 8192000000 10582634272 10945077248 1639340336 16.674 100 76 152 1 1672682832 10585808 22756688
14:03:20 8398 8192000000 10600832944 10966609920 1658379632 16.835 100 75 150 1 1691972112 11052880 22539600
14:03:36 7073 8192000000 10633920176 11002576896 1689532352 17.097 100 76 150 3 1722638224 11005648 22100224
14:03:54 6861 8192000000 10653284240 11024326656 1704376848 17.222 100 75 150 1 1737941584 11295184 22269552
14:04:08 8440 8192000000 10660265456 11037827072 1723977808 17.385 100 84 164 0 1759931216 11661776 24291632
14:04:23 7137 8192000000 10670592928 11045986304 1735090352 17.478 100 81 162 0 1769702944 11623024 22989568
14:04:38 5261 8192000000 10680823856 11053264896 1738597696 17.507 100 84 168 2 1775997696 12692336 24707664
14:04:54 7129 8192000000 10684758992 11065036800 1750929936 17.609 100 81 162 2 1786649792 12671248 23048608
14:05:08 4175 8192000000 10711751808 11088113664 1769577536 17.764 100 83 166 1 1806458288 13376880 23503872
14:05:19 4788 8192000000 10709775984 11090259968 1774037488 17.800 100 93 186 5 1814251760 13935792 26278480
14:05:31 4810 8192000000 10716939456 11096907776 1774807280 17.807 100 78 154 3 1809570496 13510880 21252336
14:05:42 4129 8192000000 10721078272 11105095680 1786089776 17.900 100 87 171 0 1824384512 13939488 24355248
14:05:53 4168 8192000000 10726116080 11110277120 1793149104 17.958 100 82 166 0 1829392976 13567360 22676512
14:06:04 3652 8192000000 10742803376 11126865920 1803823712 18.045 100 83 166 0 1840470912 13282144 23365056
14:06:14 3771 8192000000 10743781152 11126984704 1803489552 18.043 100 87 172 0 1841161728 13814640 23857536
14:06:24 2039 8192000000 10746867376 11131883520 1811742928 18.110 100 88 176 0 1849580432 12783072 25054432
14:06:32 5153 8192000000 10752461584 11134509056 1818057392 18.162 100 81 161 1 1853290720 12980112 22253216
14:06:45 5320 8192000000 10761277808 11148771328 1820414640 18.181 100 83 166 1 1857589280 14271936 22902704
14:06:59 3004 8192000000 10784089568 11170283520 1837045664 18.317 100 86 172 0 1876355152 15172560 24136928
14:07:10 2493 8192000000 10789147552 11176579072 1848131600 18.407 100 95 190 0 1889318688 15107760 26079328
14:07:18 2703 8192000000 10797582544 11187306496 1851305856 18.433 100 86 170 1 1890224960 15310784 23608320
14:07:28 2373 8192000000 10802584336 11188154368 1855102400 18.464 100 91 181 0 1894754768 13931344 25721024
14:07:36 1319 8192000000 10807719296 11193507840 1858120704 18.488 100 95 191 0 1899478096 14895072 26462320
14:07:44 1936 8192000000 10808399152 11195351040 1865259056 18.546 100 93 186 0 1905903056 13986864 26657136
14:07:52 2240 8192000000 10809709392 11195752448 1861296192 18.514 100 89 179 2 1900462464 13642704 25523568
14:08:00 1531 8192000000 10809960000 11195052032 1863430352 18.531 100 95 190 0 1902822064 12883424 26508288
14:08:08 2011 8192000000 10815376112 11200450560 1864717168 18.542 100 91 179 2 1903743408 13993184 25033056
14:08:17 1857 8192000000 10814348544 11199361024 1864817472 18.542 100 88 176 3 1903643952 13785136 25041344
14:08:25 1524 8192000000 10810337616 11199139840 1867579696 18.565 100 89 177 4 1905496576 13597216 24319664
14:08:33 2144 8192000000 10812594048 11199963136 1866478176 18.556 100 89 179 1 1906150896 14126928 25545792
14:08:41 1940 8192000000 10808704112 11199021056 1867472448 18.564 100 92 184 2 1905544320 12567248 25504624
14:08:50 2534 8192000000 10813907488 11202064384 1875103136 18.626 100 93 186 1 1913802384 12412896 26286352
14:08:58 1587 8192000000 10823136096 11213307904 1875111792 18.626 100 94 186 5 1915593392 12707248 27774352
14:09:07 2150 8192000000 10824876784 11211747328 1879246576 18.659 100 95 191 0 1919364016 12926144 27191296
14:09:15 2630 8192000000 10822987248 11213131776 1877122240 18.642 100 92 178 2 1916052128 13054896 25874992
14:09:25 2109 8192000000 10811200080 11212595200 1875675344 18.630 100 77 152 2 1910430096 12917568 21837184
14:09:34 5079 8192000000 10794081968 11208474624 1874295312 18.619 100 49 98 0 1898905440 11256096 13354032
14:09:46 44079 8192000000 10779922752 11213565952 1884223696 18.699 100 40 81 2 1902619184 6854320 11541168
14:10:39 12896 8192000000 10789530048 11218333696 1884003184 18.697 100 49 98 1 1905025296 6546240 14475872
14:11:05 7929 8192000000 10797082912 11215507456 1880062736 18.666 100 26 52 1 1893655568 6166464 7426368
14:11:20 6185 8192000000 10795788896 11226144768 1883085152 18.690 100 32 64 0 1901458048 9538096 8834800
14:11:32 2760 8192000000 10806938336 11226181632 1888010624 18.730 100 40 80 4 1905972752 6879216 11082912
14:11:45 6867 8192000000 10795538496 11227197440 1888030112 18.730 100 33 67 1 1909367568 11398992 9938464
14:11:58 9209 8192000000 10796409936 11223478272 1886195936 18.715 100 16 32 0 1897609792 5462688 5951168
14:12:15 7023 8192000000 10809688800 11233538048 1893722176 18.776 100 38 76 3 1911490432 6619872 11148384
14:12:31 7843 8192000000 10804218448 11234889728 1889337472 18.740 100 25 50 1 1903225344 6754832 7133040
14:12:45 4692 8192000000 10796227424 11232010240 1893563280 18.774 100 27 54 0 1908283296 6401952 8318064
14:12:58 7754 8192000000 10793368256 11230064640 1891555920 18.758 100 22 44 2 1903944304 6199696 6188688
14:13:13 9006 8192000000 10797702832 11232718848 1890188704 18.747 100 14 28 1 1899748688 5182672 4377312
14:13:29 5755 8192000000 10808213744 11236212736 1895463536 18.790 100 28 56 2 1909961392 7220128 7277728
14:13:41 7162 8192000000 10802482032 11239342080 1895835920 18.793 100 22 44 2 1908801456 6871840 6093696
14:13:56 11705 8192000000 10801302032 11241533440 1895354016 18.789 100 14 29 0 1905064608 6030768 3679824
14:14:14 11089 8192000000 10816073520 11244068864 1900765360 18.832 100 28 56 1 1914920800 6055376 8100064
14:14:31 35504 8192000000 10802481504 11248398336 1902385056 18.845 100 21 42 2 1914293856 4960144 6948656
14:15:13 47381 8192000000 10803168576 11240091648 1864735936 18.542 98 21 42 1 1875633632 5344608 5553088
14:16:08 8902 8192000000 10799854784 11239440384 1897104496 18.803 100 22 44 4 1909656960 6515632 6036832
14:16:24 7300 8192000000 10799660080 11232894976 1873235712 18.610 99 17 34 1 1884017536 5388816 5393008
14:16:37 4278 8192000000 10803403056 11232772096 1888103824 18.730 100 32 63 1 1904210576 6382032 9724720
14:16:48 6213 8192000000 10812245216 11237638144 1874507840 18.621 99 29 58 1 1888700128 6062832 8129456
14:17:03 9078 8192000000 10772534656 11202506752 1797679280 17.995 95 25 50 1 1809233696 4635568 6918848
14:17:20 5480 8192000000 10780265600 11202093056 1832201232 18.277 98 36 72 0 1853836784 11144288 10491264
14:17:33 6651 8192000000 10760290128 11191750656 1825932832 18.226 98 26 52 2 1840125792 6719008 7473952
14:17:48 9354 8192000000 10771285696 11193004032 1847719216 18.404 99 27 54 1 1861952560 5660688 8572656
14:18:06 7234 8192000000 10754028720 11179069440 1799956848 18.014 97 22 43 1 1812175376 5781360 6437168
14:18:23 9171 8192000000 10754701728 11176857600 1813566784 18.125 98 19 38 0 1824674176 5556448 5550944
14:18:38 10318 8192000000 10746673472 11163320320 1759918016 17.684 95 27 54 1 1773372224 5579280 7874928
14:18:55 9269 8192000000 10699848448 11115368448 1682083248 17.035 92 20 40 3 1697264032 9249648 5931136
14:19:11 5757 8192000000 10683892144 11098660864 1720777936 17.359 96 19 38 1 1732212992 6421264 5013792
14:19:23 8912 8192000000 10677810240 11095814144 1724060416 17.386 97 15 30 1 1733376816 5080752 4235648
14:19:38 14823 8192000000 10702732112 11107012608 1742958912 17.543 97 32 63 5 1757768528 5213232 9596384
14:20:35 27746 8192000000 10698858768 11128176640 1720117520 17.353 95 14 28 0 1728996912 4982272 3897120
14:21:09 9507 8192000000 10705132464 11120369664 1745658560 17.566 97 26 52 0 1759764272 6548560 7557152
14:21:25 7651 8192000000 10716430448 11136040960 1780210688 17.851 99 17 34 1 1794240944 9801984 4228272
14:21:41 7400 8192000000 10718221376 11123937280 1733301504 17.463 96 40 81 6 1751385952 6297376 11787072
14:21:55 8483 8192000000 10707965200 11128156160 1780721968 17.855 99 30 60 0 1803847968 14643952 8482048
14:22:10 8332 8192000000 10722730240 11151351808 1814704688 18.134 100 24 48 1 1826456800 4947408 6804704
14:22:29 9532 8192000000 10722757216 11142623232 1795944848 17.981 99 22 44 1 1807949152 5569552 6434752
14:22:47 7162 8192000000 10728264464 11148787712 1799607472 18.011 99 22 44 0 1812059360 5660848 6791040
14:23:02 6464 8192000000 10741796976 11164405760 1823654176 18.208 100 24 46 1 1836414416 5246320 7513920
14:23:17 8237 8192000000 10753209872 11171074048 1813119024 18.121 99 26 52 2 1830735056 9506080 8109952
14:23:32 14115 8192000000 10758617520 11182022656 1836717856 18.314 100 27 54 1 1850462432 4954096 8790480
14:23:54 12008 8192000000 10754119072 11182059520 1843942208 18.373 100 15 30 0 1853474944 5070912 4461824
14:24:13 13446 8192000000 10761055648 11194527744 1843718352 18.371 100 10 20 0 1852225280 6043152 2463776
14:24:34 44439 8192000000 10775378544 11199148032 1856141024 18.472 100 29 58 2 1869669616 4925008 8603584
14:25:41 13831 8192000000 10768782560 11199508480 1857255136 18.481 100 21 41 2 1869766496 6657072 5854288
14:26:03 9450 8192000000 10786362528 11207512064 1866022272 18.552 100 41 82 0 1884707472 7050336 11634864
14:26:19 9569 8192000000 10779914736 11210870784 1865186448 18.545 100 30 60 0 1880627440 7547008 7893984
14:26:37 5550 8192000000 10793469872 11217141760 1870368512 18.587 100 42 84 3 1891034896 8656864 12009520
14:26:50 3753 8192000000 10785838240 11214516224 1869937584 18.584 100 38 76 1 1887604256 6409568 11257104
14:27:00 8824 8192000000 10806634032 11226349568 1876454064 18.636 100 22 44 1 1887923168 4610032 6859072
14:27:20 24911 8192000000 10812386832 11239157760 1893684944 18.775 100 22 44 2 1904700128 4652576 6362608
14:28:01 24503 8192000000 10828180208 11253096448 1904011072 18.859 100 35 69 0 1919384496 4994416 10379008
14:28:37 22387 8192000000 10844953760 11273302016 1915702528 18.952 100 45 89 1 1944904480 16602832 12599120
14:29:15 8634 8192000000 10872571728 11288670208 1924941920 19.026 100 49 98 2 1952136864 12840768 14354176
14:29:31 24636 8192000000 10871597488 11297042432 1930794704 19.073 100 45 90 3 1964721728 20369136 13557888
14:30:04 15982 8192000000 10875511920 11303084032 1940339648 19.149 100 43 86 0 1969650864 16633440 12677776
14:30:29 17715 8192000000 10882238400 11310460928 1948209872 19.212 100 47 93 3 1979641376 17211776 14219728
14:31:03 17943 8192000000 10902581136 11329511424 1952386512 19.245 100 45 90 1 1988559632 22080032 14093088
14:31:32 42978 8192000000 10906845856 11343826944 1964657840 19.343 100 45 90 0 2000706400 22286496 13762064
14:32:49 21123 8192000000 10907009168 11347214336 1969887600 19.385 100 31 62 0 2005047408 25936544 9223264
14:33:25 18531 8192000000 10925346768 11363233792 1978511184 19.453 100 46 92 1 2019115504 27217600 13386720
14:33:51 17005 8192000000 10936200784 11366428672 1980702400 19.470 100 47 94 1 2023265760 28670176 13893184
14:34:20 18933 8192000000 10927770592 11367206912 1984529888 19.501 100 49 98 0 2026041024 27610736 13900400
14:34:56 15592 8192000000 10935590016 11370147840 1985282048 19.506 100 50 100 0 2028199504 27363008 15554448
14:35:18 16012 8192000000 10930338496 11367002112 1982294272 19.483 100 55 110 2 2028951600 29673600 16983728
14:35:42 18460 8192000000 10933531296 11375017984 1985283024 19.507 100 40 80 0 2028073296 30293360 12496912
14:36:14 17083 8192000000 10953054960 11379597312 1988416272 19.531 100 56 111 1 2038366912 31955440 17995200
14:36:45 2778 8192000000 10978391728 11392430080 2000606016 19.628 100 79 157 2 2059089504 34464608 24018880
14:36:55 1203 8192000000 10983004976 11397890048 2003676608 19.652 100 85 175 1 2065242080 35058976 26506496
14:37:03 4241 8192000000 10958289664 11381452800 1982836944 19.487 99 75 149 0 2041174880 35738640 22599296
14:37:14 4847 8192000000 10960062976 11384406016 1991571344 19.556 100 70 140 0 2048950944 36868912 20510688
14:37:29 7326 8192000000 10965131728 11391959040 1997642816 19.604 100 71 137 1 2052665616 35265312 19757488
14:37:49 14247 8192000000 10960807808 11393552384 1983848864 19.495 99 55 110 0 2035782944 34716320 17217760
14:38:13 9711 8192000000 10957530432 11383914496 1989057424 19.536 100 54 108 2 2041709920 35726864 16925632
14:38:32 13918 8192000000 10938909472 11367714816 1944679552 19.184 98 62 125 1 1998884496 34868320 19336624
14:38:52 7001 8192000000 10953962240 11380461568 1982127600 19.482 100 61 120 1 2037137520 36544640 18465280
14:39:08 3015 8192000000 10968139408 11388022784 1983538160 19.493 100 87 173 0 2055468384 45252160 26678064
14:39:23 3353 8192000000 10969422464 11391578112 1986545248 19.516 100 74 144 3 2051047232 42116272 22385712
14:39:34 1917 8192000000 10962926448 11374641152 1948965808 19.218 98 81 161 0 2016342960 42771200 24605952
14:39:44 5916 8192000000 10936052608 11363794944 1957565184 19.287 99 80 157 2 2025599024 43960688 24073152
14:39:59 1628 8192000000 10940963504 11349835776 1946570032 19.199 99 92 185 0 2021567856 46021856 28975968
14:40:07 3017 8192000000 10937969472 11351207936 1939116960 19.140 99 74 147 1 2010041024 48550720 22373344
14:40:20 1711 8192000000 10950558368 11366051840 1962068224 19.322 100 89 178 1 2035697472 46810768 26818480
14:40:29 4405 8192000000 10964409152 11374784512 1967841344 19.368 100 87 175 0 2043865328 49063088 26960896
14:40:45 4217 8192000000 10951493840 11367153664 1961037600 19.314 100 89 179 2 2039879312 50724336 28117376
14:41:02 1832 8192000000 10959183840 11372863488 1965033504 19.346 100 90 179 0 2044158608 50305744 28819360
14:41:10 1800 8192000000 10912166880 11321872384 1924243744 19.021 98 88 175 2 1994679824 43920832 26515248
14:41:20 5904 8192000000 10930988416 11352420352 1919518672 18.983 98 69 139 0 1989148576 47692176 21937728
14:41:34 8584 8192000000 10936124656 11356360704 1955692784 19.272 100 71 142 1 2018465472 41259552 21513136
14:41:51 2502 8192000000 10935461984 11357847552 1956578768 19.279 100 66 132 2 2019492704 42373712 20540224
14:42:01 3763 8192000000 10930553184 11348795392 1946276080 19.197 100 70 140 0 2010972864 42761104 21935680
14:42:12 11540 8192000000 10943410896 11364184064 1961982672 19.322 100 80 160 0 2028867024 42381120 24503232
14:42:31 2275 8192000000 10951409664 11367772160 1962799936 19.328 100 76 151 0 2031844448 46374272 22670240
14:42:45 3031 8192000000 10950809952 11358457856 1941924128 19.162 99 86 171 0 2014022144 46603968 25494048
14:42:55 1054 8192000000 10959707888 11366330368 1961442544 19.318 100 93 184 3 2037730128 47667488 28620096
14:43:03 1775 8192000000 10963290480 11377680384 1971008096 19.393 100 84 165 2 2044480896 48062800 25410000
14:43:13 3720 8192000000 10971364992 11386204160 1979600912 19.462 100 78 156 3 2051852272 48771472 23479888
14:43:24 1487 8192000000 10967032576 11382611968 1971755632 19.399 100 83 165 1 2046202560 49181920 25265008
14:43:33 1476 8192000000 10973644016 11381338112 1974625408 19.422 100 90 179 1 2052407792 49891264 27891120
14:43:42 2242 8192000000 10977200480 11385884672 1975191312 19.427 100 90 179 1 2054928208 52485776 27251120
14:43:52 2900 8192000000 10976247616 11386511360 1975099152 19.426 100 90 177 1 2055895264 53610016 27186096
14:44:01 4727 8192000000 10967265056 11392282624 1975973552 19.433 100 66 132 0 2051158240 54310128 20874560
14:44:17 4144 8192000000 10937671552 11361390592 1941864320 19.162 99 57 114 2 2015951056 55092400 18994336
14:44:29 4030 8192000000 10965095472 11381293056 1958609232 19.295 100 81 158 2 2041108480 56350528 26148720
14:44:41 7066 8192000000 10959857168 11372388352 1954080928 19.259 100 74 148 3 2036034320 58716272 23237120
14:44:59 2471 8192000000 10965446928 11388739584 1968045024 19.370 100 82 164 3 2054910352 60727136 26138192
14:45:10 5327 8192000000 10959752080 11388616704 1963626048 19.335 100 64 127 0 2044640576 61219712 19794816
14:45:22 6723 8192000000 10954014064 11380654080 1939354256 19.142 99 60 118 1 2011866592 53567952 18944384
14:45:38 17700 8192000000 10938067488 11390164992 1959671280 19.303 100 32 64 1 2025247456 54545584 11030592
14:46:05 15142 8192000000 10903329744 11347677184 1912513680 18.927 98 46 88 1 1973916864 46251968 15151216
14:46:30 15800 8192000000 10897501088 11347804160 1942719136 19.168 100 33 66 2 1995167232 40665680 11782416
14:47:00 8881 8192000000 10913802032 11352309760 1942313680 19.165 100 42 84 1 2000519184 44435552 13769952
14:47:32 4132 8192000000 10910627216 11341000704 1926875152 19.042 99 48 97 2 1989023680 46595888 15552640
14:47:45 7902 8192000000 10923056016 11361173504 1946299744 19.197 100 47 94 2 2014289664 53047104 14942816
14:48:09 18620 8192000000 10920274672 11377422336 1945471680 19.190 100 33 66 3 2012859456 56668448 10719328
14:48:42 25165 8192000000 10915331648 11366260736 1921506416 18.999 99 26 52 0 1980556336 49968608 9081312
14:49:14 21342 8192000000 10903117232 11356291072 1946644672 19.200 100 29 58 0 1992889488 36741472 9503344
14:49:59 30482 8192000000 10902004560 11365924864 1926769104 19.041 99 22 44 2 1972234112 37956032 7508976
14:50:44 40665 8192000000 10914433904 11363733504 1949884416 19.226 100 28 56 1 1997902720 38893312 9124992
14:51:56 22064 8192000000 10910282704 11364503552 1923614816 19.016 99 27 54 2 1983778464 49963952 10199696
14:52:30 21583 8192000000 10887985360 11356778496 1907826720 18.889 99 21 40 0 1966686992 51391552 7468720
14:53:04 8126 8192000000 10901525680 11356962816 1928338096 19.054 100 32 64 0 1973077904 34799968 9939840
14:53:19 12369 8192000000 10892100912 11368148992 1935717312 19.113 100 22 45 2 1983252432 40516544 7018576
14:53:38 5721 8192000000 10886943728 11359907840 1936918624 19.122 100 10 20 1 1972609360 32136128 3554608
14:53:53 12191 8192000000 10875147360 11339091968 1937180272 19.124 100 8 16 0 1962975200 22982960 2811968
14:54:14 105598 8192000000 10868100816 11335036928 1904365328 18.861 98 33 65 1 1927442672 13538128 9539216
14:56:09 38008 8192000000 10864641392 11305947136 1888538000 18.734 98 21 42 0 1907316400 12786128 5992272
14:57:01 30826 8192000000 10855969680 11289415680 1890125936 18.747 98 42 83 2 1909575616 7905040 11544640
14:57:39 51738 8192000000 10898580592 11326316544 1932228304 19.085 100 44 88 0 1953756464 9426688 12101472
14:58:45 30605 8192000000 10879274256 11329437696 1944367504 19.182 100 50 97 2 1966267840 8811952 13088384
14:59:23 57233 8192000000 10850431712 11311828992 1857972496 18.487 96 7 14 1 1868441520 8447264 2021760
15:00:26 31889 8192000000 10857597568 11319230464 1914958272 18.946 99 11 22 1 1929375808 11206112 3211424
15:01:04 37494 8192000000 10855120400 11317321728 1914147568 18.940 99 8 16 0 1927469408 11412880 1908960
15:01:48 33461 8192000000 10862845968 11328372736 1944152912 19.180 100 5 10 0 1954141200 9130448 857840
15:02:30 118213 8192000000 10920153648 11380432896 1950202768 19.228 99 31 62 1 1984026576 24760304 9063504
15:04:34 40407 8192000000 10923687952 11388821504 1983184304 19.490 100 18 36 1 2009606128 20829712 5592112
15:05:31 57284 8192000000 10893883328 11374448640 1937822928 19.129 98 14 28 0 1968278992 26059040 4397024
15:06:34 79960 8192000000 10881514096 11350380544 1936691104 19.120 99 21 42 0 1972629072 29262480 6675488
15:08:06 58950 8192000000 10907086752 11362594816 1957096608 19.283 99 35 67 1 1976676928 9636720 9943600
15:09:13 48893 8192000000 10890500480 11360505856 1951413696 19.238 99 30 60 2 1975618624 15214784 8990144
15:10:10 46143 8192000000 10886957040 11367604224 1965008016 19.346 100 14 28 4 1986960784 17873728 4079040
15:11:10 44803 8192000000 10880301152 11370639360 1960071504 19.307 100 8 15 1 1979674064 17713872 1888688
15:12:01 45241 8192000000 10904732256 11370479616 1963537728 19.334 100 6 12 0 1978360992 13410144 1413120
15:12:55 44094 8192000000 10923125392 11374129152 1961368944 19.317 99 30 59 4 1977669680 8228240 8072496
15:13:53 19038 8192000000 10905934144 11365761024 1968092672 19.370 99 50 99 0 1992531760 9992528 14446560
15:14:18 57244 8192000000 10896691344 11360858112 1956663696 19.280 99 20 40 1 1973500560 11085728 5751136
15:15:31 88659 8192000000 10918836848 11395579904 1979104512 19.458 100 19 38 1 2000823296 15527216 6191568
15:18:07 36623 8192000000 10933600432 11394142208 1980705248 19.470 99 31 61 1 1999110528 10254208 8151072
15:18:50 59417 8192000000 10917906144 11398705152 1998321504 19.609 100 13 26 0 2013120784 11276592 3522688
15:20:02 75746 8192000000 10899598112 11378319360 1903160320 18.852 95 22 44 2 1918400512 9247088 5993104
15:21:24 82884 8192000000 10923190320 11391414272 1930360448 19.070 97 25 50 0 1949594688 12171264 7062976
15:23:50 57571 8192000000 10915805136 11367178240 1913796880 18.937 96 9 17 2 1927351760 11361648 2193232
15:24:56 40029 8192000000 10896914720 11362574336 1939743088 19.145 98 20 40 1 1955355440 10384784 5227568
15:25:44 141723 8192000000 10903621856 11362324480 1916353136 18.958 97 21 42 0 1934612912 12423664 5836112
15:28:24 39184 8192000000 10920568816 11381125120 1989025776 19.536 100 46 90 1 2007121248 6143760 11951712
15:29:11 20480 8192000000 10923243184 11379306496 1984089488 19.497 100 45 90 0 2006567488 10053824 12424176
15:29:44 36311 8192000000 10912893264 11375501312 1975907312 19.432 99 42 84 3 2000372992 12518064 11947616
15:30:27 45466 8192000000 10899512880 11389059072 1966657664 19.359 99 23 46 2 1989556320 16984192 5914464
15:31:20 33096 8192000000 10903499120 11388301312 1977036368 19.441 100 7 14 0 1993492496 14809520 1646608
15:31:59 55405 8192000000 10857473712 11342417920 1853183200 18.448 94 11 22 0 1869040960 12648256 3209504
15:33:03 38664 8192000000 10888512928 11362238464 1960983376 19.314 100 19 38 0 1973736096 6574928 6177792
15:33:55 49359 8192000000 10875862256 11347894272 1921223584 18.997 98 17 34 1 1936791296 10924432 4643280
15:34:59 51754 8192000000 10873866944 11338551296 1904671408 18.864 97 15 30 1 1918705552 10231184 3802960
15:35:59 26088 8192000000 10870830848 11324805120 1890862128 18.753 97 21 42 1 1902747456 5843984 6041344
15:36:39 20417 8192000000 10859284336 11316838400 1899340608 18.821 98 50 100 0 1923787008 10116064 14330336
15:37:09 53884 8192000000 10834100448 11308933120 1843339136 18.368 96 20 41 1 1858677920 9792464 5546320
15:38:09 37888 8192000000 10833551024 11297472512 1884257344 18.699 98 10 20 0 1896763056 9422256 3083456
15:38:55 44686 8192000000 10884668896 11332923392 1920241728 18.989 99 25 50 0 1940210384 13030048 6938608
15:39:50 34564 8192000000 10856476416 11318005760 1877716416 18.647 97 35 69 2 1903598080 16026736 9854928
15:40:31 69973 8192000000 10850051888 11318030336 1906835552 18.881 99 20 40 1 1931942144 19107952 5998640
15:41:52 105689 8192000000 10874162496 11345219584 1882912736 18.689 97 16 32 2 1897438896 10126128 4400032
15:43:50 47050 8192000000 10869412976 11313979392 1874210960 18.618 97 25 50 0 1889379520 8647600 6520960
15:44:46 97872 8192000000 10865362896 11323748352 1904583776 18.863 98 46 92 1 1932983440 15883264 12516400
15:46:50 41616 8192000000 10851662480 11311759360 1885501392 18.710 97 22 44 1 1898733248 6863280 6368576
15:47:38 30786 8192000000 10842590320 11313676288 1906070512 18.875 99 17 35 0 1920524240 9703808 4749920
15:48:26 79167 8192000000 10844955568 11325136896 1892810816 18.768 98 5 10 1 1904102816 9892432 1399568
15:49:51 23608 8192000000 10853353408 11337674752 1932559296 19.087 100 4 8 0 1946456480 12796480 1100704
15:50:54 50248 8192000000 10879153248 11348144128 1934063136 19.099 99 23 46 1 1951990592 11522768 6404688
15:52:15 69249 8192000000 10886409360 11360198656 1954520112 19.262 100 25 50 0 1976636816 14761296 7355408
15:53:32 97723 8192000000 10870318752 11343450112 1900229344 18.828 97 21 42 2 1918449616 11873936 6346336
15:55:23 40861 8192000000 10884212128 11347054592 1920970768 18.995 98 36 72 2 1940610880 9808128 9831984
15:56:15 33377 8192000000 10878045696 11344343040 1934961888 19.107 99 28 56 2 1952887056 10218656 7706512
15:57:01 29671 8192000000 10881791072 11341455360 1926849664 19.042 98 28 56 1 1943190128 9138224 7202240
15:57:37 60137 8192000000 10887742080 11353481216 1945465568 19.190 99 20 39 1 1962540784 11280192 5795024
15:58:44 75320 8192000000 10905263040 11358670848 1869002880 18.576 95 14 28 0 1886542128 13958208 3581040
16:00:07 67768 8192000000 10902876416 11370323968 1928774976 19.057 98 25 50 0 1950633408 14825712 7032720
16:01:21 114036 8192000000 10908606720 11372572672 1925514208 19.031 98 5 10 2 1937094768 10435264 1145296
16:03:27 71216 8192000000 10945548288 11383681024 1960039056 19.306 99 23 46 1 1975827200 9331152 6456992
16:04:49 77921 8192000000 10942622512 11390799872 1953810800 19.257 98 50 100 2 1981791312 13882368 14098144
16:07:10 36159 8192000000 10902568752 11397705728 1982884928 19.488 100 10 18 1 1999721968 14451440 2385600
16:08:01 64875 8192000000 10887909024 11368960000 1940355136 19.150 98 12 23 1 1958699024 14459872 3884016
16:09:12 68657 8192000000 10881133072 11354009600 1931451344 19.078 98 12 24 1 1949132624 13634256 4047024
16:10:26 44675 8192000000 10898722400 11371958272 1948648704 19.216 99 7 14 0 1968394320 17832880 1912736
16:11:20 28009 8192000000 10891119296 11363495936 1951736496 19.240 99 20 40 0 1977902448 20204752 5961200
16:12:02 48262 8192000000 10906075536 11380867072 1971895712 19.400 100 20 40 0 1997217680 19916832 5405136
16:13:01 57195 8192000000 10897942768 11390521344 1938664272 19.136 98 16 31 1 1961643360 18372256 4606832
16:14:08 66229 8192000000 10882302576 11355824128 1894371152 18.781 96 15 30 0 1912270064 13641200 4257712
16:15:24 80896 8192000000 10881478736 11355299840 1858878048 18.494 95 19 38 0 1878269648 14487568 4904032
16:16:51 64830 8192000000 10896723968 11343347712 1883545344 18.694 96 25 50 3 1904746160 13975808 7225008
16:18:02 36349 8192000000 10878001920 11349499904 1926162240 19.036 99 33 66 2 1952265584 16686704 9416640
16:18:48 98639 8192000000 10874320704 11338682368 1870510304 18.588 96 16 32 0 1887959840 12988336 4461200
16:20:39 55042 8192000000 10855608128 11315638272 1867080544 18.561 96 18 36 1 1882578784 10541152 4957088
16:21:40 22522 8192000000 10870199360 11315425280 1884622256 18.702 97 46 92 0 1905925872 8541792 12761824
16:22:13 70674 8192000000 10845055696 11304144896 1846997744 18.398 96 26 52 0 1870119024 15872576 7248704
16:23:36 124565 8192000000 10837388704 11306954752 1880323072 18.668 98 19 38 0 1900746656 15044560 5379024
16:26:49 52339 8192000000 9950581216 10328649728 1074754480 11.597 56 7 14 0 1093492560 17281968 1456112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 29-03-2021 16:30:29 to 29-03-2021 16:31:00.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 118 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-03-2021 16:31:01 to 29-03-2021 16:31:03.

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          243585
MON$OLDEST_ACTIVE               245628
MON$OLDEST_SNAPSHOT             245628
MON$NEXT_TRANSACTION            245628
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                       2005248
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:138: 
:139: mscs-test-161.budzdorov.ru    Mon Mar 29 16:27:56 2021
:140:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:141: 
:142: 
:143: mscs-test-161.budzdorov.ru    Mon Mar 29 16:27:57 2021
:144:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:145: 
:146: 
:147: mscs-test-161.budzdorov.ru    Mon Mar 29 16:27:57 2021
:148:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:149: 
:150: 
:151: mscs-test-161.budzdorov.ru    Mon Mar 29 16:28:06 2021
:152:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:153: 
--- end of diff output ---

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

29.03.21 16:31:04. 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-03-29 16:31:06 No severe PSQL-related problems occured
29.03.21 16:31:07. End of report.