Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.03.2021 19:28
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 17446668 kB
MemAvailable 31478132 kB
Buffers 0 kB
Cached 14203200 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-25 19:27:19
DTS_END                         2021-03-25 19:27:19.7120
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(139:30) ==> SP_CANCEL_WRITE_OFF(41:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48036
TRN_ID                          244212
ATT_ID                          692
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: 9176.36 21387 1101163
customer order: creation 179.28 340 21514
customer order: refuse 15.15 326 1818
order to supplier: creation 47.58 1286 5709
order to supplier: removal 3.53 101661 424
invoice (draft): creation 47.67 3173 5720
invoice (draft): removal 50.78 852 6093
invoice accept: apply 43.39 16785 5207
invoice accept: cancel 45.68 899 5481
customer reserve: creation 3983.13 168 477976
customer reserve: removal 4452.64 64 534317
realization accept: apply 86.96 158 10435
realization accept: cancel 84.58 112 10150
payment from customer: creation 62.41 104 7489
payment from customer: removal 6.06 71 727
payment to supplier: creation 51.39 111 6167
payment to supplier: removal 3.88 63 465
service: total inventory turnovers 4.97 1103 597
service: total monetary turnovers 6.38 28 766
service: aggregate perf. data 0.87 19468 104
service: refresh index statistics 0.03 280976 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-03-2021 19:28:34 to 25-03-2021 19:28:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7733
TEST_TIME 2 7052
TEST_TIME 3 6659
TEST_TIME 4 5728
TEST_TIME 5 5602
TEST_TIME 6 5673
TEST_TIME 7 6172
TEST_TIME 8 6006
TEST_TIME 9 6180
TEST_TIME 10 6817
TEST_TIME 11 6560
TEST_TIME 12 6471
TEST_TIME 13 6475
TEST_TIME 14 6905
TEST_TIME 15 6895
TEST_TIME 16 7105
TEST_TIME 17 7195
TEST_TIME 18 7759
TEST_TIME 19 8158
TEST_TIME 20 8071
TEST_TIME 21 8175
TEST_TIME 22 8415
TEST_TIME 23 8622
TEST_TIME 24 8706
TEST_TIME 25 8589
TEST_TIME 26 8710
TEST_TIME 27 8807
TEST_TIME 28 9492
TEST_TIME 29 10757
TEST_TIME 30 10543
TEST_TIME 31 10515
TEST_TIME 32 10766
TEST_TIME 33 10496
TEST_TIME 34 10375
TEST_TIME 35 10108
TEST_TIME 36 10214
TEST_TIME 37 10237
TEST_TIME 38 10025
TEST_TIME 39 9978
TEST_TIME 40 9862
TEST_TIME 41 9831
TEST_TIME 42 9843
TEST_TIME 43 9813
TEST_TIME 44 9827
TEST_TIME 45 9717
TEST_TIME 46 9596
TEST_TIME 47 9635
TEST_TIME 48 9573
TEST_TIME 49 9578
TEST_TIME 50 9589
TEST_TIME 51 9622
TEST_TIME 52 9614
TEST_TIME 53 9617
TEST_TIME 54 9630
TEST_TIME 55 9733
TEST_TIME 56 9713
TEST_TIME 57 9715
TEST_TIME 58 9787
TEST_TIME 59 9877
TEST_TIME 60 9930
TEST_TIME 61 9892
TEST_TIME 62 9795
TEST_TIME 63 9727
TEST_TIME 64 9614
TEST_TIME 65 9613
TEST_TIME 66 9573
TEST_TIME 67 9502
TEST_TIME 68 9429
TEST_TIME 69 9438
TEST_TIME 70 9354
TEST_TIME 71 9320
TEST_TIME 72 9294
TEST_TIME 73 9318
TEST_TIME 74 9277
TEST_TIME 75 9313
TEST_TIME 76 9276
TEST_TIME 77 9334
TEST_TIME 78 9491
TEST_TIME 79 9418
TEST_TIME 80 9461
TEST_TIME 81 9445
TEST_TIME 82 9442
TEST_TIME 83 9476
TEST_TIME 84 9517
TEST_TIME 85 9537
TEST_TIME 86 9470
TEST_TIME 87 9406
TEST_TIME 88 9370
TEST_TIME 89 9341
TEST_TIME 90 9319
TEST_TIME 91 9286
TEST_TIME 92 9236
TEST_TIME 93 9228
TEST_TIME 94 9279
TEST_TIME 95 9314
TEST_TIME 96 9331
TEST_TIME 97 9358
TEST_TIME 98 9331
TEST_TIME 99 9418
TEST_TIME 100 9398
TEST_TIME 101 9341
TEST_TIME 102 9421
TEST_TIME 103 9481
TEST_TIME 104 9491
TEST_TIME 105 9492
TEST_TIME 106 9496
TEST_TIME 107 9436
TEST_TIME 108 9431
TEST_TIME 109 9399
TEST_TIME 110 9385
TEST_TIME 111 9394
TEST_TIME 112 9363
TEST_TIME 113 9329
TEST_TIME 114 9330
TEST_TIME 115 9274
TEST_TIME 116 9265
TEST_TIME 117 9247
TEST_TIME 118 9231
TEST_TIME 119 9225
TEST_TIME 120 9180

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 25-03-2021 19:28:37 to 25-03-2021 19:28:41.

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 1543191 1543191 0 0.00 0 18327 6 0 0
doc_list_biud 1543191 1543191 0 0.00 0 68509 28 0 0
sp_add_invoice_to_stock 5346 5207 139 2.60 26 177931 16785 0 139
sp_cancel_adding_invoice 5481 5481 0 0.00 3 76326 899 0 0
sp_cancel_client_order 1818 1818 0 0.00 4 11508 327 0 0
sp_cancel_customer_reserve 534317 534317 0 0.00 1 68513 65 0 0
sp_cancel_pay_from_customer 727 727 0 0.00 3 6244 72 0 0
sp_cancel_pay_to_supplier 465 465 0 0.00 3 4447 63 0 0
sp_cancel_supplier_invoice 6101 6093 8 0.13 2 21460 853 0 8
sp_cancel_supplier_order 424 424 0 0.00 9 1022239 101661 0 0
sp_cancel_write_off 10150 10150 0 0.00 1 11719 112 0 0
sp_client_order 21514 21514 0 0.00 3 24470 341 0 0
sp_customer_reserve 477976 477976 0 0.00 0 57543 169 0 0
sp_fill_shopping_cart 32933 32933 0 0.00 1 15843 39 0 0
sp_fill_shopping_cart_clo_res 477962 477962 0 0.00 0 18330 14 0 0
sp_get_clo_for_invoice 5192 5192 0 0.00 0 26216 283 0 0
sp_kill_cost_storno 16823 16823 0 0.00 0 8139 55 0 0
sp_kill_qstorno_ret_qs2qd 1085301 1085301 0 0.00 0 68507 35 0 0
sp_kill_qty_storno 573910 573910 0 0.00 0 68509 75 0 0
sp_lock_selected_doc 21709 21709 0 0.00 0 5486 3 0 0
sp_make_cost_storno 29283 29283 0 0.00 0 9748 45 0 0
sp_multiply_rows_for_pdistr 29283 29283 0 0.00 0 8501 25 0 0
sp_multiply_rows_for_qdistr 21514 21514 0 0.00 0 15520 162 0 0
sp_pay_from_customer 7489 7489 0 0.00 4 13963 105 0 0
sp_pay_to_supplier 6167 6167 0 0.00 5 11006 111 0 0
sp_payment_common 13656 13656 0 0.00 1 13368 28 0 0
sp_qd_handle_on_cancel_clo 1818 1818 0 0.00 0 11502 303 0 0
sp_qd_handle_on_invoice_upd_sts 10673 10673 0 0.00 0 36669 310 0 0
sp_qd_handle_on_reserve_upd_sts 10435 10435 0 0.00 0 14821 50 0 0
sp_reserve_write_off 10435 10435 0 0.00 6 14845 159 0 0
sp_supplier_invoice 5720 5720 0 0.00 6 101981 3173 0 0
sp_supplier_order 5709 5709 0 0.00 5 36315 1286 0 0
srv_aggregate_perf_data 104 104 0 0.00 2354 408865 19469 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1090 213906 31470 0 0
srv_find_qd_qs_mism 1051134 1051134 0 0.00 0 18325 5 0 0
srv_make_invnt_saldo 597 597 0 0.00 31 82053 1103 0 0
srv_make_money_saldo 766 766 0 0.00 1 5291 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 78838 447439 280977 0 0
t$perf-abend:sp_add_invoice_to_stock 139 139 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-norm:sp_add_invoice_to_stock 5207 5207 0 0.00 0 9387 132 0 0
t$perf-norm:sp_cancel_adding_invoice 444 444 0 0.00 0 6983 133 0 0
t$perf-norm:sp_cancel_client_order 1818 1818 0 0.00 0 2429 8 0 0
t$perf-norm:sp_cancel_customer_reserve 726 726 0 0.00 0 970 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 727 727 0 0.00 0 3906 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 465 465 0 0.00 0 878 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 446 446 0 0.00 0 726 14 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 18923 1555 0 0
t$perf-norm:sp_cancel_write_off 1035 1035 0 0.00 0 3176 7 0 0
t$perf-norm:sp_client_order 21514 21514 0 0.00 0 7029 15 0 0
t$perf-norm:sp_customer_reserve 1061 1061 0 0.00 0 548 4 0 0
t$perf-norm:sp_pay_from_customer 7489 7489 0 0.00 0 7388 10 0 0
t$perf-norm:sp_pay_to_supplier 6167 6167 0 0.00 0 7082 10 0 0
t$perf-norm:sp_reserve_write_off 10435 10435 0 0.00 0 9312 8 0 0
t$perf-norm:sp_supplier_invoice 5720 5720 0 0.00 0 3574 12 0 0
t$perf-norm:sp_supplier_order 5709 5709 0 0.00 0 9225 14 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 172 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 1125 12 0 0
t$perf-norm:srv_make_invnt_saldo 597 597 0 0.00 0 1389 18 0 0
t$perf-norm:srv_make_money_saldo 766 766 0 0.00 0 1430 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 10656 10378 278 2.60 0 7699 20 0 278
v_all_customers 39394 39394 0 0.00 0 123 1 0 0
v_all_suppliers 31730 31730 0 0.00 0 23 1 0 0
v_all_wares 43028 43028 0 0.00 0 177 1 0 0
v_cancel_adding_invoice 888 888 0 0.00 0 270 6 0 0
v_cancel_client_order 3636 3636 0 0.00 0 4437 6 0 0
v_cancel_customer_prepayment 1454 1454 0 0.00 0 990 6 0 0
v_cancel_customer_reserve 1452 1452 0 0.00 0 4397 7 0 0
v_cancel_payment_to_supplier 930 930 0 0.00 0 4437 9 0 0
v_cancel_supplier_invoice 908 892 16 1.76 0 2868 26 0 16
v_cancel_supplier_order 848 848 0 0.00 0 1251 5 0 0
v_cancel_write_off 2070 2070 0 0.00 0 2728 15 0 0
v_max_id_clo_ord 5708 5708 0 0.00 0 1417 2 0 0
v_max_id_clo_res 1061 1061 0 0.00 0 2582 11 0 0
v_max_id_ord_sup 5711 5711 0 0.00 0 4415 4 0 0
v_max_non_paid_invoice 1721 1721 0 0.00 0 10967 8 0 0
v_max_non_paid_realizn 3994 3994 0 0.00 0 3570 5 0 0
v_min_id_clo_ord 5708 5708 0 0.00 0 9301 9 0 0
v_min_id_clo_res 1061 1061 0 0.00 0 2871 9 0 0
v_min_id_ord_sup 5711 5711 0 0.00 0 4951 7 0 0
v_min_non_paid_invoice 6167 6167 0 0.00 0 8648 16 0 0
v_min_non_paid_realizn 7489 7489 0 0.00 0 8317 17 0 0
v_our_firm 10624 10624 0 0.00 0 63 1 0 0
v_reserve_write_off 20870 20870 0 0.00 0 10558 9 0 0
x_lock_depdocs_on_canc_invoice 11128 11128 0 0.00 0 18003 109 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 5762 301 0 0
x_make_qstorno_1000_1200 5709 5709 0 0.00 2 36298 1202 0 0
x_make_qstorno_1200_2000 5720 5720 0 0.00 2 101969 3034 0 0
x_make_qstorno_2100_3300 477976 477976 0 0.00 0 57542 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-03-2021 19:28:42 to 25-03-2021 19:28:46.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:23 7 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:29 24209 8192000000 10256746256 10568699904 941215760 10.305 73 54 107 2 961988176 2551488 18220928
16:58:01 41633 8192000000 10364209296 10679304192 1389880144 14.505 100 92 184 0 1424863968 4655664 30328160
16:58:54 27836 8192000000 10405513344 10732204032 1455919152 15.090 100 87 173 0 1490040960 6482992 27638816
16:59:30 15798 8192000000 10421657968 10751303680 1475901632 15.265 100 88 176 0 1511383088 7337856 28143600
16:59:55 22580 8192000000 10444426528 10774757376 1500632640 15.482 100 92 184 0 1537776544 7876080 29267824
17:00:33 13417 8192000000 10452902576 10787176448 1507402224 15.541 100 88 176 0 1543152384 8412960 27337200
17:00:55 21811 8192000000 10473534048 10810814464 1520776624 15.657 100 86 172 1 1556793680 8872864 27144192
17:01:28 16707 8192000000 10484124704 10828345344 1545055200 15.867 100 83 166 1 1579420368 9057360 25307808
17:01:52 16344 8192000000 10510307968 10859974656 1568792448 16.072 100 77 154 0 1601277968 9314656 23170864
17:02:16 14476 8192000000 10536166304 10886725632 1595865024 16.304 100 83 166 0 1631129952 10053616 25211312
17:02:39 18319 8192000000 10564614224 10917302272 1608067728 16.408 100 82 163 2 1643829120 10961536 24799856
17:03:04 11109 8192000000 10574893120 10933149696 1628405664 16.581 100 72 144 0 1660361120 11238128 20717328
17:03:24 11030 8192000000 10605868608 10963562496 1653322576 16.792 100 86 172 0 1690584016 11783280 25478160
17:03:43 9769 8192000000 10601353408 10968174592 1664064160 16.883 100 74 148 1 1698071952 12587680 21420112
17:04:00 9160 8192000000 10621351344 10984566784 1678958752 17.009 100 82 164 0 1715146416 12530400 23657264
17:04:16 11253 8192000000 10634616480 11001917440 1691231200 17.112 100 82 164 0 1728378784 13447248 23700336
17:04:35 6183 8192000000 10643039968 11012870144 1704070560 17.219 100 80 158 1 1740176144 13750112 22355472
17:04:47 7439 8192000000 10654855504 11025604608 1711792176 17.284 100 80 160 0 1748366560 13496240 23078144
17:05:02 8600 8192000000 10655018880 11033219072 1716626688 17.324 100 69 137 0 1752965344 16899360 19439296
17:05:18 8990 8192000000 10682479136 11056812032 1739341856 17.513 100 77 155 0 1772740816 11659504 21739456
17:05:35 4759 8192000000 10681096896 11059277824 1748638192 17.590 100 76 153 3 1782818928 12670512 21510224
17:05:52 5646 8192000000 10697780640 11072405504 1762683376 17.707 100 82 160 1 1797607360 12751344 22172640
17:06:04 4011 8192000000 10693374816 11080658944 1766388960 17.737 100 69 138 1 1799092112 13099392 19603760
17:06:20 6630 8192000000 10716931024 11093377024 1772101520 17.784 100 73 146 3 1804617616 12756128 19759968
17:06:33 4811 8192000000 10739152288 11124281344 1799947984 18.013 100 76 152 3 1834463824 12509840 22006000
17:06:44 2811 8192000000 10746600144 11124948992 1809892592 18.095 100 78 154 2 1844226176 12790160 21543424
17:06:55 3866 8192000000 10756136672 11137265664 1814082048 18.129 100 73 146 1 1847302336 12504432 20715856
17:07:05 2993 8192000000 10768057952 11153821696 1824827920 18.217 100 84 166 0 1861639216 12874368 23936928
17:07:15 3068 8192000000 10773307424 11158245376 1835309104 18.303 100 88 173 4 1873674832 14698560 23667168
17:07:24 2410 8192000000 10777104496 11159449600 1835463520 18.304 100 95 191 1 1876433456 14514336 26455600
17:07:33 3029 8192000000 10776465376 11164123136 1839031440 18.333 100 85 170 3 1876437040 13340224 24065376
17:07:42 2943 8192000000 10789356368 11173912576 1841563904 18.354 100 88 174 1 1879736640 14245824 23926912
17:07:53 1653 8192000000 10794640576 11177811968 1848486320 18.410 100 95 191 3 1888477728 13704848 26286560
17:08:01 2606 8192000000 10788004320 11178745856 1851237456 18.432 100 85 166 1 1887528176 12856672 23434048
17:08:10 1530 8192000000 10801794720 11185135616 1855832176 18.469 100 89 178 0 1893904368 13374432 24697760
17:08:18 1664 8192000000 10808384208 11192549376 1857570992 18.484 100 92 184 1 1898549856 15118832 25860032
17:08:26 1522 8192000000 10808571968 11193085952 1861691856 18.517 100 89 176 0 1900242784 13301280 25249648
17:08:34 2030 8192000000 10810904672 11198132224 1867027440 18.560 100 93 186 0 1907029792 13750912 26251440
17:08:42 1547 8192000000 10809729616 11197505536 1867422496 18.563 100 91 183 1 1907404896 14067568 25914832
17:08:50 32696 8192000000 10801616672 11198480384 1865115600 18.545 100 62 124 1 1890900992 9720000 16065392
17:09:30 1855 8192000000 10834054000 11220856832 1879348800 18.660 100 94 189 0 1917863760 12151456 26363504
17:09:38 4467 8192000000 10806421040 11212681216 1873141776 18.610 100 51 102 2 1899100880 11915792 14043312
17:09:49 5968 8192000000 10796349008 11210125312 1876625072 18.638 100 46 92 1 1899754240 9705248 13423920
17:10:04 2272 8192000000 10803277456 11211390976 1880383408 18.668 100 54 107 3 1903241200 8105088 14752704
17:10:14 4777 8192000000 10808805584 11218948096 1887199696 18.723 100 50 101 0 1909148720 7954032 13994992
17:10:26 5184 8192000000 10795897360 11219771392 1888870880 18.737 100 32 64 1 1905247920 7355088 9021952
17:10:38 8453 8192000000 10793317744 11225513984 1891420896 18.757 100 25 50 0 1905329120 6860480 7047744
17:10:53 8519 8192000000 10805539120 11233984512 1893746000 18.776 100 24 48 1 1911160192 10932928 6481264
17:11:07 8958 8192000000 10814757952 11243610112 1895301872 18.788 100 23 46 1 1916746352 15344048 6100432
17:11:23 11983 8192000000 10799441568 11233775616 1897070432 18.803 100 22 44 1 1909237040 6303744 5862864
17:11:42 6681 8192000000 10805080336 11234615296 1899577376 18.823 100 24 48 1 1913910128 7122928 7209824
17:11:55 7160 8192000000 10804676480 11234803712 1899770544 18.824 100 25 50 0 1913298592 6321968 7206080
17:12:08 18317 8192000000 10828372048 11236896768 1904526048 18.863 100 32 64 5 1919329840 5891200 8912592
17:12:36 65548 8192000000 10847445248 11261485056 1908742592 18.897 100 45 90 2 1927696432 5565808 13388032
17:13:48 1096 8192000000 10872015024 11270021120 1922702640 19.008 100 94 191 0 1960114640 9386736 28025264
17:13:55 9099 8192000000 10809663088 11254214656 1908820416 18.897 100 29 58 0 1925302960 8665936 7816608
17:14:13 6133 8192000000 10828501360 11257716736 1908835824 18.897 100 30 60 1 1923407920 6638576 7933520
17:14:26 4985 8192000000 10824241248 11259047936 1914243056 18.941 100 35 70 1 1932354944 7612512 10499376
17:14:39 6693 8192000000 10833708912 11262763008 1913215552 18.932 100 25 50 1 1925880112 5639840 7024720
17:14:54 6767 8192000000 10832280064 11264491520 1918893280 18.978 100 36 72 3 1935541184 6327104 10320800
17:15:08 6441 8192000000 10829601216 11262259200 1915530624 18.951 100 21 42 2 1927563328 5252624 6780080
17:15:21 8518 8192000000 10838946576 11270574080 1919260176 18.981 100 20 40 0 1930971584 6043792 5667616
17:15:38 12005 8192000000 10831822736 11270385664 1924894528 19.026 100 24 48 4 1937506448 5673824 6938096
17:15:57 9989 8192000000 10841801648 11270774784 1920641808 18.992 100 13 26 0 1929960288 5753456 3565024
17:16:20 35319 8192000000 10829654800 11270672384 1921537856 18.999 100 25 50 3 1934747568 5307840 7901872
17:17:08 19175 8192000000 10814251808 11260850176 1904825648 18.865 99 26 50 1 1918239744 6212672 7201424
17:17:34 6688 8192000000 10816096560 11249528832 1877942704 18.648 98 24 48 1 1890811408 6273600 6595104
17:17:50 9587 8192000000 10788891168 11220332544 1839032352 18.333 97 20 40 1 1850315632 5389104 5894176
17:18:08 9045 8192000000 10784170704 11220463616 1851537296 18.435 98 18 36 1 1862158128 5683568 4937264
17:18:24 6859 8192000000 10770371504 11194822656 1843674800 18.371 99 11 20 2 1852505488 5455472 3375216
17:18:39 10125 8192000000 10776509296 11199410176 1818715280 18.167 97 25 47 3 1831783184 5736560 7331344
17:18:55 8326 8192000000 10767811776 11192725504 1837498912 18.320 99 31 62 1 1852676624 6401584 8776128
17:19:12 6374 8192000000 10756599056 11170652160 1792820368 17.955 96 30 60 3 1807281712 6153472 8307872
17:19:27 7372 8192000000 10697081712 11120828416 1709589840 17.265 93 19 38 0 1720881008 5597472 5693696
17:19:41 8513 8192000000 10710855744 11114774528 1770144464 17.768 98 13 26 1 1779384464 4917200 4322800
17:19:56 10311 8192000000 10714787264 11121926144 1714322640 17.305 95 23 46 1 1730799296 9559072 6917584
17:20:18 6897 8192000000 10730494368 11152211968 1812943136 18.120 100 28 56 1 1827085376 5653920 8488320
17:20:33 12661 8192000000 10719126592 11135344640 1775128208 17.809 98 21 41 1 1786454080 5512960 5812912
17:20:53 67484 8192000000 10704997792 11128463360 1717536864 17.332 94 35 68 5 1732157088 4988864 9631360
17:22:08 6891 8192000000 10689121776 11101040640 1715985056 17.319 95 29 58 0 1729692320 4899776 8807488
17:22:25 8930 8192000000 10704283920 11118292992 1744620288 17.557 97 27 54 1 1757910864 6067488 7223088
17:22:42 4729 8192000000 10730885616 11138326528 1791992528 17.948 99 33 65 3 1807622432 5313280 10316624
17:22:55 8570 8192000000 10718634592 11136921600 1789793008 17.930 99 26 52 0 1803907840 5752496 8362336
17:23:13 6943 8192000000 10734278208 11157778432 1818791440 18.168 100 23 46 1 1832317968 6402336 7124192
17:23:27 9495 8192000000 10754951296 11171115008 1832185648 18.277 100 23 45 3 1844529440 5125296 7218496
17:23:43 6718 8192000000 10751335136 11172524032 1813246032 18.122 99 25 51 4 1833502224 13605584 6650608
17:23:56 7137 8192000000 10739182448 11159699456 1815787664 18.143 99 26 52 0 1829570368 6390480 7392224
17:24:11 19210 8192000000 10757478128 11182678016 1822895392 18.201 99 21 40 1 1833739568 5177968 5666208
17:24:37 9082 8192000000 10779863296 11194269696 1847750624 18.404 100 31 61 0 1862303760 4997584 9555552
17:24:52 11292 8192000000 10764369088 11190194176 1832057008 18.276 99 25 48 3 1844664480 5814336 6793136
17:25:12 6987 8192000000 10767768048 11194982400 1856341824 18.474 100 19 38 1 1866971376 5509888 5119664
17:25:27 68998 8192000000 10773901952 11202703360 1866070912 18.552 100 34 68 0 1881563408 5235792 10256704
17:26:44 9541 8192000000 10768980336 11208110080 1868629424 18.573 100 27 54 2 1882919040 6521136 7768480
17:26:59 10283 8192000000 10804280784 11228667904 1878473536 18.653 100 31 62 1 1893721456 6416080 8831840
17:27:18 6312 8192000000 10841818416 11254263808 1898957344 18.818 100 49 92 3 1918196496 6586608 12652544
17:27:31 6431 8192000000 10843548720 11256938496 1911652144 18.920 100 50 100 1 1932907376 6776432 14478800
17:27:45 4967 8192000000 10848696320 11264397312 1914270768 18.941 100 54 107 2 1938491920 8689984 15531168
17:27:57 18266 8192000000 10852545120 11270897664 1918197776 18.972 100 54 109 2 1942979120 9485152 15296192
17:28:23 4733 8192000000 10856844880 11274792960 1923990560 19.019 100 64 128 0 1952356704 10320400 18045744
17:28:37 23904 8192000000 10860295632 11285450752 1927862784 19.050 100 55 111 0 1954890640 11566960 15460896
17:29:14 15711 8192000000 10855523072 11284275200 1931592640 19.080 100 48 96 1 1955999216 10594112 13812464
17:29:40 30000 8192000000 10874149616 11308093440 1940638768 19.152 100 46 92 0 1963136624 9447744 13050112
17:30:22 19993 8192000000 10876744336 11310116864 1951113232 19.235 100 45 90 2 1974703552 10595232 12995088
17:30:55 78707 8192000000 10879992880 11325657088 1955622528 19.271 100 33 66 2 1974954320 9160464 10171328
17:32:25 10365 8192000000 10893799136 11328364544 1962821456 19.328 100 36 72 3 1986875280 12675680 11378144
17:32:51 24458 8192000000 10905322304 11347165184 1974890816 19.424 100 43 85 2 2000729600 12935088 12903696
17:33:22 11575 8192000000 10922610576 11347951616 1978226032 19.451 100 47 93 1 2005574528 14215408 13133088
17:33:41 22517 8192000000 10921935952 11353907200 1979253680 19.459 100 49 97 0 2009229072 15936192 14039200
17:34:15 12850 8192000000 10919928160 11359850496 1983974128 19.496 100 49 98 3 2014765376 15286608 15504640
17:34:36 6755 8192000000 10920870352 11359096832 1986392272 19.515 100 48 95 2 2014783024 13716592 14674160
17:34:50 7292 8192000000 10918235168 11354968064 1983550448 19.493 100 47 94 2 2010239824 13552976 13136400
17:35:07 15608 8192000000 10930883584 11365801984 1988155904 19.529 100 50 99 0 2018328832 15378224 14794704
17:35:31 19420 8192000000 10934817744 11374632960 1998346608 19.610 100 52 102 2 2030267360 17164432 14756320
17:35:58 4710 8192000000 10940973984 11374997504 1984225728 19.498 99 58 116 2 2021477552 20043392 17208432
17:36:12 9681 8192000000 10944091216 11381858304 2000421776 19.626 100 53 104 1 2034564000 18878960 15263264
17:36:30 14636 8192000000 10941219680 11377176576 1992432864 19.563 100 49 96 1 2027620272 20360080 14827328
17:36:52 7600 8192000000 10949494944 11382460416 1995984688 19.591 100 47 93 1 2033364400 23547520 13832192
17:37:38 8104 8192000000 10953404112 11392196608 2010812912 19.708 100 51 103 4 2044514272 18200080 15501280
17:37:54 14676 8192000000 10950544960 11391885312 2010662080 19.707 100 51 102 0 2043095808 16864080 15569648
17:38:19 5483 8192000000 10968692144 11402006528 2017371888 19.760 100 53 106 0 2053555904 19514176 16669840
17:38:33 15452 8192000000 10975252448 11414286336 2019351280 19.775 100 51 100 0 2057439744 22916176 15172288
17:38:56 6621 8192000000 10977049888 11410268160 1990396656 19.547 98 66 132 2 2034272320 24318256 19557408
17:39:18 19378 8192000000 10986422576 11428777984 2024236176 19.813 100 55 110 0 2070124608 28743296 17145136
17:39:56 3825 8192000000 10978096432 11418456064 2008017856 19.686 99 52 105 2 2053343664 28951296 16374512
17:40:09 7155 8192000000 10990945424 11423899648 2026292704 19.830 100 59 118 2 2075745968 31140848 18312416
17:40:28 5253 8192000000 11004427216 11434688512 2031580160 19.871 100 65 126 0 2086227264 35056224 19590880
17:40:41 8988 8192000000 10996765936 11441311744 2029994000 19.859 100 58 116 1 2085714432 37538592 18181840
17:40:58 5927 8192000000 10995451136 11436953600 2018591968 19.769 99 49 98 1 2073525392 38198352 16735072
17:41:12 5520 8192000000 10988995872 11422507008 2003509248 19.650 99 51 100 0 2058426208 38569760 16347200
17:41:26 2622 8192000000 10977828592 11408150528 1993593072 19.572 99 59 118 0 2050158240 37924208 18640960
17:41:37 7855 8192000000 10965365792 11391729664 1989687648 19.541 99 76 153 0 2051650832 38183024 23780160
17:41:52 3351 8192000000 10980154384 11412406272 2010947136 19.709 100 71 142 2 2069731792 36734992 22049664
17:42:05 1705 8192000000 10979358544 11405631488 1993834656 19.574 99 73 143 2 2052998240 37233568 21930016
17:42:15 5358 8192000000 10979288000 11414405120 2008517216 19.690 100 64 128 1 2067716208 39152016 20046976
17:42:33 3120 8192000000 10979741296 11417600000 2007554736 19.682 100 53 106 1 2065666640 40988240 17123664
17:42:44 2426 8192000000 10966617008 11396370432 1991111728 19.553 99 66 132 1 2051240096 39420864 20707504
17:42:55 7652 8192000000 10984129136 11412365312 2006494048 19.674 100 73 145 0 2071126896 42079904 22552944
17:43:12 6113 8192000000 10977334544 11408642048 2001630880 19.636 100 66 131 0 2064731952 41383760 21717312
17:43:45 4118 8192000000 10973469040 11406495744 2002305056 19.641 100 68 134 2 2065554832 42224960 21024816
17:43:59 9368 8192000000 10972159856 11408236544 1975446352 19.429 99 61 121 0 2038241664 43688032 19107280
17:44:23 2960 8192000000 10970283344 11391352832 1980828640 19.471 100 72 144 1 2048565008 44740256 22996112
17:44:33 5263 8192000000 10968209424 11394203648 1983877264 19.495 100 72 144 0 2053666112 46996032 22792816
17:44:50 4942 8192000000 10982520096 11408031744 2001354160 19.633 100 78 153 2 2070751808 43872400 25525248
17:45:01 3915 8192000000 10990152096 11413594112 2001466528 19.634 100 84 168 2 2071647056 44463504 25717024
17:45:17 2771 8192000000 11006945072 11429904384 2014897904 19.740 100 86 172 1 2090196736 49231376 26067456
17:45:26 1828 8192000000 10998368400 11410587648 1976304384 19.435 98 92 182 2 2055570640 50658512 28607744
17:45:37 7668 8192000000 10957473632 11383836672 1960754816 19.312 99 66 132 3 2026808736 44889776 21164144
17:45:55 19927 8192000000 10949851232 11397267456 1980910224 19.472 100 36 71 1 2036008592 42956656 12141712
17:46:33 12016 8192000000 10925647520 11378200576 1954213088 19.260 99 27 54 1 2002318592 39047008 9058496
17:46:52 12569 8192000000 10942943872 11375173632 1952077776 19.243 99 31 61 1 2001576816 38802768 10696272
17:47:12 4990 8192000000 10944125056 11370201088 1964242432 19.340 100 51 102 0 2020742320 40173728 16326160
17:47:24 2655 8192000000 10957818544 11375669248 1960617024 19.311 99 84 166 3 2029379376 42953680 25808672
17:47:34 4437 8192000000 10934318432 11361775616 1952208704 19.244 99 60 120 1 2016683392 45185776 19288912
17:47:45 7814 8192000000 10913716240 11342278656 1921251824 18.997 98 45 90 0 1983439584 47521712 14666048
17:48:00 6637 8192000000 10942815680 11363020800 1954776160 19.264 100 57 110 0 2021352272 48580816 17995296
17:48:13 5034 8192000000 10929622256 11360657408 1928247184 19.053 98 55 110 0 1993196032 47609376 17339472
17:48:27 7835 8192000000 10929554000 11364880384 1937070496 19.123 99 48 97 0 2003764816 50850384 15843936
17:48:44 12360 8192000000 10939659424 11374960640 1945350752 19.189 99 39 78 0 2008394768 49990816 13053200
17:49:05 14434 8192000000 10934434000 11369725952 1951474000 19.238 100 39 78 2 2016631440 51837264 13320176
17:49:26 10080 8192000000 10954055680 11394916352 1966146224 19.355 100 41 81 1 2035532992 55404992 13981776
17:49:44 7394 8192000000 10940813376 11382546432 1953624560 19.255 99 36 72 1 2016583968 50614336 12345072
17:50:01 10001 8192000000 10960078944 11383595008 1953157888 19.252 99 66 132 0 2025156976 51148208 20850880
17:50:20 1088 8192000000 10981544704 11395084288 1977220784 19.443 100 84 168 0 2056954736 53257648 26476304
17:50:28 5328 8192000000 10965193376 11400503296 1973422880 19.413 100 55 110 1 2047141792 56029072 17689840
17:50:42 7930 8192000000 10931101664 11378573312 1930274672 19.069 98 35 70 2 1995838176 53862000 11701504
17:51:11 42297 8192000000 10933952352 11379036160 1959828448 19.305 100 32 64 2 2021085024 50569616 10686960
17:52:04 24379 8192000000 10931438736 11378601984 1956334272 19.277 100 30 60 1 2015069664 48346912 10388480
17:52:50 17977 8192000000 10930854816 11379486720 1952331424 19.245 100 30 60 1 2014853056 52319216 10202416
17:54:08 31322 8192000000 10913688672 11370250240 1928007520 19.051 100 23 46 0 1999393312 62383504 9002288
17:54:46 30600 8192000000 10909698640 11364544512 1911855648 18.922 99 27 54 2 1987648656 65040144 10752864
17:55:38 8394 8192000000 10922105392 11369304064 1931376864 19.078 100 24 48 1 2000003648 59144288 9482496
17:56:18 35479 8192000000 10857223472 11331362816 1908346832 18.893 99 11 22 1 1944698016 32956448 3394736
17:57:05 19640 8192000000 10865168288 11310526464 1909490272 18.903 98 57 110 4 1930134336 4839488 15804576
17:57:33 10159 8192000000 10894579840 11330138112 1946291200 19.197 100 50 102 0 1971095872 10787952 14016720
17:57:52 28327 8192000000 10880808944 11336392704 1946451920 19.198 100 15 30 1 1964227792 13528416 4247456
17:58:27 51900 8192000000 10889607632 11361705984 1938537040 19.135 99 8 16 2 1956360224 15583888 2239296
17:59:26 61201 8192000000 10904637552 11338330112 1923954288 19.019 98 24 46 1 1942991184 12876560 6160336
18:00:40 38140 8192000000 10915464832 11357507584 1967202304 19.363 100 53 102 2 1989560896 7553184 14805408
18:01:28 213905 8192000000 10863969472 11346657280 1816646176 18.150 92 28 56 1 1838024432 13395040 7983216
18:05:10 44989 8192000000 10863473184 11344064512 1920616272 18.992 99 10 18 2 1940949888 18046736 2286880
18:06:01 2221 8192000000 10889935136 11350507520 1956091552 19.275 100 31 62 0 1976258496 10805008 9361936
18:06:12 5689 8192000000 10887176720 11352608768 1953298208 19.253 100 18 36 1 1971483360 13237328 4947824
18:06:26 45672 8192000000 10884181728 11347984384 1961012128 19.314 100 26 52 1 1978320208 9478240 7829840
18:07:23 51966 8192000000 10908500416 11366068224 1953488352 19.254 99 35 68 0 1981893184 18666400 9738432
18:08:22 35237 8192000000 10903757184 11367411712 1953219120 19.252 99 26 53 3 1975601312 14503456 7878736
18:09:06 44150 8192000000 10893869344 11369390080 1949020464 19.219 99 18 35 2 1972497904 17814304 5663136
18:10:15 36822 8192000000 10886193808 11367473152 1964194592 19.339 100 8 16 0 1980967632 14485424 2287616
18:10:59 26456 8192000000 10890547344 11376664576 1964337216 19.341 100 4 8 1 1986138448 20772832 1028400
18:11:33 22096 8192000000 10891537920 11367096320 1964729520 19.344 100 12 24 0 1979102560 11108064 3264976
18:12:01 19966 8192000000 10898171040 11379920896 1970829072 19.392 100 7 14 0 1983689840 10890160 1970608
18:12:28 29435 8192000000 10894105056 11366494208 1958555888 19.295 99 11 22 0 1976141840 13728816 3857136
18:15:38 35674 8192000000 10907454704 11375886336 1974911728 19.424 100 18 34 1 1988842912 8351792 5579392
18:16:29 32652 8192000000 10893345216 11364708352 1957237744 19.284 99 9 19 0 1968303504 8498288 2567472
18:17:09 26925 8192000000 10895415904 11368996864 1937438240 19.126 98 14 28 0 1952444272 11126992 3879040
18:17:48 53380 8192000000 10901868864 11380916224 1956034496 19.275 99 14 28 1 1969697648 9605232 4057920
18:18:52 40015 8192000000 10923572688 11388395520 1993153776 19.569 100 43 86 0 2016340560 10617456 12569328
18:19:40 107104 8192000000 10924894656 11393564672 1983524656 19.493 100 15 30 1 1999364736 11711888 4128192
18:21:34 52791 8192000000 10930775920 11408117760 1998938752 19.614 100 32 62 2 2021541040 13693312 8908976
18:22:34 72110 8192000000 10916858304 11396726784 1974072208 19.418 99 9 18 1 1990443024 13653120 2717696
18:23:52 54640 8192000000 10908125872 11374219264 1918119536 18.972 96 26 52 0 1937062176 12132688 6809952
18:25:01 56711 8192000000 10923947584 11404509184 1986339552 19.515 100 14 28 2 2004101760 13433552 4328656
18:26:23 89842 8192000000 10897811824 11373580288 1876314544 18.635 94 21 42 3 1892683664 10933360 5435760
18:28:00 69887 8192000000 10902518080 11369496576 1904839232 18.865 96 16 32 0 1918637632 9540432 4257968
18:29:27 76222 8192000000 10893120672 11368026112 1954518448 19.262 99 29 58 0 1970666992 8075072 8073472
18:30:53 59734 8192000000 10895217984 11353157632 1908236032 18.892 96 40 80 3 1926230912 7223440 10771440
18:32:10 6072 8192000000 10887592560 11348848640 1952690384 19.248 99 49 99 2 1976251088 9357104 14203600
18:32:23 16318 8192000000 10919649472 11356606464 1937802256 19.129 98 57 112 2 1964066672 9452448 16811968
18:32:46 56306 8192000000 10846953536 11325575168 1899778768 18.825 97 15 30 1 1912643552 8404304 4460480
18:34:40 54890 8192000000 10847275104 11312427008 1859769232 18.501 96 11 20 0 1869345088 6808992 2766864
18:35:43 65902 8192000000 10837223760 11316609024 1890129840 18.747 98 10 20 0 1905222272 11985088 3107344
18:37:50 23335 8192000000 10860904160 11320553472 1898051248 18.811 98 31 62 0 1915031760 7868816 9111696
18:38:23 62250 8192000000 10829334816 11313225728 1891363744 18.757 98 10 20 0 1904330000 10215296 2750960
18:39:32 26762 8192000000 10857417600 11334262784 1923597888 19.016 99 19 39 0 1939019296 10439488 4981920
18:40:06 28656 8192000000 10855148432 11343888384 1938467136 19.135 100 10 20 0 1955393872 13594208 3332528
18:40:40 32232 8192000000 10853012848 11308572672 1825598128 18.223 94 16 32 0 1836696240 6274224 4823888
18:41:22 14695 8192000000 10870389920 11328405504 1918661472 18.976 99 52 103 1 1944105408 9986832 15457104
18:41:43 42719 8192000000 10886640720 11352248320 1937813408 19.129 100 38 76 1 1965900224 17547248 10539568
18:42:32 24298 8192000000 10873915392 11346022400 1931149856 19.076 99 24 47 3 1951803888 13605440 7048592
18:43:22 51847 8192000000 10873143200 11341078528 1891949648 18.761 97 24 48 5 1911445152 12538832 6956672
18:44:36 104712 8192000000 10832986608 11309518848 1850942144 18.430 96 11 22 0 1871182528 16618592 3621792
18:46:27 58164 8192000000 10872341168 11330187264 1901543104 18.839 98 43 86 1 1924538768 10621920 12373744
18:47:32 82732 8192000000 10886517296 11335483392 1901602016 18.839 98 27 54 1 1918421552 9269200 7550336
18:49:03 18533 8192000000 10889984400 11342249984 1933690224 19.096 99 44 88 0 1956365440 10470976 12204240
18:49:36 35950 8192000000 10867495504 11330854912 1933708256 19.097 99 27 54 0 1953273936 12012800 7552880
18:50:25 22331 8192000000 10888868048 11340963840 1934107040 19.100 99 37 74 3 1956508640 11240048 11161552
18:50:54 76995 8192000000 10881672112 11350196224 1910472176 18.910 98 16 32 0 1927323760 12609392 4242192
18:52:17 141237 8192000000 10875444032 11346141184 1937780768 19.129 99 22 44 0 1954093040 10700256 5612016
18:54:45 43483 8192000000 10890249376 11344257024 1954447376 19.262 100 40 77 1 1972059408 7430160 10181872
18:55:35 43696 8192000000 10887654080 11366985728 1967051584 19.362 100 30 60 2 1983472352 8094320 8326448
18:56:28 54933 8192000000 10874380368 11361157120 1950287680 19.229 99 13 26 1 1962314128 8445552 3580896
18:57:34 61850 8192000000 10899502608 11389448192 1976962688 19.441 100 10 20 0 1994968176 15373728 2631760
18:58:59 64241 8192000000 10911260288 11382673408 1941485952 19.159 98 7 14 0 1960883616 17846624 1551040
19:00:18 68110 8192000000 10901508720 11376009216 1927026208 19.043 97 12 24 1 1950396896 19999120 3371568
19:01:55 27865 8192000000 10892423568 11360391168 1931446416 19.078 98 14 28 0 1942771952 7920864 3404672
19:02:37 41239 8192000000 10900943424 11375734784 1974267648 19.419 100 23 45 1 1988433344 8189808 5975888
19:03:33 45158 8192000000 10917424016 11389333504 1962147680 19.323 99 11 22 1 1976069184 10690448 3231056
19:04:24 37946 8192000000 10919708128 11377192960 1957095728 19.283 98 33 66 1 1976177312 9530368 9551216
19:05:08 33132 8192000000 10915808560 11377700864 1948274848 19.213 98 47 93 2 1973376448 11396192 13705408
19:05:55 21415 8192000000 10906809504 11371556864 1973284864 19.411 100 28 56 2 1998645248 16886416 8473968
19:06:32 99140 8192000000 10898497568 11353202688 1889407120 18.741 96 17 34 1 1905431488 11962368 4062000
19:08:21 32891 8192000000 10907814512 11367993344 1951888864 19.242 99 29 58 1 1971687744 11407648 8391232
19:09:02 62453 8192000000 10877363088 11362791424 1923092016 19.012 98 24 48 0 1943579408 13704992 6782400
19:10:21 91626 8192000000 10892170816 11363381248 1859864992 18.502 95 7 14 0 1879412944 17967344 1580608
19:12:10 26627 8192000000 10908401616 11370938368 1966551136 19.358 100 24 48 0 1981955008 8672752 6731120
19:12:48 30949 8192000000 10922520368 11373707264 1944258432 19.181 99 37 74 0 1964547264 10647712 9641120
19:13:27 58089 8192000000 10891333232 11358511104 1913080736 18.931 97 24 48 0 1935248880 15315904 6852240
19:14:32 104417 8192000000 10878697216 11352932352 1931245072 19.077 99 19 37 1 1952167904 14743536 6179296
19:16:23 88985 8192000000 10871408384 11337871360 1906156576 18.876 97 25 51 1 1922083072 9097120 6829376
19:18:06 43210 8192000000 10862237120 11349303296 1938001824 19.131 99 20 40 1 1952580784 8517344 6061616
19:19:00 60326 8192000000 10854771584 11331842048 1877995984 18.649 96 10 20 0 1887436320 7000112 2440224
19:20:07 41359 8192000000 10748257264 11214573568 1739383472 17.514 90 19 38 0 1753313984 8176912 5753600
19:20:54 27531 8192000000 10812085952 11285532672 1880920384 18.673 100 10 20 0 1897013344 13312608 2780352
19:21:34 58182 8192000000 10822390576 11298181120 1874226000 18.618 98 6 12 0 1882826064 7027584 1572480
19:23:00 65825 8192000000 10836640576 11320315904 1916979568 18.963 100 11 22 1 1929409936 9503712 2926656
19:24:14 60238 8192000000 10843773760 11314544640 1869682608 18.582 97 18 34 2 1885128080 10728832 4716640
19:25:23 23122 8192000000 10857856992 11323961344 1909986336 18.907 99 31 62 2 1933842016 15534016 8321664
19:26:07 32208 8192000000 10845026480 11302432768 1862815264 18.526 97 29 58 2 1879799536 8995712 7988560
19:26:46 39112 8192000000 9494336080 9811984384 642550320 7.273 34 12 24 0 650743232 4960784 3232128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 25-03-2021 19:28:48 to 25-03-2021 19:29:19.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 139 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 25-03-2021 19:29:20 to 25-03-2021 19:29:22.

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          244480
MON$OLDEST_ACTIVE               244481
MON$OLDEST_SNAPSHOT             244481
MON$NEXT_TRANSACTION            244481
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                       2017856
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:274: 
:275: mscs-test-161.budzdorov.ru    Thu Mar 25 19:27:28 2021
:276:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:277: 
:278: 
:279: mscs-test-161.budzdorov.ru    Thu Mar 25 19:27:28 2021
:280:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:281: 
:282: 
:283: mscs-test-161.budzdorov.ru    Thu Mar 25 19:27:30 2021
:284:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:285: 
--- end of diff output ---

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

25.03.21 19:29:23. 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-25 19:29:25 No severe PSQL-related problems occured
25.03.21 19:29:27. End of report.