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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-24 01:27:20
DTS_END                         2021-02-24 01:27:20.2590
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52220
TRN_ID                          239126
ATT_ID                          650
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: 9089.97 20024 1090796
customer order: creation 173.13 336 20775
customer order: refuse 14.58 332 1749
order to supplier: creation 46.32 1215 5558
order to supplier: removal 3.43 101298 412
invoice (draft): creation 45.63 3337 5476
invoice (draft): removal 50.83 786 6100
invoice accept: apply 41.28 18191 4953
invoice accept: cancel 46.67 868 5600
customer reserve: creation 3781.42 181 453770
customer reserve: removal 4583.79 60 550055
realization accept: apply 84.53 172 10143
realization accept: cancel 88.06 105 10567
payment from customer: creation 59.86 114 7183
payment from customer: removal 5.48 102 658
payment to supplier: creation 49.17 120 5900
payment to supplier: removal 3.58 109 430
service: total inventory turnovers 4.70 1127 564
service: total monetary turnovers 6.68 22 802
service: aggregate perf. data 0.81 21418 97
service: refresh index statistics 0.03 250594 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-02-2021 01:28:45 to 24-02-2021 01:28:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5295
TEST_TIME 2 4771
TEST_TIME 3 5654
TEST_TIME 4 5790
TEST_TIME 5 5678
TEST_TIME 6 5695
TEST_TIME 7 5547
TEST_TIME 8 5482
TEST_TIME 9 5526
TEST_TIME 10 5454
TEST_TIME 11 5279
TEST_TIME 12 5477
TEST_TIME 13 5629
TEST_TIME 14 5876
TEST_TIME 15 6522
TEST_TIME 16 6770
TEST_TIME 17 6867
TEST_TIME 18 7189
TEST_TIME 19 8056
TEST_TIME 20 8270
TEST_TIME 21 8336
TEST_TIME 22 9556
TEST_TIME 23 9982
TEST_TIME 24 10253
TEST_TIME 25 10649
TEST_TIME 26 10486
TEST_TIME 27 10366
TEST_TIME 28 10485
TEST_TIME 29 10249
TEST_TIME 30 10400
TEST_TIME 31 10251
TEST_TIME 32 10009
TEST_TIME 33 9870
TEST_TIME 34 9709
TEST_TIME 35 9670
TEST_TIME 36 9568
TEST_TIME 37 9474
TEST_TIME 38 9624
TEST_TIME 39 9634
TEST_TIME 40 9487
TEST_TIME 41 9599
TEST_TIME 42 9612
TEST_TIME 43 9523
TEST_TIME 44 9458
TEST_TIME 45 9310
TEST_TIME 46 9229
TEST_TIME 47 9163
TEST_TIME 48 9183
TEST_TIME 49 9216
TEST_TIME 50 9274
TEST_TIME 51 9256
TEST_TIME 52 9264
TEST_TIME 53 9325
TEST_TIME 54 9390
TEST_TIME 55 9397
TEST_TIME 56 9425
TEST_TIME 57 9504
TEST_TIME 58 9622
TEST_TIME 59 9669
TEST_TIME 60 9679
TEST_TIME 61 9552
TEST_TIME 62 9530
TEST_TIME 63 9479
TEST_TIME 64 9437
TEST_TIME 65 9437
TEST_TIME 66 9398
TEST_TIME 67 9378
TEST_TIME 68 9304
TEST_TIME 69 9202
TEST_TIME 70 9254
TEST_TIME 71 9392
TEST_TIME 72 9348
TEST_TIME 73 9418
TEST_TIME 74 9429
TEST_TIME 75 9424
TEST_TIME 76 9399
TEST_TIME 77 9427
TEST_TIME 78 9443
TEST_TIME 79 9509
TEST_TIME 80 9470
TEST_TIME 81 9574
TEST_TIME 82 9560
TEST_TIME 83 9551
TEST_TIME 84 9490
TEST_TIME 85 9455
TEST_TIME 86 9408
TEST_TIME 87 9376
TEST_TIME 88 9381
TEST_TIME 89 9337
TEST_TIME 90 9297
TEST_TIME 91 9237
TEST_TIME 92 9240
TEST_TIME 93 9291
TEST_TIME 94 9295
TEST_TIME 95 9341
TEST_TIME 96 9328
TEST_TIME 97 9378
TEST_TIME 98 9356
TEST_TIME 99 9351
TEST_TIME 100 9383
TEST_TIME 101 9404
TEST_TIME 102 9374
TEST_TIME 103 9378
TEST_TIME 104 9443
TEST_TIME 105 9444
TEST_TIME 106 9490
TEST_TIME 107 9417
TEST_TIME 108 9368
TEST_TIME 109 9395
TEST_TIME 110 9393
TEST_TIME 111 9378
TEST_TIME 112 9330
TEST_TIME 113 9284
TEST_TIME 114 9284
TEST_TIME 115 9282
TEST_TIME 116 9232
TEST_TIME 117 9211
TEST_TIME 118 9182
TEST_TIME 119 9152
TEST_TIME 120 9099

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-02-2021 01:28:48 to 24-02-2021 01:28:52.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1512495 1512495 0 0.00 0 18872 6 0 0
doc_list_biud 1512495 1512495 0 0.00 0 31941 27 0 0
sp_add_invoice_to_stock 5080 4953 127 2.50 49 198127 18192 0 127
sp_cancel_adding_invoice 5600 5600 0 0.00 5 79438 868 0 0
sp_cancel_client_order 1749 1749 0 0.00 5 13308 332 0 0
sp_cancel_customer_reserve 550055 550055 0 0.00 1 31945 60 0 0
sp_cancel_pay_from_customer 658 658 0 0.00 3 8340 102 0 0
sp_cancel_pay_to_supplier 430 430 0 0.00 3 7383 110 0 0
sp_cancel_supplier_invoice 6108 6100 8 0.13 2 19724 787 0 8
sp_cancel_supplier_order 412 412 0 0.00 6 1103441 101298 0 0
sp_cancel_write_off 10567 10567 0 0.00 1 8120 106 0 0
sp_client_order 20775 20775 0 0.00 4 24589 337 0 0
sp_customer_reserve 453770 453770 0 0.00 0 128838 181 0 0
sp_fill_shopping_cart 31797 31797 0 0.00 1 9206 36 0 0
sp_fill_shopping_cart_clo_res 453757 453757 0 0.00 0 16080 14 0 0
sp_get_clo_for_invoice 4934 4934 0 0.00 0 20604 283 0 0
sp_kill_cost_storno 17255 17255 0 0.00 0 7745 56 0 0
sp_kill_qstorno_ret_qs2qd 1117189 1117189 0 0.00 0 31938 32 0 0
sp_kill_qty_storno 589560 589560 0 0.00 0 31941 70 0 0
sp_lock_selected_doc 20908 20908 0 0.00 0 11567 8 0 0
sp_make_cost_storno 28160 28160 0 0.00 0 18728 51 0 0
sp_multiply_rows_for_pdistr 28160 28160 0 0.00 0 18290 30 0 0
sp_multiply_rows_for_qdistr 20775 20775 0 0.00 0 12139 152 0 0
sp_pay_from_customer 7183 7183 0 0.00 4 18361 115 0 0
sp_pay_to_supplier 5900 5900 0 0.00 5 10231 121 0 0
sp_payment_common 13083 13083 0 0.00 1 6350 26 0 0
sp_qd_handle_on_cancel_clo 1749 1749 0 0.00 0 13302 313 0 0
sp_qd_handle_on_invoice_upd_sts 10534 10534 0 0.00 0 17489 331 0 0
sp_qd_handle_on_reserve_upd_sts 10143 10143 0 0.00 0 14564 59 0 0
sp_reserve_write_off 10143 10143 0 0.00 6 20617 173 0 0
sp_supplier_invoice 5476 5476 0 0.00 7 101148 3337 0 0
sp_supplier_order 5558 5558 0 0.00 5 25715 1216 0 0
srv_aggregate_perf_data 98 97 1 1.02 2447 302590 21419 0 1
srv_fill_mon_cache_memory 157 157 0 0.00 1216 124900 32782 0 0
srv_find_qd_qs_mism 1043953 1043953 0 0.00 0 18505 6 0 0
srv_make_invnt_saldo 564 564 0 0.00 27 98622 1128 0 0
srv_make_money_saldo 802 802 0 0.00 1 813 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 135500 348452 250595 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4954 4954 0 0.00 0 13670 160 0 0
t$perf-norm:sp_cancel_adding_invoice 467 467 0 0.00 0 3994 82 0 0
t$perf-norm:sp_cancel_client_order 1749 1749 0 0.00 0 3890 18 0 0
t$perf-norm:sp_cancel_customer_reserve 696 696 0 0.00 0 2018 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 658 658 0 0.00 0 2115 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 430 430 0 0.00 0 704 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 384 384 0 0.00 0 1256 13 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 19965 1704 0 0
t$perf-norm:sp_cancel_write_off 1035 1035 0 0.00 0 872 8 0 0
t$perf-norm:sp_client_order 20775 20775 0 0.00 0 7485 19 0 0
t$perf-norm:sp_customer_reserve 988 988 0 0.00 0 1480 8 0 0
t$perf-norm:sp_pay_from_customer 7183 7183 0 0.00 0 15760 12 0 0
t$perf-norm:sp_pay_to_supplier 5900 5900 0 0.00 0 5016 9 0 0
t$perf-norm:sp_reserve_write_off 10143 10143 0 0.00 0 6626 16 0 0
t$perf-norm:sp_supplier_invoice 5476 5476 0 0.00 0 9774 18 0 0
t$perf-norm:sp_supplier_order 5558 5558 0 0.00 0 4716 13 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 101 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 385 6 0 0
t$perf-norm:srv_make_invnt_saldo 564 564 0 0.00 0 589 20 0 0
t$perf-norm:srv_make_money_saldo 802 802 0 0.00 0 8133 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 17 6 0 0
v_add_invoice_to_stock 10122 9868 254 2.50 0 6729 19 0 254
v_all_customers 37786 37786 0 0.00 0 19 1 0 0
v_all_suppliers 30778 30778 0 0.00 0 20 1 0 0
v_all_wares 41550 41550 0 0.00 0 64 1 0 0
v_cancel_adding_invoice 934 934 0 0.00 0 522 7 0 0
v_cancel_client_order 3498 3498 0 0.00 0 1100 4 0 0
v_cancel_customer_prepayment 1316 1316 0 0.00 0 2260 5 0 0
v_cancel_customer_reserve 1392 1392 0 0.00 0 1436 4 0 0
v_cancel_payment_to_supplier 860 860 0 0.00 0 5422 11 0 0
v_cancel_supplier_invoice 784 768 16 2.04 0 2399 23 0 16
v_cancel_supplier_order 824 824 0 0.00 0 243 3 0 0
v_cancel_write_off 2070 2070 0 0.00 0 2301 15 0 0
v_max_id_clo_ord 5557 5557 0 0.00 0 822 1 0 0
v_max_id_clo_res 988 988 0 0.00 0 1580 10 0 0
v_max_id_ord_sup 5465 5465 0 0.00 0 5987 3 0 0
v_max_non_paid_invoice 1533 1533 0 0.00 0 905 3 0 0
v_max_non_paid_realizn 3847 3847 0 0.00 0 1921 4 0 0
v_min_id_clo_ord 5557 5557 0 0.00 0 5766 7 0 0
v_min_id_clo_res 988 988 0 0.00 0 422 2 0 0
v_min_id_ord_sup 5465 5465 0 0.00 0 5244 5 0 0
v_min_non_paid_invoice 5900 5900 0 0.00 0 6347 18 0 0
v_min_non_paid_realizn 7183 7183 0 0.00 0 5812 14 0 0
v_our_firm 10436 10436 0 0.00 0 12 1 0 0
v_reserve_write_off 20286 20286 0 0.00 0 3456 5 0 0
x_lock_depdocs_on_canc_invoice 11316 11316 0 0.00 0 13738 127 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 17031 386 0 0
x_make_qstorno_1000_1200 5558 5558 0 0.00 2 25576 1134 0 0
x_make_qstorno_1200_2000 5476 5476 0 0.00 3 101131 3211 0 0
x_make_qstorno_2100_3300 453770 453770 0 0.00 0 128074 165 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 24-02-2021 01:28:52 to 24-02-2021 01:28:57.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:24 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:30 15957 8192000000 10229461712 10535669760 786493328 8.759 62 44 90 0 803348640 2035072 14820240
22:57:56 12515 8192000000 10318835296 10635382784 1377998288 14.399 100 87 175 0 1410490000 4351920 28139792
22:58:24 33696 8192000000 10374650224 10696155136 1429755312 14.859 100 89 178 0 1464830112 6498480 28576320
22:59:14 24876 8192000000 10401424432 10728148992 1456649616 15.096 100 88 176 0 1492708176 7762560 28296000
22:59:48 21527 8192000000 10415611616 10743566336 1470917456 15.222 100 91 182 0 1508929168 8246512 29765200
23:00:21 9272 8192000000 10429731872 10759200768 1480788240 15.308 100 89 178 0 1518343328 8891456 28663632
23:00:39 19298 8192000000 10441916864 10778550272 1495316720 15.435 100 86 172 0 1532221552 9229488 27675344
23:01:07 19920 8192000000 10467039216 10806476800 1518847792 15.640 100 86 172 1 1555988240 9654112 27486336
23:01:42 28328 8192000000 10480941424 10830307328 1542257488 15.843 100 82 164 1 1578310256 10847424 25205344
23:02:26 12456 8192000000 10508801040 10865635328 1568171584 16.067 100 74 148 1 1602017344 10822784 23022976
23:02:47 13268 8192000000 10549009296 10904858624 1601368720 16.351 100 72 144 0 1633341936 10670368 21302848
23:03:10 14012 8192000000 10570863824 10927394816 1626557056 16.566 100 89 178 0 1665828688 12266688 27004944
23:03:33 9669 8192000000 10577554000 10940510208 1633994640 16.629 100 72 144 0 1666918192 11719680 21203872
23:03:54 9906 8192000000 10612029584 10974826496 1661164592 16.859 100 72 142 1 1693845456 11760096 20920768
23:04:12 10541 8192000000 10637237152 11007201280 1690460800 17.105 100 83 166 1 1727144480 12121264 24562416
23:04:32 5730 8192000000 10658813312 11032309760 1722895536 17.376 100 86 172 4 1760340192 11970192 25474464
23:04:45 5497 8192000000 10672434720 11043860480 1730398208 17.439 100 77 155 1 1765042448 12097872 22546368
23:04:58 9095 8192000000 10688084688 11063705600 1744202112 17.554 100 80 160 1 1779314032 12472144 22639776
23:05:14 5369 8192000000 10696398816 11073507328 1754506512 17.639 100 88 176 3 1793782448 13787920 25488016
23:05:27 5519 8192000000 10702342608 11084529664 1764114048 17.718 100 86 171 4 1802505264 14476032 23915184
23:05:40 4195 8192000000 10718071840 11099545600 1777634544 17.830 100 83 164 3 1815152080 13897280 23620256
23:05:51 4040 8192000000 10731371296 11111481344 1787610112 17.912 100 85 170 1 1825311952 13999440 23702400
23:06:02 4269 8192000000 10725850384 11115794432 1792329648 17.951 100 75 147 1 1825957264 12843792 20783824
23:06:13 4357 8192000000 10743613680 11128934400 1805571712 18.060 100 86 172 0 1842834288 13472672 23789904
23:06:24 2968 8192000000 10753561024 11133464576 1812537232 18.117 100 88 176 2 1849880320 13721536 23621552
23:06:34 5914 8192000000 10749654656 11137716224 1813149344 18.122 100 80 159 1 1849211776 14040992 22021440
23:06:48 2074 8192000000 10768276976 11151372288 1823165008 18.204 100 79 158 0 1858212448 12805056 22242384
23:06:57 3470 8192000000 10768092528 11158372352 1832007664 18.276 100 84 169 2 1868628480 13002336 23618480
23:07:07 2971 8192000000 10776217328 11161300992 1839402032 18.336 100 86 172 3 1876048336 13180800 23465504
23:07:17 3113 8192000000 10776987952 11172818944 1844771184 18.380 100 88 175 1 1881878688 12075328 25032176
23:07:26 1459 8192000000 10788648544 11174748160 1850586240 18.427 100 93 187 2 1890040224 13101568 26352416
23:07:34 2651 8192000000 10797669936 11183493120 1849731536 18.420 100 85 166 2 1885876944 12664112 23481296
23:07:44 2563 8192000000 10799488080 11188936704 1860724368 18.509 100 89 176 0 1898321312 13381072 24215872
23:07:53 2209 8192000000 10808372720 11197272064 1864900768 18.543 100 91 181 1 1903639888 14326960 24412160
23:08:01 1419 8192000000 10806887312 11196436480 1867683248 18.566 100 95 190 1 1908055328 14479472 25892608
23:08:09 1579 8192000000 10812467680 11205672960 1869897760 18.583 100 92 182 4 1913572784 17927696 25747328
23:08:18 3166 8192000000 10814064672 11204300800 1873363456 18.611 100 84 168 0 1909241120 12493376 23384288
23:08:27 2473 8192000000 10814853216 11207581696 1877137088 18.642 100 82 165 0 1912814352 13060432 22616832
23:08:36 1361 8192000000 10820694768 11214135296 1877284800 18.643 100 87 175 0 1915280096 13672064 24323232
23:08:44 44303 8192000000 10812769136 11216302080 1876034752 18.633 100 55 108 2 1900821648 9291872 15495024
23:09:34 2035 8192000000 10814167616 11215290368 1881917472 18.681 100 75 150 1 1914331760 10630032 21784256
23:09:43 8990 8192000000 10824769200 11221819392 1884246928 18.699 100 72 144 4 1915103200 9975440 20880832
23:09:58 3091 8192000000 10813396576 11226161152 1889317312 18.740 100 62 124 1 1918674592 11752912 17604368
23:10:10 4249 8192000000 10805423952 11226722304 1885496976 18.709 100 43 85 0 1907246576 9983392 11766208
23:10:20 4733 8192000000 10801706256 11225329664 1886696064 18.719 100 37 75 2 1905552048 8672304 10183680
23:10:32 4667 8192000000 10805454080 11232272384 1886807808 18.720 100 30 60 1 1903193808 7884288 8501712
23:10:45 5631 8192000000 10808060896 11225964544 1888196848 18.731 100 27 54 0 1902464544 6858272 7409424
23:10:57 6106 8192000000 10798077488 11233337344 1890774576 18.752 100 22 44 2 1907219792 10569008 5876208
23:11:10 4146 8192000000 10819600768 11236990976 1898620800 18.815 100 39 77 0 1915577296 6045248 10911248
23:11:21 9140 8192000000 10814645792 11242967040 1895718448 18.792 100 23 46 0 1913913120 12235408 5959264
23:11:36 7853 8192000000 10812619040 11247656960 1901015664 18.834 100 24 48 0 1918463632 11249616 6198352
23:11:51 9509 8192000000 10814048656 11243044864 1904411168 18.862 100 19 38 1 1915645968 5618864 5615936
23:12:07 11856 8192000000 10819630640 11252805632 1908754320 18.897 100 23 46 1 1921696240 6133792 6808128
23:12:27 10935 8192000000 10813289536 11252588544 1906708432 18.880 100 9 18 2 1918868864 9372720 2787712
23:12:44 4918 8192000000 10824133120 11255382016 1914292768 18.941 100 27 53 2 1928389888 6114288 7982832
23:12:58 9419 8192000000 10827477104 11258535936 1917431520 18.966 100 34 67 1 1932972480 5950816 9590144
23:13:19 52874 8192000000 10847804320 11268931584 1917828560 18.969 100 43 87 0 1935857760 5724544 12304656
23:14:18 10400 8192000000 10831886368 11268653056 1915284848 18.949 100 22 44 3 1932477776 11334352 5858576
23:14:36 4767 8192000000 10840928720 11271770112 1921099632 18.996 100 44 86 2 1941565088 8666896 11798560
23:14:51 4754 8192000000 10843977552 11278598144 1923151184 19.012 100 41 82 2 1946367584 11456128 11760272
23:15:06 5503 8192000000 10836585120 11274018816 1923819520 19.017 100 37 73 3 1941163760 7283408 10060832
23:15:19 4140 8192000000 10840624384 11274133504 1923025616 19.011 100 24 48 1 1935441264 5641776 6773872
23:15:30 6180 8192000000 10828117920 11270815744 1922817936 19.009 100 24 47 1 1935802640 6671280 6313424
23:15:44 6745 8192000000 10832474256 11274936320 1924086096 19.020 100 22 44 0 1937163520 6255328 6822096
23:16:00 7890 8192000000 10828084384 11266465792 1896903296 18.801 99 15 30 1 1906904544 5660544 4340704
23:16:16 8010 8192000000 10812919152 11254304768 1893685088 18.775 99 24 48 0 1906434528 5827200 6922240
23:16:30 6730 8192000000 10814537760 11254185984 1893486480 18.774 99 23 46 3 1906135776 6119728 6529568
23:16:44 5590 8192000000 10824369696 11254722560 1904085488 18.859 100 26 52 0 1917288128 5950976 7251664
23:16:56 9592 8192000000 10796199456 11233058816 1849789008 18.420 97 26 52 1 1862904832 5543776 7572048
23:17:12 9953 8192000000 10775806688 11204640768 1817839920 18.160 96 50 100 2 1837532464 4831344 14861200
23:17:29 60144 8192000000 10767831504 11165167616 1722649712 17.374 92 41 83 1 1740402448 4901056 12851680
23:18:35 6731 8192000000 10753750416 11183685632 1831031568 18.268 99 38 76 0 1851522864 10044576 10446720
23:18:51 5658 8192000000 10776308400 11196002304 1824743936 18.216 98 37 74 1 1842446624 7312000 10390688
23:19:04 3349 8192000000 10768759504 11182268416 1820059952 18.178 98 54 109 1 1842082896 6075968 15946976
23:19:14 5399 8192000000 10731929488 11150725120 1749150416 17.595 95 25 50 4 1761862272 5638576 7073280
23:19:25 5234 8192000000 10736483184 11152928768 1805646880 18.060 99 48 94 0 1826994128 7332432 14014816
23:19:40 7911 8192000000 10726898432 11139682304 1772989088 17.792 98 19 38 1 1787887264 10177056 4721120
23:19:56 6087 8192000000 10711022064 11127107584 1767773184 17.749 98 36 72 0 1785273472 6635184 10865104
23:20:09 11148 8192000000 10734594912 11153850368 1800663552 18.019 99 19 39 2 1811694560 5518240 5512768
23:20:26 8087 8192000000 10714488208 11127107584 1732070944 17.453 95 20 40 0 1742373936 4634560 5668432
23:20:41 6566 8192000000 10699369888 11114508288 1713433632 17.297 95 23 46 1 1729356528 9357296 6565600
23:20:56 14285 8192000000 10708176944 11117514752 1718732736 17.342 95 22 43 0 1730171520 5049520 6389264
23:21:20 53504 8192000000 10685046592 11100762112 1661062560 16.858 92 13 26 1 1669869184 5076880 3729744
23:22:19 11798 8192000000 10729274016 11144146944 1796220944 17.983 100 34 64 5 1811125744 5295760 9609040
23:22:37 6017 8192000000 10744361200 11159928832 1818236384 18.163 100 33 64 3 1833640848 6352224 9052240
23:22:51 4009 8192000000 10736387136 11156967424 1812439632 18.116 99 45 90 2 1832508864 6459184 13610048
23:23:03 5760 8192000000 10760296688 11165847552 1830833744 18.266 100 46 92 1 1851185904 7431440 12920720
23:23:15 9514 8192000000 10755292224 11170029568 1830273184 18.262 100 26 52 2 1843387808 6106384 7008240
23:23:32 6111 8192000000 10766326880 11185876992 1844849664 18.380 100 28 55 0 1859068192 6578064 7640464
23:23:45 6624 8192000000 10766677184 11189518336 1849668336 18.419 100 28 56 0 1863335088 5384784 8281968
23:24:00 4073 8192000000 10772269712 11194253312 1862076768 18.520 100 27 54 1 1875497696 5480320 7940608
23:24:12 8236 8192000000 10767894112 11196567552 1857881664 18.486 100 24 47 1 1870612736 5930800 6800272
23:24:29 5384 8192000000 10780514944 11201916928 1863063728 18.528 100 42 80 0 1881980896 7376976 11540192
23:24:43 6842 8192000000 10777040048 11209695232 1866879280 18.559 100 27 54 1 1885030384 10412752 7738352
23:24:58 9480 8192000000 10775106256 11206823936 1866632336 18.557 100 19 38 1 1877511056 5573456 5305264
23:25:15 7274 8192000000 10775061968 11208790016 1871376336 18.595 100 18 36 3 1882054880 5305824 5372720
23:25:29 74098 8192000000 10784824272 11217395712 1874190016 18.618 100 33 65 2 1888754720 5002768 9561936
23:26:49 7482 8192000000 10800521136 11223543808 1877899584 18.648 100 33 66 1 1898548848 11544176 9105088
23:27:03 6342 8192000000 10818699008 11240038400 1886159184 18.715 100 34 68 2 1908719344 14486336 8073824
23:27:16 7590 8192000000 10811036192 11240308736 1899969264 18.826 100 36 71 2 1915837904 5844688 10023952
23:27:34 50295 8192000000 10837596448 11258306560 1908703504 18.896 100 43 85 0 1927796320 7004368 12088448
23:28:31 10290 8192000000 10844474512 11270905856 1921047104 18.995 100 54 106 1 1945348912 8802080 15499728
23:28:53 26825 8192000000 10854352864 11280502784 1926702944 19.041 100 53 105 2 1951493312 9484928 15305440
23:29:30 22813 8192000000 10856545712 11283685376 1929421008 19.062 100 41 82 1 1951074912 9762928 11890976
23:30:09 37661 8192000000 10858061168 11300302848 1932746576 19.089 100 33 66 4 1952279264 9794816 9737872
23:31:00 11902 8192000000 10872879888 11308625920 1944925312 19.186 100 36 72 2 1966854672 11113840 10815520
23:31:19 6154 8192000000 10885865648 11317792768 1952574416 19.247 100 52 104 1 1981051216 13279728 15197072
23:31:32 13539 8192000000 10902141088 11323879424 1957318432 19.285 100 62 121 3 1989158016 14217392 17622192
23:31:59 56065 8192000000 10891340112 11333992448 1960062128 19.307 100 36 72 0 1988449872 17687024 10700720
23:33:05 28798 8192000000 10902125264 11341348864 1964546048 19.342 100 38 76 1 1993758864 18036512 11176304
23:33:53 16049 8192000000 10892509728 11345072128 1969674592 19.383 100 32 63 0 1996169072 16931024 9563456
23:34:17 8835 8192000000 10907491568 11352653824 1973158432 19.410 100 31 62 2 1999994864 17185840 9650592
23:34:38 5843 8192000000 10904779344 11342110720 1958757024 19.296 99 37 74 2 1986668032 16361104 11549904
23:34:54 15469 8192000000 10923800048 11359662080 1980665664 19.470 100 51 101 2 2013983648 17705728 15612256
23:35:19 2653 8192000000 10934442608 11369349120 1989111696 19.537 100 56 112 1 2028000608 21312992 17575920
23:35:31 4933 8192000000 10943596400 11376500736 1993574560 19.572 100 60 117 2 2033263872 22172624 17516688
23:35:44 20188 8192000000 10952442576 11383664640 1997786176 19.605 100 63 123 2 2040118080 24592416 17739488
23:36:14 2008 8192000000 10959018128 11387744256 2002531296 19.643 100 71 143 1 2047871568 24746432 20593840
23:36:24 14870 8192000000 10963829472 11394056192 2006824928 19.677 100 70 140 1 2054310784 26785792 20700064
23:37:12 11540 8192000000 10947941360 11398144000 2005821856 19.669 100 37 74 1 2041238160 24379552 11036752
23:37:30 14546 8192000000 10956923568 11405611008 2011471904 19.713 100 36 70 1 2046040208 24022416 10545888
23:38:17 6995 8192000000 10982138528 11422670848 2030796864 19.865 100 50 98 1 2072250208 27074176 14379168
23:38:34 5998 8192000000 10992028832 11428323328 2032899216 19.881 100 57 112 1 2079916784 29203424 17814144
23:38:56 6164 8192000000 11006318624 11434811392 2032578080 19.879 100 67 132 1 2086070336 33035584 20456672
23:39:11 3303 8192000000 11000869536 11438784512 2038091616 19.922 100 55 110 0 2088527472 33506208 16929648
23:39:22 2672 8192000000 11013421328 11444170752 2046326080 19.986 100 75 149 2 2102873984 33879328 22668576
23:39:33 7255 8192000000 10994627232 11436142592 2033512256 19.886 100 60 121 1 2087350656 35023216 18815184
23:39:51 1814 8192000000 11032825232 11451695104 2051250784 20.025 100 95 188 0 2116118704 35456480 29411440
23:39:59 3359 8192000000 10997533344 11421569024 2024080480 19.812 99 78 155 0 2084815728 36256480 24478768
23:40:10 2656 8192000000 11026449520 11453227008 2045332560 19.979 100 89 178 1 2112966640 40318480 27315600
23:40:23 3046 8192000000 11024700656 11455672320 2045530656 19.980 100 72 144 0 2107930448 40067024 22332768
23:40:40 9412 8192000000 11014043920 11451854848 2042528880 19.957 100 69 138 1 2104646688 40153520 21964288
23:40:57 5972 8192000000 11023114752 11450327040 2039117456 19.930 100 68 136 1 2100876592 40471392 21287744
23:41:11 3103 8192000000 11020776560 11446640640 2039599216 19.934 100 89 175 2 2107913040 40544304 27769520
23:41:20 2262 8192000000 11031923056 11455680512 2047720960 19.997 100 86 173 1 2116318096 41406576 27190560
23:41:33 4037 8192000000 11016440848 11453480960 2035923440 19.905 100 60 120 1 2101647792 46445152 19279200
23:41:47 2853 8192000000 11024899792 11447402496 2038720400 19.927 100 81 159 1 2105453104 41402144 25330560
23:41:58 3633 8192000000 11017588768 11441930240 2031941536 19.874 100 84 168 1 2100547104 42433312 26172256
23:42:09 3279 8192000000 11003410320 11437883392 2014791872 19.739 99 82 164 0 2080789904 40627024 25371008
23:42:22 4561 8192000000 11002939440 11433340928 2029899312 19.858 100 73 146 1 2091447632 38574464 22973856
23:42:36 1588 8192000000 11025371568 11446833152 2036194192 19.907 100 77 154 0 2101134128 39531200 25408736
23:42:44 2492 8192000000 11029766400 11450085376 2038711696 19.927 100 91 180 0 2111043968 43768432 28563840
23:42:54 3126 8192000000 11003810224 11427442688 2019946544 19.780 100 81 162 0 2087211072 41887072 25377456
23:43:04 2411 8192000000 11017175536 11436105728 2030910512 19.866 100 91 182 2 2103073792 43573360 28589920
23:43:14 1450 8192000000 11015954576 11432919040 2024617872 19.816 100 93 186 0 2098407744 44474832 29315040
23:43:24 5109 8192000000 10995884784 11415126016 2000059424 19.623 99 90 180 1 2071830576 43640704 28130448
23:43:37 2789 8192000000 11008552288 11430064128 2017327744 19.759 100 85 164 1 2089157600 46052416 25777440
23:43:47 3942 8192000000 11014515472 11432124416 2021318064 19.791 100 83 165 2 2094492608 46628752 26545792
23:43:58 3058 8192000000 11008600400 11433746432 2021884464 19.795 100 76 152 1 2092382432 46725920 23772048
23:44:09 2753 8192000000 11011570544 11431309312 2017877344 19.763 100 81 162 0 2090626160 47027520 25721296
23:44:20 1759 8192000000 11012070432 11425329152 2001337296 19.633 99 87 174 1 2077976400 48514160 28124944
23:44:29 4650 8192000000 11003506480 11426492416 2001097936 19.631 99 82 162 0 2077177872 50065488 26014448
23:44:42 4518 8192000000 11000165904 11435819008 2019915744 19.779 100 58 116 1 2089084160 50128208 19040208
23:44:53 4721 8192000000 11010310272 11437039616 2001951728 19.638 99 68 136 1 2080238032 55519872 22766432
23:45:20 2556 8192000000 11007450432 11428331520 2007187936 19.679 100 73 146 2 2084720672 53083600 24449136
23:45:30 2666 8192000000 11008933296 11422425088 1990113792 19.545 99 84 163 1 2068901856 52792208 25995856
23:45:41 1598 8192000000 11002743760 11423166464 1993167616 19.569 99 90 178 0 2076714064 54687792 28858656
23:45:49 3156 8192000000 11014691936 11435323392 2011957552 19.717 100 86 168 1 2096266192 57188128 27120512
23:45:59 1214 8192000000 11009804112 11427794944 2007080544 19.679 100 88 173 2 2088990736 54651776 27258416
23:46:07 2351 8192000000 11007537680 11435274240 2013335328 19.728 100 75 148 1 2093198768 55871408 23992032
23:46:20 9181 8192000000 10991543168 11445547008 2010092032 19.702 100 46 92 3 2080586112 54649072 15845008
23:46:39 13849 8192000000 10970358464 11425566720 1988856256 19.535 99 36 72 0 2051838048 50297520 12684272
23:47:04 5067 8192000000 10965582912 11407253504 1985893808 19.511 100 40 78 2 2045279552 46707712 12678032
23:47:25 4765 8192000000 10986475600 11420008448 1982324528 19.483 99 57 114 2 2054562240 53159232 19078480
23:47:37 19173 8192000000 10959073056 11410251776 1992926832 19.567 100 36 72 0 2051199728 46324336 11948560
23:48:05 14622 8192000000 10969610976 11419918336 1989654112 19.541 100 36 72 2 2056724192 53963040 13107040
23:48:31 15811 8192000000 10926678912 11378622464 1908456320 18.894 96 30 59 2 1974847360 55070304 11320736
23:48:58 7119 8192000000 10937596272 11391840256 1943989040 19.179 99 43 86 1 2016462000 57018112 15454848
23:49:15 11194 8192000000 10921255040 11370024960 1916430896 18.958 98 40 80 1 1980267616 49974496 13862224
23:49:32 26563 8192000000 10893307728 11356241920 1922575472 19.007 99 28 56 0 1975839488 43595072 9668944
23:50:24 19748 8192000000 10868244448 11323240448 1882018576 18.681 97 26 52 1 1921528880 30888432 8621872
23:50:52 24440 8192000000 10826061904 11284025344 1866651456 18.557 97 12 24 1 1893776512 23290304 3834752
23:51:27 44808 8192000000 10844897232 11302453248 1860040512 18.504 97 11 22 2 1887381296 23383136 3957648
23:52:25 86708 8192000000 10846212416 11281059840 1787300672 17.910 93 22 45 1 1803896832 9783248 6812912
23:54:02 30640 8192000000 10838944368 11286065152 1889428944 18.741 99 26 53 0 1905775744 8865200 7481600
23:54:54 40675 8192000000 10832435056 11301494784 1884350064 18.700 99 6 12 0 1897275216 11087648 1837504
23:55:41 47229 8192000000 10840542096 11286503424 1835881712 18.307 96 20 40 0 1854824720 13579696 5363312
23:56:43 18015 8192000000 10831896656 11268775936 1866876432 18.559 98 43 86 1 1891080528 11731168 12472928
23:57:35 73036 8192000000 10803577792 11241820160 1797661872 17.995 95 17 34 1 1811876944 8481536 5733536
23:58:56 117966 8192000000 10808680944 11249590272 1838660736 18.330 97 29 58 3 1853788320 6963360 8164224
00:01:24 55428 8192000000 10839501360 11282444288 1851474928 18.434 98 27 54 0 1868289824 9753808 7061088
00:02:26 21007 8192000000 10848891920 11294449664 1913042160 18.931 100 20 40 1 1931786208 13354096 5389952
00:02:53 11610 8192000000 10876366832 11315249152 1920247664 18.989 99 38 76 1 1946347344 15360240 10739440
00:03:16 33874 8192000000 10892992096 11339321344 1947733696 19.208 100 44 88 0 1979839472 18933936 13171840
00:04:09 41500 8192000000 10892984928 11347390464 1943666240 19.176 100 18 36 1 1971187584 21862848 5658496
00:05:04 11955 8192000000 10890861088 11344580608 1932366192 19.086 99 24 48 1 1962388928 22810832 7211904
00:05:35 71070 8192000000 10870418496 11336880128 1919239472 18.981 99 11 22 0 1944480640 21967856 3273312
00:06:52 105277 8192000000 10887348848 11342651392 1947377456 19.206 100 20 39 1 1971611344 18094048 6139840
00:08:45 43619 8192000000 10876192752 11339796480 1935181104 19.108 99 22 43 0 1953527184 12102720 6243360
00:09:35 45856 8192000000 10878648336 11343392768 1958497296 19.294 100 18 36 0 1971641472 7721056 5423120
00:10:28 14535 8192000000 10880813408 11348115456 1962047952 19.322 100 19 38 0 1976451760 9479312 4924496
00:10:50 16316 8192000000 10878672800 11350138880 1957947584 19.290 100 5 10 0 1968920272 9162000 1810688
00:11:18 93883 8192000000 10880405280 11354853376 1944663104 19.184 99 19 38 0 1959630832 9202096 5765632
00:13:09 69818 8192000000 10869507824 11347877888 1955690688 19.272 100 2 4 0 1963553904 7469728 393488
00:14:25 12163 8192000000 10878730272 11352403968 1962527616 19.326 100 16 32 0 1978045328 10639600 4878112
00:14:43 26146 8192000000 10888912512 11362516992 1961128784 19.315 100 8 16 0 1970639504 7198176 2312544
00:15:25 46978 8192000000 10893571024 11358994432 1950739008 19.232 99 14 26 1 1963677376 9746240 3192128
00:16:21 32513 8192000000 10883203968 11349807104 1951392336 19.238 99 22 44 1 1973797280 15965952 6438992
00:17:03 65569 8192000000 10900582496 11376062464 1954450448 19.262 99 14 27 2 1969621792 11072208 4099136
00:18:15 43103 8192000000 10917535232 11388940288 1963052448 19.330 99 14 26 2 1975994192 8784992 4156752
00:19:09 30184 8192000000 10916870432 11385278464 1968499824 19.374 99 18 36 1 1986287472 12440576 5347072
00:19:48 40491 8192000000 10890068464 11361239040 1905626944 18.872 96 12 24 1 1922629488 13591328 3411216
00:20:37 67230 8192000000 10903988656 11366113280 1946165840 19.196 99 17 34 0 1970347152 18394320 5786992
00:21:55 67816 8192000000 10894565136 11360829440 1916239648 18.957 97 21 41 0 1936663168 14462384 5961136
00:23:09 62499 8192000000 10891793248 11355172864 1928144272 19.052 98 12 24 1 1951298432 19624160 3530000
00:24:28 54059 8192000000 10892200800 11362566144 1926437760 19.038 98 10 20 1 1950275248 20707840 3129648
00:25:28 62144 8192000000 10888839280 11364892672 1920357968 18.990 98 16 32 0 1938879088 13988192 4532928
00:26:56 76296 8192000000 10905644576 11359641600 1901684992 18.840 96 28 55 1 1921765264 12287008 7793264
00:28:20 90246 8192000000 10883831568 11343114240 1911578128 18.919 97 42 82 0 1935470496 11889488 12002880
00:29:56 39501 8192000000 10905447936 11363860480 1952378416 19.245 99 42 82 0 1971673712 8263728 11031568
00:30:42 35538 8192000000 10922372864 11366952960 1940790384 19.153 98 46 91 0 1961760224 8381056 12588784
00:31:24 44846 8192000000 10864720160 11327090688 1930970624 19.075 98 35 70 0 1951938752 11277056 9691072
00:32:40 39214 8192000000 10871896096 11353194496 1962135504 19.323 100 12 24 1 1974342208 8947520 3259184
00:33:27 34276 8192000000 10853671984 11333521408 1916292448 18.957 98 6 11 0 1926146304 8481024 1372832
00:35:10 26474 8192000000 10877347632 11349557248 1941629520 19.160 99 11 22 1 1950757168 6160288 2967360
00:35:47 37391 8192000000 10897938192 11365175296 1950160320 19.228 99 20 39 1 1966910048 11190432 5559296
00:37:02 57087 8192000000 10888536304 11372576768 1929001424 19.059 98 20 40 1 1955177408 19970192 6205792
00:39:08 79333 8192000000 10852267200 11323670528 1819497600 18.174 93 13 26 1 1836575968 13497872 3580496
00:40:50 82936 8192000000 10862937952 11331424256 1877605760 18.646 97 11 22 0 1891660288 11047040 3007488
00:42:29 46995 8192000000 10854461664 11305226240 1867234560 18.562 96 35 70 0 1885822096 8850384 9737152
00:43:22 15019 8192000000 10869910432 11317391360 1909219088 18.900 99 41 82 0 1929539088 9122592 11197408
00:43:58 51235 8192000000 10858442736 11313074176 1875108400 18.626 97 24 48 3 1896944064 14568992 7266672
00:44:55 90411 8192000000 10852393296 11334463488 1870629248 18.589 97 25 50 0 1891951632 14039440 7282944
00:46:32 63298 8192000000 10871480176 11323576320 1846044896 18.390 96 18 34 1 1862828352 12179056 4604400
00:47:42 86729 8192000000 10860389776 11337441280 1907438992 18.886 99 16 32 0 1932660368 20607616 4613760
00:49:15 84663 8192000000 10888511744 11330764800 1902555584 18.847 98 24 48 0 1920056608 10734480 6766544
00:50:46 30938 8192000000 10854599712 11311812608 1922055072 19.003 99 35 69 2 1942158288 10452496 9650720
00:51:26 124900 8192000000 10845567872 11311202304 1798040400 17.998 93 34 66 0 1816494848 9118624 9335824
00:53:48 33966 8192000000 10849563648 11310198784 1904238848 18.860 99 39 78 2 1925918320 10946528 10732944
00:54:29 8954 8192000000 10853160160 11313221632 1920827984 18.993 100 32 63 3 1942313456 12597632 8887840
00:55:05 40313 8192000000 10842230000 11317321728 1889335808 18.740 98 19 37 0 1906529792 12173728 5020256
00:56:06 82486 8192000000 10884297488 11353845760 1940806000 19.153 100 19 38 2 1958923552 12364880 5752672
00:57:41 96418 8192000000 10897327920 11371118592 1965994768 19.354 100 18 36 2 1988438656 16493408 5950480
00:59:24 64919 8192000000 10902544352 11388801024 1971417856 19.397 100 14 28 0 2000433872 25108464 3907552
01:00:40 76402 8192000000 10887339136 11366842368 1932304512 19.085 98 20 40 0 1956129232 17284976 6539744
01:02:12 40277 8192000000 10897997072 11366989824 1945487792 19.191 99 13 26 0 1959157056 10280080 3389184
01:02:59 72045 8192000000 10912464672 11376836608 1939267072 19.141 98 18 36 0 1953500464 9034208 5199184
01:04:25 58232 8192000000 10903188528 11373223936 1951323584 19.237 99 12 24 0 1968693808 13526736 3843488
01:05:34 49033 8192000000 10919512960 11386269696 1958377504 19.293 99 25 49 1 1978030000 12308848 7343648
01:06:34 86602 8192000000 10920735104 11396820992 1980737232 19.471 100 21 42 2 2000766208 14185600 5843376
01:08:14 62685 8192000000 10917657328 11386650624 1949956496 19.226 98 20 40 2 1967377760 11662304 5758960
01:09:23 60646 8192000000 10913682768 11364016128 1927382864 19.046 97 37 74 1 1948464704 10507168 10574672
01:10:36 38257 8192000000 10916430128 11391320064 1955638832 19.271 99 36 72 0 1985735232 20738176 9358224
01:11:24 92692 8192000000 10883439776 11361509376 1858910608 18.494 94 19 38 1 1883632768 19063616 5658544
01:13:07 79203 8192000000 10878131056 11350056960 1898331424 18.813 97 7 13 1 1910205120 9954768 1918928
01:14:58 69227 8192000000 10874514272 11342016512 1915279984 18.949 98 30 60 1 1930809232 7046352 8482896
01:18:12 32538 8192000000 10864453904 11339997184 1926717888 19.041 99 32 64 5 1942746480 7504672 8523920
01:18:51 61021 8192000000 10848895264 11326840832 1876220192 18.635 96 8 16 1 1886020944 7410464 2390288
01:19:58 41972 8192000000 10861997984 11332587520 1937385296 19.126 100 6 12 1 1948186896 8987984 1813616
01:20:46 61873 8192000000 10835479808 11317157888 1886344672 18.716 97 22 44 1 1900743840 8627344 5771824
01:22:03 51958 8192000000 10837525248 11319586816 1903840096 18.857 98 16 31 1 1916131072 7279120 5011856
01:23:08 49952 8192000000 10860252016 11341840384 1938741856 19.137 100 12 24 0 1948781056 6853824 3185376
01:24:07 2938 8192000000 10875031824 11331411968 1941217984 19.156 100 21 41 0 1953610208 6451408 5940816
01:24:24 20799 8192000000 10857760352 11331637248 1914057152 18.939 98 22 43 0 1927163376 7286976 5819248
01:26:13 41056 8192000000 10872005776 11348918272 1897559904 18.807 97 18 36 0 1910985632 8127152 5298576
01:27:03 26392 8192000000 9093801936 9313181696 260597696 3.083 14 3 4 1 265108080 4032032 478352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 127 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 24-02-2021 01:29:30 to 24-02-2021 01:29:32.

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

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