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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17553072 kB
MemAvailable 31504704 kB
Buffers 0 kB
Cached 14101568 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-22 22:27:22
DTS_END                         2021-03-22 22:27:22.7430
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(141:26) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33174
TRN_ID                          242622
ATT_ID                          686
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: 9206.24 20338 1104749
customer order: creation 174.94 368 20993
customer order: refuse 14.78 372 1774
order to supplier: creation 46.79 1291 5615
order to supplier: removal 3.51 90288 421
invoice (draft): creation 46.18 3356 5541
invoice (draft): removal 50.64 812 6077
invoice accept: apply 42.22 18707 5066
invoice accept: cancel 46.53 745 5584
customer reserve: creation 3947.00 185 473640
customer reserve: removal 4535.88 55 544306
realization accept: apply 85.06 178 10207
realization accept: cancel 81.42 107 9770
payment from customer: creation 59.63 119 7155
payment from customer: removal 6.02 78 722
payment to supplier: creation 50.14 128 6017
payment to supplier: removal 3.26 83 391
service: total inventory turnovers 4.60 1065 552
service: total monetary turnovers 6.78 17 813
service: aggregate perf. data 0.84 17226 101
service: refresh index statistics 0.03 271577 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-03-2021 22:28:14 to 22-03-2021 22:28:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3500
TEST_TIME 2 2207
TEST_TIME 3 2568
TEST_TIME 4 3547
TEST_TIME 5 4471
TEST_TIME 6 4472
TEST_TIME 7 4460
TEST_TIME 8 4637
TEST_TIME 9 5051
TEST_TIME 10 5675
TEST_TIME 11 6216
TEST_TIME 12 6278
TEST_TIME 13 6656
TEST_TIME 14 6844
TEST_TIME 15 7073
TEST_TIME 16 7413
TEST_TIME 17 7575
TEST_TIME 18 7820
TEST_TIME 19 7951
TEST_TIME 20 8493
TEST_TIME 21 8470
TEST_TIME 22 8841
TEST_TIME 23 9537
TEST_TIME 24 10079
TEST_TIME 25 10052
TEST_TIME 26 10294
TEST_TIME 27 10284
TEST_TIME 28 10142
TEST_TIME 29 10079
TEST_TIME 30 9916
TEST_TIME 31 10008
TEST_TIME 32 9984
TEST_TIME 33 9812
TEST_TIME 34 9812
TEST_TIME 35 9784
TEST_TIME 36 9653
TEST_TIME 37 9645
TEST_TIME 38 9542
TEST_TIME 39 9436
TEST_TIME 40 9495
TEST_TIME 41 9657
TEST_TIME 42 9528
TEST_TIME 43 9715
TEST_TIME 44 9638
TEST_TIME 45 9639
TEST_TIME 46 9534
TEST_TIME 47 9621
TEST_TIME 48 9651
TEST_TIME 49 9708
TEST_TIME 50 9745
TEST_TIME 51 9759
TEST_TIME 52 9826
TEST_TIME 53 9851
TEST_TIME 54 9840
TEST_TIME 55 9919
TEST_TIME 56 9897
TEST_TIME 57 9861
TEST_TIME 58 9748
TEST_TIME 59 9746
TEST_TIME 60 9664
TEST_TIME 61 9600
TEST_TIME 62 9627
TEST_TIME 63 9516
TEST_TIME 64 9488
TEST_TIME 65 9472
TEST_TIME 66 9527
TEST_TIME 67 9501
TEST_TIME 68 9516
TEST_TIME 69 9537
TEST_TIME 70 9501
TEST_TIME 71 9481
TEST_TIME 72 9523
TEST_TIME 73 9559
TEST_TIME 74 9565
TEST_TIME 75 9584
TEST_TIME 76 9760
TEST_TIME 77 9695
TEST_TIME 78 9690
TEST_TIME 79 9600
TEST_TIME 80 9561
TEST_TIME 81 9495
TEST_TIME 82 9488
TEST_TIME 83 9408
TEST_TIME 84 9426
TEST_TIME 85 9416
TEST_TIME 86 9366
TEST_TIME 87 9359
TEST_TIME 88 9358
TEST_TIME 89 9367
TEST_TIME 90 9365
TEST_TIME 91 9347
TEST_TIME 92 9389
TEST_TIME 93 9423
TEST_TIME 94 9416
TEST_TIME 95 9436
TEST_TIME 96 9429
TEST_TIME 97 9430
TEST_TIME 98 9421
TEST_TIME 99 9443
TEST_TIME 100 9499
TEST_TIME 101 9536
TEST_TIME 102 9548
TEST_TIME 103 9466
TEST_TIME 104 9421
TEST_TIME 105 9379
TEST_TIME 106 9362
TEST_TIME 107 9336
TEST_TIME 108 9309
TEST_TIME 109 9269
TEST_TIME 110 9249
TEST_TIME 111 9245
TEST_TIME 112 9226
TEST_TIME 113 9192
TEST_TIME 114 9179
TEST_TIME 115 9213
TEST_TIME 116 9178
TEST_TIME 117 9223
TEST_TIME 118 9240
TEST_TIME 119 9265
TEST_TIME 120 9209

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-03-2021 22:28:18 to 22-03-2021 22:28:21.

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 1542508 1542508 0 0.00 0 23386 6 0 0
doc_list_biud 1542508 1542508 0 0.00 0 34902 25 0 0
sp_add_invoice_to_stock 5189 5066 123 2.37 28 189599 18707 0 123
sp_cancel_adding_invoice 5584 5584 0 0.00 4 52474 746 0 0
sp_cancel_client_order 1774 1774 0 0.00 4 16778 372 0 0
sp_cancel_customer_reserve 544306 544306 0 0.00 1 24519 55 0 0
sp_cancel_pay_from_customer 722 722 0 0.00 3 5531 79 0 0
sp_cancel_pay_to_supplier 391 391 0 0.00 2 5447 83 0 0
sp_cancel_supplier_invoice 6089 6077 12 0.19 1 12155 813 0 12
sp_cancel_supplier_order 421 421 0 0.00 10 885199 90288 0 0
sp_cancel_write_off 9770 9770 0 0.00 1 10744 108 0 0
sp_client_order 20993 20993 0 0.00 3 24840 369 0 0
sp_customer_reserve 473640 473640 0 0.00 0 94343 185 0 0
sp_fill_shopping_cart 32141 32141 0 0.00 1 28546 41 0 0
sp_fill_shopping_cart_clo_res 473631 473631 0 0.00 0 27704 17 0 0
sp_get_clo_for_invoice 5057 5057 0 0.00 0 29591 342 0 0
sp_kill_cost_storno 16467 16467 0 0.00 0 10740 51 0 0
sp_kill_qstorno_ret_qs2qd 1104880 1104880 0 0.00 0 24504 30 0 0
sp_kill_qty_storno 583196 583196 0 0.00 0 34901 65 0 0
sp_lock_selected_doc 21218 21218 0 0.00 0 7620 5 0 0
sp_make_cost_storno 28436 28436 0 0.00 0 23383 52 0 0
sp_multiply_rows_for_pdistr 28436 28436 0 0.00 0 8807 29 0 0
sp_multiply_rows_for_qdistr 20993 20993 0 0.00 0 17751 170 0 0
sp_pay_from_customer 7155 7155 0 0.00 4 29176 119 0 0
sp_pay_to_supplier 6017 6017 0 0.00 5 23393 129 0 0
sp_payment_common 13172 13172 0 0.00 2 29032 38 0 0
sp_qd_handle_on_cancel_clo 1774 1774 0 0.00 0 16761 328 0 0
sp_qd_handle_on_invoice_upd_sts 10641 10641 0 0.00 0 34900 295 0 0
sp_qd_handle_on_reserve_upd_sts 10207 10207 0 0.00 0 21511 56 0 0
sp_reserve_write_off 10207 10207 0 0.00 7 21536 179 0 0
sp_supplier_invoice 5541 5541 0 0.00 6 105703 3357 0 0
sp_supplier_order 5615 5615 0 0.00 5 38355 1291 0 0
srv_aggregate_perf_data 101 101 0 0.00 2591 240172 17226 0 0
srv_fill_mon_cache_memory 147 147 0 0.00 1472 150443 35445 0 0
srv_find_qd_qs_mism 1055718 1055718 0 0.00 0 12581 6 0 0
srv_make_invnt_saldo 552 552 0 0.00 38 50940 1066 0 0
srv_make_money_saldo 813 813 0 0.00 1 221 18 0 0
srv_recalc_idx_stat 4 4 0 0.00 195216 378407 271577 0 0
t$perf-abend:sp_add_invoice_to_stock 123 123 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5066 5066 0 0.00 0 8902 143 0 0
t$perf-norm:sp_cancel_adding_invoice 437 437 0 0.00 0 4341 87 0 0
t$perf-norm:sp_cancel_client_order 1774 1774 0 0.00 0 2599 13 0 0
t$perf-norm:sp_cancel_customer_reserve 717 717 0 0.00 0 5596 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 722 722 0 0.00 0 7401 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 391 391 0 0.00 0 2788 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 419 419 0 0.00 0 582 10 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 18794 1419 0 0
t$perf-norm:sp_cancel_write_off 1073 1073 0 0.00 0 1426 6 0 0
t$perf-norm:sp_client_order 20993 20993 0 0.00 0 8532 15 0 0
t$perf-norm:sp_customer_reserve 973 973 0 0.00 0 15580 29 0 0
t$perf-norm:sp_pay_from_customer 7155 7155 0 0.00 0 5742 9 0 0
t$perf-norm:sp_pay_to_supplier 6017 6017 0 0.00 0 7566 10 0 0
t$perf-norm:sp_reserve_write_off 10207 10207 0 0.00 0 8854 13 0 0
t$perf-norm:sp_supplier_invoice 5541 5541 0 0.00 0 5916 17 0 0
t$perf-norm:sp_supplier_order 5615 5615 0 0.00 0 6480 15 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 204 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 147 147 0 0.00 0 449 4 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 2248 24 0 0
t$perf-norm:srv_make_money_saldo 813 813 0 0.00 0 1390 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10360 10114 246 2.37 0 10392 21 0 246
v_all_customers 38054 38054 0 0.00 0 24 1 0 0
v_all_suppliers 31174 31174 0 0.00 0 23 1 0 0
v_all_wares 41986 41986 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 874 874 0 0.00 0 213 5 0 0
v_cancel_client_order 3548 3548 0 0.00 0 10418 9 0 0
v_cancel_customer_prepayment 1444 1444 0 0.00 0 3978 11 0 0
v_cancel_customer_reserve 1434 1434 0 0.00 0 625 3 0 0
v_cancel_payment_to_supplier 782 782 0 0.00 0 2924 7 0 0
v_cancel_supplier_invoice 862 838 24 2.78 0 10173 29 0 24
v_cancel_supplier_order 842 842 0 0.00 0 10394 18 0 0
v_cancel_write_off 2146 2146 0 0.00 0 9550 20 0 0
v_max_id_clo_ord 5615 5615 0 0.00 0 376 1 0 0
v_max_id_clo_res 973 973 0 0.00 0 3369 11 0 0
v_max_id_ord_sup 5533 5533 0 0.00 0 3251 3 0 0
v_max_non_paid_invoice 1578 1578 0 0.00 0 1994 5 0 0
v_max_non_paid_realizn 3919 3919 0 0.00 0 1919 4 0 0
v_min_id_clo_ord 5615 5615 0 0.00 0 11280 7 0 0
v_min_id_clo_res 973 973 0 0.00 0 18078 46 0 0
v_min_id_ord_sup 5533 5533 0 0.00 0 14414 8 0 0
v_min_non_paid_invoice 6017 6017 0 0.00 0 16406 24 0 0
v_min_non_paid_realizn 7155 7155 0 0.00 0 29009 27 0 0
v_our_firm 10404 10404 0 0.00 0 14 1 0 0
v_reserve_write_off 20414 20414 0 0.00 0 11585 8 0 0
x_lock_depdocs_on_canc_invoice 11242 11242 0 0.00 0 10411 102 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 15386 348 0 0
x_make_qstorno_1000_1200 5615 5615 0 0.00 1 38234 1221 0 0
x_make_qstorno_1200_2000 5541 5541 0 0.00 3 103292 3193 0 0
x_make_qstorno_2100_3300 473640 473640 0 0.00 0 94339 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-03-2021 22:28:22 to 22-03-2021 22:28:26.

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
19:57:26 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:32 19270 8192000000 10237428688 10546962432 862519536 9.525 67 55 110 0 883826032 2588320 18718176
19:58:00 32849 8192000000 10356603200 10676019200 1406323856 14.651 100 87 174 0 1439701824 4970416 28407552
19:58:45 14060 8192000000 10374989728 10700369920 1432719952 14.885 100 83 166 0 1466948080 6965360 27262768
19:59:08 21368 8192000000 10403617776 10731315200 1456656032 15.096 100 91 182 0 1494925568 7754336 30515200
19:59:43 18239 8192000000 10430189712 10760863744 1487049152 15.363 100 91 182 2 1525318112 8674688 29594272
20:00:12 8447 8192000000 10441600064 10777014272 1498461120 15.463 100 86 172 1 1535233472 9220880 27551472
20:00:36 21583 8192000000 10457850544 10795806720 1510164816 15.565 100 85 169 1 1547405216 9946944 27293456
20:01:06 17014 8192000000 10480656064 10819706880 1528187600 15.721 100 84 168 1 1565304480 10019808 27097072
20:01:34 20086 8192000000 10495851024 10842251264 1555571824 15.958 100 87 174 0 1593686272 10733040 27381408
20:02:05 16974 8192000000 10518182976 10871603200 1576902864 16.142 100 81 162 0 1612042144 9992144 25147136
20:02:35 9216 8192000000 10538798880 10893369344 1603271952 16.367 100 84 168 0 1639436768 10100512 26064304
20:02:58 14322 8192000000 10570077952 10929741824 1625851888 16.560 100 78 157 0 1660078400 10536320 23690192
20:03:24 13801 8192000000 10591919312 10953789440 1650074720 16.765 100 72 142 2 1681892496 11033696 20784080
20:03:46 14168 8192000000 10612856400 10978820096 1666774016 16.906 100 81 162 2 1702534672 11903936 23856720
20:04:09 5962 8192000000 10635413616 11003465728 1692640736 17.123 100 83 166 2 1729162416 12804432 23717248
20:04:22 6914 8192000000 10649755696 11018338304 1702950736 17.210 100 82 163 0 1739416400 12882224 23583440
20:04:37 4697 8192000000 10652727168 11019948032 1711976528 17.285 100 86 171 1 1750785936 13752096 25057312
20:04:49 6328 8192000000 10668834928 11038306304 1720419440 17.356 100 86 172 0 1759680048 14467808 24792800
20:05:05 6556 8192000000 10682294752 11053252608 1736353296 17.488 100 92 183 2 1777288112 14978224 25956592
20:05:19 5071 8192000000 10697048816 11072630784 1752652016 17.624 100 84 166 3 1789498224 13161360 23684848
20:05:32 3310 8192000000 10696852256 11076624384 1763245616 17.711 100 88 171 3 1800472144 12900368 24326160
20:05:42 3781 8192000000 10711610784 11089199104 1771550160 17.780 100 84 168 0 1808036688 12530464 23956064
20:05:53 4052 8192000000 10720611968 11103518720 1781349232 17.861 100 67 134 1 1811335856 11033200 18953424
20:06:04 4122 8192000000 10735880560 11119009792 1797405504 17.993 100 79 159 2 1832016864 12645696 21965664
20:06:15 3575 8192000000 10748059472 11128852480 1805557744 18.059 100 86 173 1 1842761392 13070368 24133280
20:06:26 3810 8192000000 10753892544 11133227008 1809403824 18.091 100 84 169 1 1845685968 13528272 22753872
20:06:37 3172 8192000000 10762005888 11144101888 1817580640 18.158 100 87 174 2 1856503680 14602448 24320592
20:06:47 2435 8192000000 10768048128 11151491072 1826500832 18.231 100 93 184 1 1867543040 15270512 25771696
20:06:56 3042 8192000000 10775032448 11157737472 1828232544 18.245 100 89 178 0 1868678208 15990016 24455648
20:07:07 4632 8192000000 10762870432 11151695872 1828529072 18.247 100 79 158 0 1865190704 14851072 21810560
20:07:18 4558 8192000000 10773372224 11161079808 1832634576 18.281 100 83 164 2 1869782624 14388080 22759968
20:07:30 2075 8192000000 10790685152 11177656320 1847606144 18.403 100 92 186 1 1886529600 13266704 25656752
20:07:39 2935 8192000000 10801353360 11190149120 1854945376 18.462 100 90 178 3 1893557568 12952592 25659600
20:07:49 2026 8192000000 10804110592 11194359808 1865679040 18.549 100 90 180 0 1903203200 12857760 24666400
20:07:57 2904 8192000000 10816861104 11208237056 1871128016 18.593 100 84 166 1 1907553552 13052528 23373008
20:08:06 2764 8192000000 10823844544 11213713408 1873876560 18.616 100 93 185 1 1913280816 13115584 26288672
20:08:16 1608 8192000000 10820072160 11210035200 1879099824 18.658 100 92 177 2 1918478352 14104544 25273984
20:08:24 943 8192000000 10822680352 11216461824 1879987920 18.665 100 89 175 4 1917461088 13196944 24276224
20:08:31 1233 8192000000 10830575552 11220189184 1884359424 18.700 100 90 176 0 1923353296 12624256 26369616
20:08:39 1725 8192000000 10830049184 11222183936 1886422560 18.717 100 86 170 0 1921928928 12113392 23392976
20:08:47 5831 8192000000 10807127664 11222659072 1887910416 18.729 100 89 177 1 1926446816 13749616 24786784
20:09:06 30595 8192000000 10835431312 11229675520 1890163264 18.747 100 71 135 2 1917240352 7992096 19084992
20:09:44 1144 8192000000 10840554512 11234811904 1896236144 18.796 100 96 190 2 1934959728 11690480 27033104
20:09:51 17754 8192000000 10808574544 11228516352 1888712368 18.735 100 53 106 2 1914065648 9985616 15367664
20:10:16 12971 8192000000 10788322720 11222827008 1887883248 18.729 100 34 68 1 1904425648 6206400 10336000
20:10:35 8128 8192000000 10789594688 11224035328 1886305104 18.716 100 19 38 1 1896657968 5263648 5089216
20:10:51 7688 8192000000 10789749024 11226189824 1887814736 18.728 100 23 46 1 1900732752 6335952 6582064
20:11:06 7940 8192000000 10807009648 11235491840 1890969952 18.754 100 27 53 3 1904540896 6723056 6847888
20:11:20 12727 8192000000 10796752624 11233484800 1893264032 18.772 100 21 43 0 1906303296 7394480 5644784
20:11:40 9593 8192000000 10807527568 11238879232 1896491984 18.798 100 22 44 2 1909072144 5241344 7338816
20:12:00 10715 8192000000 10801615920 11237064704 1897309216 18.805 100 28 54 0 1912047424 6714576 8023632
20:12:17 7670 8192000000 10814955728 11243462656 1899399984 18.821 100 31 62 1 1915033552 6777808 8855760
20:12:33 6291 8192000000 10810490192 11246444544 1901251808 18.836 100 19 36 2 1912939776 6308272 5379696
20:12:46 9795 8192000000 10800237264 11242737664 1901648688 18.840 100 20 40 1 1913968448 6850656 5469104
20:13:04 7971 8192000000 10798000992 11244290048 1902700800 18.848 100 20 40 4 1914115376 5526800 5887776
20:13:18 7488 8192000000 10812437216 11246546944 1903554528 18.855 100 23 46 0 1917105280 7232928 6317824
20:13:34 10323 8192000000 10815685440 11246424064 1903569824 18.855 100 17 33 1 1913903728 5234512 5099392
20:13:54 10843 8192000000 10813493168 11248058368 1904789184 18.865 100 22 42 3 1917431120 6189872 6452064
20:14:11 53571 8192000000 10827854480 11257454592 1910212432 18.908 100 30 60 1 1924502800 5574464 8715904
20:15:15 21791 8192000000 10827043376 11263434752 1909867056 18.906 100 21 39 2 1920793344 5275248 5651040
20:15:42 5412 8192000000 10824381648 11262717952 1914351120 18.942 100 30 60 2 1928932768 6200512 8381136
20:15:56 4631 8192000000 10842548624 11271254016 1915513216 18.951 100 27 54 1 1929596528 6410480 7672832
20:16:09 4374 8192000000 10837947392 11272073216 1917096160 18.964 100 36 73 2 1934731120 7587408 10047552
20:16:21 5426 8192000000 10837640272 11271770112 1917598176 18.968 100 26 52 1 1931767536 6876944 7292416
20:16:32 7717 8192000000 10839503200 11275235328 1920084512 18.988 100 29 58 2 1935006928 6456752 8465664
20:16:47 8251 8192000000 10820403152 11256918016 1880108096 18.666 98 19 38 1 1891041312 5463568 5469648
20:17:03 5169 8192000000 10812414320 11240828928 1889781456 18.744 99 30 60 2 1904619552 6144560 8693536
20:17:18 7324 8192000000 10801112160 11224887296 1844699008 18.379 97 21 41 1 1856145744 5333200 6113536
20:17:39 7549 8192000000 10782639680 11211747328 1856540992 18.475 99 23 46 0 1868391312 5284880 6565440
20:17:53 6801 8192000000 10775570672 11205345280 1835861008 18.307 98 16 33 0 1845639216 5568752 4209456
20:18:06 6150 8192000000 10781248752 11201359872 1829670512 18.257 98 41 82 2 1847972592 5476736 12825344
20:18:20 7295 8192000000 10735253760 11164495872 1756341584 17.654 95 15 31 1 1766007600 4922592 4743424
20:18:36 8132 8192000000 10725353728 11149459456 1756374624 17.654 96 21 41 3 1767515280 5422816 5717840
20:18:53 55173 8192000000 10719963024 11127046144 1744275152 17.554 96 45 90 1 1763338544 5461968 13601424
20:19:55 9278 8192000000 10727336848 11146936320 1788549936 17.920 98 33 66 2 1806118800 7808880 9759984
20:20:12 5702 8192000000 10749468944 11161739264 1803452528 18.042 99 46 92 0 1828003552 11584304 12966720
20:20:27 6312 8192000000 10719905984 11138949120 1779784496 17.848 98 30 60 2 1799535856 11045872 8705488
20:20:39 6053 8192000000 10701162304 11112935424 1730965200 17.444 96 29 58 0 1745260480 6330512 7964768
20:20:53 7415 8192000000 10701434688 11126587392 1753218768 17.628 97 25 50 2 1769960736 9537456 7204512
20:21:07 9024 8192000000 10693775952 11117973504 1777506640 17.829 99 29 58 1 1792006576 6287872 8212064
20:21:23 6737 8192000000 10706054016 11124785152 1772588320 17.788 99 24 49 2 1785118064 5793888 6735856
20:21:36 9886 8192000000 10700452448 11105345536 1703283632 17.213 95 28 57 0 1717066176 5009984 8772560
20:21:54 7367 8192000000 10715550816 11126607872 1755102176 17.644 97 39 80 2 1772542896 5880080 11560640
20:22:11 10097 8192000000 10724701760 11145928704 1810815072 18.103 100 32 64 2 1826546768 5899104 9832592
20:22:29 5251 8192000000 10737311728 11152498688 1817318656 18.156 100 40 80 2 1835355104 5933072 12103376
20:22:42 8588 8192000000 10746944416 11160530944 1805072240 18.056 99 29 58 4 1819541840 5470336 8999264
20:23:00 55446 8192000000 10753547456 11170193408 1834091632 18.293 100 40 79 1 1850997264 5645696 11259936
20:24:01 14725 8192000000 10745573568 11176652800 1836901344 18.316 100 14 27 1 1846177680 5420688 3855648
20:24:23 8034 8192000000 10754419360 11177017344 1826888048 18.234 99 31 62 2 1841710176 6170208 8651920
20:24:38 6815 8192000000 10752332192 11182211072 1841489744 18.353 100 23 42 0 1853221680 5993168 5738768
20:24:51 8724 8192000000 10759641200 11189235712 1848744944 18.412 100 20 40 1 1859562016 5233360 5583712
20:25:06 6710 8192000000 10770815568 11198410752 1858121456 18.488 100 32 64 0 1874205856 6884816 9199584
20:25:22 10641 8192000000 10773344272 11201720320 1865011264 18.544 100 34 68 4 1880849504 5806832 10031408
20:25:39 8239 8192000000 10768320016 11203674112 1864212000 18.537 100 25 50 0 1876826352 5508512 7105840
20:25:54 8337 8192000000 10768457648 11207385088 1866963712 18.560 100 26 53 2 1881165072 6441488 7759872
20:26:08 7742 8192000000 10791232240 11218972672 1874806528 18.623 100 18 36 1 1886035552 6153168 5075856
20:26:24 5713 8192000000 10787434960 11215515648 1873612368 18.613 100 26 52 0 1887263344 6443280 7207696
20:26:36 7616 8192000000 10786179200 11216375808 1875509056 18.629 100 21 42 0 1886581200 5076640 5995504
20:26:50 8126 8192000000 10790299888 11222601728 1876472560 18.637 100 17 34 4 1887672592 6513488 4686544
20:27:06 15590 8192000000 10811143520 11240157184 1891099840 18.755 100 21 42 0 1902220224 5188032 5932352
20:27:30 7719 8192000000 10836555696 11252908032 1900767056 18.832 100 28 56 0 1918810800 8864928 9178816
20:27:45 38135 8192000000 10838689568 11261931520 1914340416 18.941 100 31 62 1 1928944480 6092400 8511664
20:28:32 150443 8192000000 10854029680 11292631040 1929897968 19.066 100 40 80 2 1951665728 10361232 11406528
20:31:12 49860 8192000000 10878370288 11304366080 1944179200 19.180 100 30 60 3 1963392080 10352784 8860096
20:32:11 12719 8192000000 10881185088 11314475008 1953586416 19.255 100 49 98 1 1981635024 13497936 14550672
20:32:30 13327 8192000000 10910543632 11333636096 1957880976 19.289 100 53 105 2 1990047152 16709728 15456448
20:32:52 9093 8192000000 10899687024 11332354048 1962718272 19.328 100 47 92 2 1990118528 13823712 13576544
20:33:10 28653 8192000000 10893238144 11331981312 1961458960 19.318 100 32 64 1 1986727696 15698400 9570336
20:33:56 23897 8192000000 10908969120 11338252288 1972887600 19.408 100 40 79 1 1996202592 11598576 11716416
20:34:35 6638 8192000000 10918895408 11350536192 1979819312 19.463 100 48 96 1 2007259936 13299408 14141216
20:34:55 5099 8192000000 10932598560 11357736960 1985643056 19.509 100 64 126 0 2019080656 14818864 18618736
20:35:15 5558 8192000000 10923412032 11356221440 1989441184 19.539 100 55 110 1 2020765024 14601312 16722528
20:35:29 3513 8192000000 10935389824 11362881536 1991342048 19.554 100 53 106 1 2022721152 15680448 15698656
20:35:45 8008 8192000000 10936633696 11366883328 1993459808 19.571 100 58 115 0 2027697648 17150416 17087424
20:36:00 3562 8192000000 10942627344 11369455616 1995111328 19.584 100 65 127 1 2031907072 17588144 19207600
20:36:12 3759 8192000000 10953055296 11379843072 1999125424 19.616 100 80 160 3 2042955168 19360720 24469024
20:36:27 12462 8192000000 10947478560 11379077120 1998244432 19.609 100 55 109 1 2032935248 17912672 16778144
20:36:48 4021 8192000000 10955116832 11383455744 2003461040 19.650 100 68 136 0 2043447952 19923392 20063520
20:37:05 3318 8192000000 10944693376 11383119872 2002099504 19.639 100 54 108 0 2039325136 21177280 16048352
20:37:18 12837 8192000000 10959719328 11390570496 2010372432 19.704 100 75 148 1 2053731216 20501200 22857584
20:37:40 8142 8192000000 10963412464 11400966144 2013253568 19.727 100 62 124 1 2056211376 24135376 18822432
20:38:13 2634 8192000000 10958868112 11387637760 1998288976 19.609 99 67 134 1 2043073392 24386288 20398128
20:38:26 8121 8192000000 10970050624 11406184448 2018212048 19.766 100 65 127 2 2059823248 22654816 18956384
20:38:42 1961 8192000000 10987700848 11403218944 2005007808 19.662 99 78 157 1 2051084032 23391680 22684544
20:38:52 2806 8192000000 10978517904 11404181504 2022520512 19.800 100 82 164 2 2067369584 21304720 23544352
20:39:01 2191 8192000000 10985125840 11408850944 2024928000 19.819 100 68 136 0 2066972944 21967072 20077872
20:39:11 5253 8192000000 10975327232 11402395648 2004821472 19.661 99 80 158 0 2051635792 23435024 23379296
20:39:23 3435 8192000000 10965649776 11397054464 2012028432 19.717 100 73 145 0 2057702752 23714000 21960320
20:39:38 2716 8192000000 10969938400 11391905792 2005866432 19.669 100 75 146 1 2051435184 23988912 21579840
20:39:50 9664 8192000000 10970266304 11391270912 2003942224 19.654 100 72 144 2 2051873328 26497280 21433824
20:40:09 8276 8192000000 10965070720 11395739648 2003986000 19.654 100 68 136 0 2054308032 29241616 21080416
20:40:31 5082 8192000000 10967683856 11406622720 2009862416 19.700 100 58 116 2 2060075808 31071008 19142384
20:40:52 8534 8192000000 10956423152 11390300160 1997461584 19.603 100 61 120 1 2043159376 26380480 19317312
20:41:09 7210 8192000000 10947138496 11385548800 1975553648 19.429 98 59 119 0 2019231920 25627792 18050480
20:41:26 4093 8192000000 10972255264 11399274496 2011303456 19.712 100 71 142 0 2058174240 24878688 21992096
20:41:40 7656 8192000000 10959117904 11395579904 2008626368 19.691 100 62 124 1 2053292800 25786288 18880144
20:42:02 3898 8192000000 10979691200 11394723840 2001221904 19.632 100 76 152 1 2053098176 27935536 23940736
20:42:13 4777 8192000000 10974114480 11393261568 2007004688 19.678 100 87 174 2 2062407328 29105824 26296816
20:42:24 1467 8192000000 10981997776 11402838016 2010145168 19.703 100 89 177 1 2066330096 29981728 26203200
20:42:32 2545 8192000000 10990096960 11408506880 2014053312 19.733 100 88 176 2 2071575328 30616048 26905968
20:42:42 1619 8192000000 10979562080 11397754880 2007404016 19.681 100 84 168 1 2062849616 29770496 25675104
20:42:51 3606 8192000000 10972806736 11388477440 1984766640 19.502 99 86 171 2 2041707408 30936352 26004416
20:43:05 3505 8192000000 10973035808 11387310080 1994438656 19.579 100 84 168 0 2053081936 32409024 26234256
20:43:15 3814 8192000000 10966156608 11379527680 1982628688 19.486 99 88 176 2 2043515552 33844400 27042464
20:43:26 3246 8192000000 10964765648 11377369088 1978319200 19.451 99 89 178 1 2039436160 33799440 27317520
20:43:39 2223 8192000000 10949557776 11367301120 1973716352 19.415 100 82 164 2 2033676720 34792256 25168112
20:43:48 5192 8192000000 10933324384 11361951744 1954426400 19.262 99 66 132 2 2007218192 31720496 21071296
20:44:00 3837 8192000000 10935735024 11363418112 1971836032 19.400 100 66 132 0 2024536032 30917584 21782416
20:44:12 3908 8192000000 10948664800 11367051264 1957908176 19.289 99 73 146 4 2012608128 32540224 22159728
20:44:23 1620 8192000000 10944169088 11358347264 1965037632 19.346 100 81 162 0 2020488832 30502048 24949152
20:44:32 3411 8192000000 10937643904 11359375360 1970258544 19.387 100 72 143 0 2024990224 32397888 22333792
20:44:53 3023 8192000000 10925037776 11351322624 1960209792 19.308 100 66 130 2 2013231472 32875072 20146608
20:45:09 18425 8192000000 10903914560 11335200768 1931475616 19.079 99 48 96 2 1985283488 37762480 16045392
20:45:43 9997 8192000000 10895134368 11332927488 1919092672 18.980 99 44 88 1 1970990240 37523952 14373616
20:46:21 16283 8192000000 10925221216 11355230208 1949441328 19.222 100 55 110 1 2008654784 40304112 18909344
20:46:44 2383 8192000000 10932005024 11351089152 1954545712 19.263 100 71 143 1 2010435952 33922912 21967328
20:46:53 8478 8192000000 10918056432 11348877312 1941884496 19.162 99 57 113 1 1995268224 35234032 18149696
20:47:11 12725 8192000000 10902989472 11337990144 1918683632 18.976 98 52 104 0 1973591392 37457104 17450656
20:47:35 9922 8192000000 10912416752 11350609920 1951069200 19.235 100 48 93 3 2003556432 36882928 15604304
20:47:52 15221 8192000000 10903030192 11349803008 1951139056 19.236 100 31 62 1 1994748896 33493520 10116320
20:48:15 15249 8192000000 10896942528 11335413760 1921784112 19.001 99 31 62 1 1966569536 33443232 11342192
20:48:36 15384 8192000000 10889130160 11336171520 1915171600 18.948 99 35 70 2 1963706208 35482208 13052400
20:48:58 26591 8192000000 10890815712 11344375808 1919700736 18.984 99 31 62 2 1969876992 39048288 11127968
20:49:34 12183 8192000000 10902214128 11345100800 1932192336 19.084 100 29 58 3 1980380352 37697456 10490560
20:50:08 22920 8192000000 10877692448 11322888192 1887040736 18.722 98 25 50 2 1931477984 35281072 9156176
20:50:37 23136 8192000000 10852573584 11307032576 1844622432 18.378 96 20 40 1 1884359168 32674720 7062016
20:51:37 18578 8192000000 10860756512 11319386112 1899661136 18.824 99 13 26 3 1941666672 37688416 4317120
20:52:07 32760 8192000000 10850869600 11288432640 1883122080 18.690 98 30 60 0 1908446304 16608928 8715296
20:52:47 10421 8192000000 10865566864 11306647552 1921641296 19.000 100 45 90 1 1954935072 19913664 13380112
20:53:08 18559 8192000000 10845825760 11315900416 1905123440 18.867 99 14 28 1 1932483568 23094048 4266080
20:53:33 44118 8192000000 10821316928 11274096640 1833899808 18.291 96 15 31 0 1854477680 15780464 4797408
20:54:35 58367 8192000000 10820557440 11276455936 1893293104 18.772 99 38 75 4 1915291152 8708752 13289296
20:56:10 65724 8192000000 10844168816 11296485376 1886289728 18.716 98 40 79 2 1905395760 8180320 10925712
20:57:52 77815 8192000000 10894862656 11338395648 1930998320 19.075 99 28 56 1 1953064832 14506000 7560512
20:59:16 89998 8192000000 10900486816 11324993536 1879086240 18.658 96 46 91 2 1902514416 10183216 13244960
21:00:52 21078 8192000000 10868120896 11330482176 1951341712 19.237 100 44 88 0 1973472768 10068640 12062416
21:01:21 62792 8192000000 10870081536 11342925824 1947078144 19.203 99 27 54 0 1965092976 9776576 8238256
21:03:12 49627 8192000000 10906136368 11370311680 1976830640 19.440 100 30 61 0 1998959184 13224064 8904480
21:04:39 62716 8192000000 10914321888 11373019136 1966963856 19.361 99 17 35 0 1987295920 15150128 5181936
21:05:48 60745 8192000000 10911088960 11373727744 1962978288 19.330 99 14 28 1 1983037440 15339984 4719168
21:06:55 31384 8192000000 10901706128 11376721920 1975324096 19.428 100 11 22 0 1995377936 16178960 3874880
21:07:40 40606 8192000000 10913596624 11392020480 1981928944 19.480 100 19 38 0 2008846480 20625136 6292400
21:08:37 60712 8192000000 10895865136 11364769792 1940835104 19.153 98 29 59 1 1963985728 13953760 9196864
21:09:45 58642 8192000000 10888251680 11371286528 1977162432 19.442 100 27 54 2 1998601136 13903264 7535440
21:10:54 68266 8192000000 10892108912 11343691776 1919580432 18.983 97 18 36 1 1932267024 7895536 4791056
21:12:15 46695 8192000000 10895911728 11361566720 1951739120 19.240 99 16 31 1 1966010976 9500752 4771104
21:13:33 65949 8192000000 10903061776 11382472704 1980377072 19.468 100 18 36 0 1999459456 14392720 4689664
21:14:45 40017 8192000000 10940046336 11393781760 1982528416 19.485 100 24 48 1 2003247744 13538176 7181152
21:15:32 42491 8192000000 10925049856 11405070336 1995334656 19.586 100 33 66 1 2028370512 24041552 8994304
21:16:32 71435 8192000000 10930353056 11401019392 1993735280 19.573 100 26 52 0 2018338080 17567168 7035632
21:17:50 13106 8192000000 10929815440 11370971136 1981241168 19.475 99 36 70 1 1999246864 8371504 9634192
21:18:13 35633 8192000000 10930724736 11398795264 2005020160 19.662 100 41 83 1 2030321248 13567152 11733936
21:19:01 55701 8192000000 10920846336 11395772416 1991784192 19.558 100 27 54 1 2012417136 13358896 7274048
21:21:05 45786 8192000000 10925247904 11391037440 1964279968 19.340 98 13 26 1 1979056448 11282816 3493664
21:22:02 50236 8192000000 10933248160 11395096576 1957327904 19.285 98 22 44 1 1979023120 15453504 6241712
21:22:59 122942 8192000000 10929332336 11411742720 1957416208 19.285 98 14 28 3 1976531136 15016256 4098672
21:25:38 89128 8192000000 10892891280 11378237440 1932083440 19.084 97 16 32 0 1949829344 12697632 5048272
21:28:00 43977 8192000000 10875794928 11340795904 1907699888 18.888 96 22 44 1 1923169088 9465424 6003776
21:28:58 44218 8192000000 10875925760 11360514048 1943001664 19.171 99 9 18 0 1955319424 10312512 2005248
21:29:49 29616 8192000000 10877040048 11359326208 1960718272 19.312 100 6 12 0 1972493456 10484208 1290976
21:30:46 43488 8192000000 10861765520 11330891776 1914334240 18.941 97 6 12 0 1925541600 9679056 1528304
21:31:42 118010 8192000000 10843460864 11319717888 1842581376 18.362 94 14 28 0 1856167904 9919536 3666992
21:33:46 50931 8192000000 10879228224 11335860224 1874404672 18.620 96 17 36 1 1889309104 10257152 4647280
21:34:51 44056 8192000000 10901988512 11362312192 1958145776 19.291 100 42 84 0 1979795632 10381056 11268800
21:35:52 26697 8192000000 10872577968 11345993728 1934340080 19.102 99 28 55 0 1950227552 7831696 8055776
21:36:29 48180 8192000000 10862766128 11326984192 1835709408 18.306 94 15 30 0 1846467072 6727200 4030464
21:37:32 52151 8192000000 10845134384 11304927232 1816397408 18.148 94 19 38 0 1834533616 12618032 5518176
21:38:43 53759 8192000000 10847762848 11303047168 1887765424 18.728 98 20 39 0 1904871024 11983232 5122368
21:39:51 52045 8192000000 10816758240 11264827392 1754781488 17.641 91 38 76 0 1777155312 11760864 10612960
21:40:57 34161 8192000000 10831435984 11283697664 1872885696 18.608 99 26 53 0 1893951904 13847184 7219024
21:42:02 54458 8192000000 10854637040 11313745920 1898728864 18.816 100 25 50 2 1926064432 20694224 6641344
21:43:12 53012 8192000000 10842142928 11314470912 1868130640 18.569 98 8 16 0 1890313328 19745264 2437424
21:44:11 66587 8192000000 10879292624 11331346432 1901102608 18.835 99 18 36 0 1917197568 11190608 4904352
21:45:24 20741 8192000000 10898380912 11339550720 1933899312 19.098 100 45 90 2 1963740288 17336832 12504144
21:45:52 31873 8192000000 10888461776 11339182080 1938216304 19.133 100 48 96 1 1967293920 15706080 13371536
21:46:31 99784 8192000000 10871184560 11325317120 1925116304 19.028 99 38 76 0 1945977712 9713840 11147568
21:48:26 26089 8192000000 10881852016 11338309632 1949131760 19.220 100 43 86 0 1970984432 9723408 12129264
21:48:58 85351 8192000000 10860204960 11339407360 1928245520 19.053 99 14 28 0 1942377792 10042192 4090080
21:50:29 49622 8192000000 10869047328 11342028800 1948711040 19.216 100 14 26 0 1964009760 10979456 4319264
21:51:25 47705 8192000000 10854648048 11336957952 1927830928 19.050 99 11 21 0 1940589472 9728784 3029760
21:52:19 42130 8192000000 10852886688 11330363392 1902105648 18.843 98 8 16 1 1911554080 7098672 2349760
21:53:11 86053 8192000000 10878981168 11353845760 1931149776 19.076 99 24 48 0 1949460000 11217664 7092560
21:55:29 55508 8192000000 10867895600 11347828736 1931603824 19.080 99 20 41 0 1947032944 9205776 6223344
21:56:31 40586 8192000000 10871178976 11336851456 1899245344 18.820 97 16 32 0 1910708768 7200240 4263184
21:57:18 32050 8192000000 10885362336 11353071616 1936276624 19.117 99 21 42 0 1950652352 8786464 5589264
21:58:02 42243 8192000000 10930263632 11383726080 1974318800 19.420 100 24 48 1 1989700080 8520144 6861136
21:59:49 70084 8192000000 10911054096 11390255104 1965653024 19.351 99 11 22 0 1982082640 13300224 3129392
22:01:11 42210 8192000000 10912645456 11377606656 1950951520 19.234 98 25 49 2 1965339952 7583264 6805168
22:02:06 89341 8192000000 10924464944 11383578624 1968545232 19.374 99 26 52 1 1985861584 9756448 7559904
22:03:43 41921 8192000000 10920674384 11386773504 1973004208 19.409 99 40 80 0 1995348736 11606832 10737696
22:04:35 51488 8192000000 10935508080 11401318400 1993804976 19.574 100 28 56 0 2015154208 13711648 7637584
22:05:33 48561 8192000000 10943491648 11409264640 1999196368 19.616 100 41 80 1 2026322512 16007168 11118976
22:06:41 116020 8192000000 10904243424 11380531200 1909597024 18.903 96 16 32 1 1929196720 15078544 4521152
22:08:45 85763 8192000000 10897676224 11380363264 1880303488 18.668 95 4 8 0 1894663088 13231392 1128208
22:11:22 87209 8192000000 10881710608 11367084032 1941491536 19.159 98 16 31 2 1954187360 8745872 3949952
22:13:04 50247 8192000000 10897109264 11369590784 1956027168 19.274 99 11 22 1 1966231632 7177760 3026704
22:14:00 80399 8192000000 10871344896 11356254208 1912721792 18.928 97 6 12 0 1921179824 6904800 1553232
22:15:31 62235 8192000000 10882258656 11345379328 1908792368 18.897 97 7 14 1 1917118512 6445760 1880384
22:16:57 61460 8192000000 10870863728 11354431488 1944830240 19.185 99 9 18 0 1957589664 10176512 2582912
22:18:10 47763 8192000000 10859096176 11339321344 1904844384 18.865 97 20 41 0 1918925488 8575920 5505184
22:19:07 49973 8192000000 10835840256 11309686784 1886218368 18.715 98 14 28 0 1898011696 7879808 3913520
22:20:03 76530 8192000000 10850960880 11313074176 1790896832 17.939 93 12 24 1 1802384176 8437696 3049648
22:21:27 55364 8192000000 10836067344 11316453376 1889729936 18.744 98 22 44 1 1907767472 11757600 6279936
22:22:29 96364 8192000000 10840291728 11301208064 1801608848 18.027 93 26 52 1 1828992160 19799936 7583376
22:24:18 71129 8192000000 10857498416 11324743680 1895289456 18.788 99 17 34 0 1921191376 20747856 5154064
22:25:54 41263 8192000000 10858703072 11314245632 1858968128 18.495 96 25 49 1 1873141040 7238048 6934864
22:26:42 46872 8192000000 9097684240 9312174080 262919904 3.109 14 6 12 0 266265680 1890384 1455392

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 22-03-2021 22:28:28 to 22-03-2021 22:28:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 123 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

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

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          242941
MON$OLDEST_ACTIVE               242942
MON$OLDEST_SNAPSHOT             242942
MON$NEXT_TRANSACTION            242942
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                       2008704
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 ---
--- end of diff output ---

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

22.03.21 22:29:02. 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-22 22:29:04 No severe PSQL-related problems occured
22.03.21 22:29:06. End of report.