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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17353552 kB
MemAvailable 31244612 kB
Buffers 0 kB
Cached 14327708 kB
SwapCached 4868 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-01-29 16:27:10
DTS_END                         2021-01-29 16:27:10.2500
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54100
TRN_ID                          243088
ATT_ID                          673
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: 9399.71 21420 1127965
customer order: creation 175.45 372 21054
customer order: refuse 15.00 336 1800
order to supplier: creation 48.33 1318 5800
order to supplier: removal 3.61 81901 433
invoice (draft): creation 47.89 3255 5747
invoice (draft): removal 53.27 657 6392
invoice accept: apply 42.62 17750 5114
invoice accept: cancel 48.51 784 5821
customer reserve: creation 3894.51 178 467341
customer reserve: removal 4767.83 50 572140
realization accept: apply 85.45 191 10254
realization accept: cancel 85.53 109 10264
payment from customer: creation 60.46 115 7255
payment from customer: removal 5.76 78 691
payment to supplier: creation 49.74 108 5969
payment to supplier: removal 3.60 78 432
service: total inventory turnovers 4.89 1090 587
service: total monetary turnovers 6.43 31 772
service: aggregate perf. data 0.79 21053 95
service: refresh index statistics 0.03 298941 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-01-2021 16:27:49 to 29-01-2021 16:27:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5680
TEST_TIME 2 6030
TEST_TIME 3 6003
TEST_TIME 4 5474
TEST_TIME 5 5236
TEST_TIME 6 4941
TEST_TIME 7 4842
TEST_TIME 8 5248
TEST_TIME 9 5371
TEST_TIME 10 5591
TEST_TIME 11 6580
TEST_TIME 12 6828
TEST_TIME 13 7231
TEST_TIME 14 7970
TEST_TIME 15 8433
TEST_TIME 16 9094
TEST_TIME 17 9179
TEST_TIME 18 10042
TEST_TIME 19 9953
TEST_TIME 20 10263
TEST_TIME 21 10542
TEST_TIME 22 10439
TEST_TIME 23 10412
TEST_TIME 24 10639
TEST_TIME 25 10508
TEST_TIME 26 10804
TEST_TIME 27 10591
TEST_TIME 28 10520
TEST_TIME 29 10321
TEST_TIME 30 10192
TEST_TIME 31 9928
TEST_TIME 32 9765
TEST_TIME 33 9888
TEST_TIME 34 9849
TEST_TIME 35 9735
TEST_TIME 36 9682
TEST_TIME 37 9560
TEST_TIME 38 9544
TEST_TIME 39 9537
TEST_TIME 40 9547
TEST_TIME 41 9615
TEST_TIME 42 9627
TEST_TIME 43 9717
TEST_TIME 44 9715
TEST_TIME 45 9652
TEST_TIME 46 9516
TEST_TIME 47 9561
TEST_TIME 48 9741
TEST_TIME 49 9873
TEST_TIME 50 9878
TEST_TIME 51 9816
TEST_TIME 52 9902
TEST_TIME 53 9946
TEST_TIME 54 9957
TEST_TIME 55 9903
TEST_TIME 56 9744
TEST_TIME 57 9692
TEST_TIME 58 9610
TEST_TIME 59 9610
TEST_TIME 60 9535
TEST_TIME 61 9462
TEST_TIME 62 9450
TEST_TIME 63 9456
TEST_TIME 64 9411
TEST_TIME 65 9365
TEST_TIME 66 9374
TEST_TIME 67 9410
TEST_TIME 68 9484
TEST_TIME 69 9454
TEST_TIME 70 9501
TEST_TIME 71 9556
TEST_TIME 72 9552
TEST_TIME 73 9590
TEST_TIME 74 9610
TEST_TIME 75 9638
TEST_TIME 76 9603
TEST_TIME 77 9620
TEST_TIME 78 9545
TEST_TIME 79 9492
TEST_TIME 80 9445
TEST_TIME 81 9428
TEST_TIME 82 9385
TEST_TIME 83 9323
TEST_TIME 84 9281
TEST_TIME 85 9267
TEST_TIME 86 9307
TEST_TIME 87 9275
TEST_TIME 88 9250
TEST_TIME 89 9288
TEST_TIME 90 9275
TEST_TIME 91 9277
TEST_TIME 92 9332
TEST_TIME 93 9312
TEST_TIME 94 9333
TEST_TIME 95 9332
TEST_TIME 96 9417
TEST_TIME 97 9476
TEST_TIME 98 9487
TEST_TIME 99 9512
TEST_TIME 100 9499
TEST_TIME 101 9414
TEST_TIME 102 9423
TEST_TIME 103 9354
TEST_TIME 104 9363
TEST_TIME 105 9385
TEST_TIME 106 9336
TEST_TIME 107 9295
TEST_TIME 108 9284
TEST_TIME 109 9299
TEST_TIME 110 9286
TEST_TIME 111 9272
TEST_TIME 112 9304
TEST_TIME 113 9323
TEST_TIME 114 9309
TEST_TIME 115 9380
TEST_TIME 116 9342
TEST_TIME 117 9419
TEST_TIME 118 9411
TEST_TIME 119 9476
TEST_TIME 120 9400

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-01-2021 16:27:53 to 29-01-2021 16:27:56.

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 1560851 1560851 0 0.00 0 17943 6 0 0
doc_list_biud 1560850 1560850 0 0.00 0 24303 24 0 0
sp_add_invoice_to_stock 5212 5114 98 1.88 24 201525 17750 0 98
sp_cancel_adding_invoice 5821 5821 0 0.00 3 76947 784 0 0
sp_cancel_client_order 1800 1800 0 0.00 4 9468 337 0 0
sp_cancel_customer_reserve 572140 572140 0 0.00 1 24305 50 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 2 5567 79 0 0
sp_cancel_pay_to_supplier 432 432 0 0.00 3 5161 78 0 0
sp_cancel_supplier_invoice 6401 6392 9 0.14 1 16471 657 0 9
sp_cancel_supplier_order 433 433 0 0.00 6 827296 81901 0 0
sp_cancel_write_off 10264 10264 0 0.00 1 15985 109 0 0
sp_client_order 21054 21054 0 0.00 4 24689 373 0 0
sp_customer_reserve 467341 467341 0 0.00 0 37877 179 0 0
sp_fill_shopping_cart 32595 32595 0 0.00 1 31358 43 0 0
sp_fill_shopping_cart_clo_res 467341 467341 0 0.00 0 19251 16 0 0
sp_get_clo_for_invoice 5114 5114 0 0.00 0 24813 312 0 0
sp_kill_cost_storno 17208 17208 0 0.00 0 14884 48 0 0
sp_kill_qstorno_ret_qs2qd 1161369 1161369 0 0.00 0 24299 27 0 0
sp_kill_qty_storno 612218 612218 0 0.00 0 24303 60 0 0
sp_lock_selected_doc 21308 21308 0 0.00 0 7833 6 0 0
sp_make_cost_storno 28592 28592 0 0.00 0 17932 51 0 0
sp_multiply_rows_for_pdistr 28591 28591 0 0.00 0 7438 28 0 0
sp_multiply_rows_for_qdistr 21054 21054 0 0.00 0 21923 192 0 0
sp_pay_from_customer 7255 7255 0 0.00 3 12604 116 0 0
sp_pay_to_supplier 5969 5969 0 0.00 5 17954 108 0 0
sp_payment_common 13223 13223 0 0.00 1 13302 31 0 0
sp_qd_handle_on_cancel_clo 1800 1800 0 0.00 0 9092 297 0 0
sp_qd_handle_on_invoice_upd_sts 10935 10935 0 0.00 0 23902 301 0 0
sp_qd_handle_on_reserve_upd_sts 10254 10254 0 0.00 0 20776 60 0 0
sp_reserve_write_off 10254 10254 0 0.00 7 20810 192 0 0
sp_supplier_invoice 5747 5747 0 0.00 6 80343 3256 0 0
sp_supplier_order 5800 5800 0 0.00 5 32303 1318 0 0
srv_aggregate_perf_data 95 95 0 0.00 2364 517499 21053 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 994 127834 35239 0 0
srv_find_qd_qs_mism 1079363 1079363 0 0.00 0 13600 5 0 0
srv_make_invnt_saldo 587 587 0 0.00 20 48552 1090 0 0
srv_make_money_saldo 772 772 0 0.00 0 6981 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 159649 439823 298942 0 0
t$perf-abend:sp_add_invoice_to_stock 98 98 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5114 5114 0 0.00 0 12891 178 0 0
t$perf-norm:sp_cancel_adding_invoice 454 454 0 0.00 0 6761 79 0 0
t$perf-norm:sp_cancel_client_order 1800 1800 0 0.00 0 2437 14 0 0
t$perf-norm:sp_cancel_customer_reserve 733 733 0 0.00 0 6139 24 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 2313 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 432 432 0 0.00 0 1670 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 1933 12 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 23720 1361 0 0
t$perf-norm:sp_cancel_write_off 998 998 0 0.00 0 4832 8 0 0
t$perf-norm:sp_client_order 21054 21054 0 0.00 0 15703 17 0 0
t$perf-norm:sp_customer_reserve 1041 1041 0 0.00 0 2576 8 0 0
t$perf-norm:sp_pay_from_customer 7255 7255 0 0.00 0 6241 8 0 0
t$perf-norm:sp_pay_to_supplier 5969 5969 0 0.00 0 12296 13 0 0
t$perf-norm:sp_reserve_write_off 10254 10254 0 0.00 0 10362 13 0 0
t$perf-norm:sp_supplier_invoice 5747 5747 0 0.00 0 6429 16 0 0
t$perf-norm:sp_supplier_order 5800 5800 0 0.00 0 4241 12 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 953 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 1269 16 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 7594 30 0 0
t$perf-norm:srv_make_money_saldo 772 772 0 0.00 0 587 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10424 10228 196 1.88 0 5746 17 0 196
v_all_customers 38638 38638 0 0.00 0 158 1 0 0
v_all_suppliers 31730 31730 0 0.00 0 35 1 0 0
v_all_wares 42104 42104 0 0.00 0 43 1 0 0
v_cancel_adding_invoice 908 908 0 0.00 0 223 5 0 0
v_cancel_client_order 3600 3600 0 0.00 0 3086 5 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 895 4 0 0
v_cancel_customer_reserve 1466 1466 0 0.00 0 1058 4 0 0
v_cancel_payment_to_supplier 864 864 0 0.00 0 5147 15 0 0
v_cancel_supplier_invoice 816 798 18 2.20 0 3902 23 0 18
v_cancel_supplier_order 866 866 0 0.00 0 2858 6 0 0
v_cancel_write_off 1996 1996 0 0.00 0 4379 15 0 0
v_max_id_clo_ord 5800 5800 0 0.00 0 3094 2 0 0
v_max_id_clo_res 1041 1041 0 0.00 0 3545 13 0 0
v_max_id_ord_sup 5743 5743 0 0.00 0 6513 6 0 0
v_max_non_paid_invoice 1647 1647 0 0.00 0 547 2 0 0
v_max_non_paid_realizn 3768 3768 0 0.00 0 5168 7 0 0
v_min_id_clo_ord 5800 5800 0 0.00 0 6359 8 0 0
v_min_id_clo_res 1041 1041 0 0.00 0 2328 5 0 0
v_min_id_ord_sup 5743 5743 0 0.00 0 7499 10 0 0
v_min_non_paid_invoice 5969 5969 0 0.00 0 13296 15 0 0
v_min_non_paid_realizn 7254 7254 0 0.00 0 10175 25 0 0
v_our_firm 10438 10438 0 0.00 0 15 1 0 0
v_reserve_write_off 20506 20506 0 0.00 0 5496 7 0 0
x_lock_depdocs_on_canc_invoice 11814 11814 0 0.00 0 13531 91 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 12605 314 0 0
x_make_qstorno_1000_1200 5800 5800 0 0.00 1 32249 1239 0 0
x_make_qstorno_1200_2000 5747 5747 0 0.00 3 80337 3096 0 0
x_make_qstorno_2100_3300 467341 467341 0 0.00 0 32721 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-01-2021 16:27:57 to 29-01-2021 16:28:01.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:20 13219 8192000000 10234121728 10534420480 901144128 9.910 71 59 119 1 923924352 2344496 20435728
13:57:48 36822 8192000000 10344690384 10662670336 1393372752 14.536 100 84 168 0 1425574752 4970016 27231984
13:58:34 24054 8192000000 10381144848 10704445440 1439695824 14.947 100 87 174 0 1474931248 6873472 28361952
13:59:07 31106 8192000000 10413159904 10744045568 1474228064 15.251 100 90 180 1 1511508384 8403248 28877072
13:59:51 20337 8192000000 10449357136 10782502912 1498579984 15.464 100 87 174 0 1534777104 8775680 27421440
14:00:28 17886 8192000000 10465826048 10802753536 1522706512 15.674 100 92 184 0 1561145776 9318288 29120976
14:01:04 14482 8192000000 10486872976 10825871360 1540847280 15.831 100 89 178 2 1578204816 10155120 27202416
14:01:29 15815 8192000000 10494113248 10840838144 1552375728 15.930 100 81 162 0 1587922448 10425792 25120928
14:01:54 16726 8192000000 10523493680 10870050816 1575606032 16.130 100 87 174 0 1613265360 10899120 26760208
14:02:20 18141 8192000000 10535951344 10885824512 1586986912 16.228 100 82 165 1 1623390080 11315888 25087280
14:02:48 15836 8192000000 10560630336 10913394688 1599123616 16.332 100 77 154 0 1633519824 11055488 23340720
14:03:15 11375 8192000000 10562946096 10926587904 1627246816 16.572 100 73 142 2 1658750688 10703760 20800112
14:03:36 8943 8192000000 10586111488 10951974912 1649176832 16.757 100 69 138 0 1680081088 10786880 20117376
14:03:54 11605 8192000000 10611702864 10982207488 1679064256 17.009 100 75 149 2 1711581136 11262720 21254160
14:04:14 10797 8192000000 10642065248 11013054464 1692676720 17.124 100 76 152 0 1727104752 12450160 21977872
14:04:32 6670 8192000000 10646936928 11021242368 1711467248 17.281 100 73 146 3 1744126080 11733216 20925616
14:04:46 9489 8192000000 10671916832 11048476672 1729836912 17.434 100 72 145 1 1762249200 12096768 20315520
14:05:03 5714 8192000000 10672456832 11051692032 1741042016 17.527 100 74 148 3 1774377968 12830160 20505792
14:05:18 4602 8192000000 10688889024 11069075456 1757918128 17.667 100 71 141 1 1789775936 11838128 20019680
14:05:30 2946 8192000000 10706116384 11084238848 1767049696 17.743 100 76 152 0 1801302032 13053072 21199264
14:05:41 3953 8192000000 10713289920 11095580672 1778046720 17.833 100 72 144 0 1810936128 12521552 20367856
14:05:51 3561 8192000000 10726374320 11109122048 1787627088 17.912 100 75 150 0 1821528544 12868080 21033376
14:06:01 4600 8192000000 10724193376 11112185856 1789030512 17.924 100 68 136 0 1820873712 13017264 18825936
14:06:14 3671 8192000000 10753269248 11138998272 1809240368 18.090 100 82 164 0 1846275056 13225840 23808848
14:06:25 2570 8192000000 10747346544 11136143360 1813538720 18.125 100 74 148 1 1847185968 13503712 20143536
14:06:35 2110 8192000000 10768806496 11153616896 1823784080 18.209 100 84 168 0 1861703680 14783728 23135872
14:06:44 1647 8192000000 10771318416 11160281088 1832800576 18.282 100 87 174 0 1871261200 14338016 24122608
14:06:52 2548 8192000000 10774491728 11166621696 1837734112 18.322 100 82 164 2 1873227872 12886192 22607568
14:07:01 1899 8192000000 10789439040 11179122688 1845284240 18.384 100 87 173 1 1883048752 13795616 23968896
14:07:09 1485 8192000000 10789487520 11176771584 1846258576 18.392 100 87 172 0 1884912480 14044368 24609536
14:07:17 2582 8192000000 10785019648 11178385408 1846135120 18.391 100 76 153 1 1880554672 13536640 20882912
14:07:26 2350 8192000000 10796614432 11187306496 1854838400 18.461 100 85 171 1 1891531040 12397216 24295424
14:07:35 2277 8192000000 10799027888 11191377920 1859218688 18.497 100 83 167 2 1895352688 12751360 23382640
14:07:44 4884 8192000000 10802056544 11192127488 1859346320 18.498 100 91 179 0 1897387024 12341440 25699264
14:07:55 1387 8192000000 10798457104 11191570432 1859852928 18.502 100 75 151 1 1892538752 11199248 21486576
14:08:03 8090 8192000000 10791690768 11186847744 1859766416 18.501 100 63 126 1 1889551600 12517312 17267872
14:08:18 3730 8192000000 10786490832 11193262080 1860747568 18.509 100 52 103 2 1886509216 11482304 14279344
14:08:28 3858 8192000000 10793610336 11199533056 1864648480 18.541 100 53 107 0 1889029440 10375904 14005056
14:08:41 3079 8192000000 10795805808 11205328896 1870538192 18.589 100 58 115 2 1897306064 10389680 16378192
14:08:51 4416 8192000000 10788958656 11199008768 1867860304 18.567 100 39 77 1 1887976336 9186080 10929952
14:09:02 3989 8192000000 10796200720 11207106560 1871535792 18.597 100 44 88 1 1893676944 9742768 12398384
14:09:13 3488 8192000000 10791301920 11207544832 1874233680 18.619 100 42 84 0 1895474400 9585136 11655584
14:09:23 4420 8192000000 10792156816 11210534912 1876365968 18.636 100 50 101 2 1899544464 8887072 14291424
14:09:38 6630 8192000000 10792306240 11208093696 1876992240 18.641 100 38 76 2 1895822864 8226608 10604016
14:09:51 9769 8192000000 10783528400 11208818688 1877991120 18.649 100 31 61 2 1893638896 7029648 8618128
14:10:06 8639 8192000000 10784159056 11209134080 1880305600 18.668 100 33 67 0 1895520800 5653216 9561984
14:10:26 70223 8192000000 10810517136 11222646784 1883575392 18.694 100 43 85 3 1905720864 10320016 11825456
14:11:45 5387 8192000000 10791624640 11224674304 1880737888 18.671 100 28 56 0 1896294032 7989824 7566320
14:11:58 7250 8192000000 10804046608 11229413376 1884471728 18.701 100 28 56 1 1899090560 6836416 7782416
14:12:12 4795 8192000000 10801154912 11228315648 1885806992 18.712 100 38 76 0 1904481760 7364672 11310096
14:12:23 5520 8192000000 10806402528 11231907840 1890118032 18.747 100 40 79 0 1909742368 8355088 11269248
14:12:36 7399 8192000000 10801095264 11233632256 1888490352 18.734 100 32 64 1 1904210192 6431856 9287984
14:12:51 5309 8192000000 10816926256 11238105088 1894072560 18.779 100 47 94 0 1915440832 7582592 13785680
14:13:03 6323 8192000000 10804675792 11235282944 1890553552 18.750 100 26 50 2 1904565328 6158336 7853440
14:13:17 6554 8192000000 10813266192 11234697216 1889672944 18.743 100 19 38 3 1900639760 5166400 5800416
14:13:31 5236 8192000000 10819995152 11244208128 1896416448 18.797 100 45 90 4 1918262800 9448176 12398176
14:13:45 6218 8192000000 10806487744 11236130816 1892923392 18.769 100 28 56 2 1906750640 6082832 7744416
14:14:00 16645 8192000000 10806249152 11241578496 1892139040 18.763 100 24 50 1 1905419056 6697344 6582672
14:14:25 7589 8192000000 10808474416 11242762240 1894931888 18.786 100 24 48 0 1908088464 6456848 6699728
14:14:39 12117 8192000000 10817485952 11247788032 1898187328 18.812 100 21 42 2 1909631824 6051856 5392640
14:14:58 22410 8192000000 10803499408 11244908544 1885858320 18.712 99 24 49 0 1898141952 5344736 6938896
14:15:43 29913 8192000000 10850790080 11252383744 1891817856 18.760 99 68 140 1 1917479088 5275360 20385872
14:16:19 9072 8192000000 10812110832 11243655168 1894487472 18.782 100 25 50 2 1908713472 7016864 7209136
14:16:35 9517 8192000000 10823267936 11252813824 1903397824 18.854 100 35 70 0 1920066528 6731728 9936976
14:16:51 7266 8192000000 10823918576 11248664576 1902834576 18.849 100 29 60 4 1917735040 5941920 8958544
14:17:05 4742 8192000000 10814472592 11236974592 1881546512 18.678 99 22 44 2 1892885008 5283536 6054960
14:17:17 7171 8192000000 10804414848 11234942976 1885203072 18.707 100 15 30 0 1895157040 6015712 3938256
14:17:33 4794 8192000000 10831627840 11255492608 1898621104 18.815 100 33 66 0 1918312608 10329776 9361728
14:17:44 8666 8192000000 10768884000 11195858944 1812226720 18.114 96 23 46 1 1824487584 5945648 6315216
14:18:00 5205 8192000000 10782374032 11209375744 1852842736 18.445 99 20 40 0 1864485568 6235408 5407424
14:18:13 6112 8192000000 10759429280 11190587392 1855891584 18.470 100 29 59 0 1870433488 6369680 8172224
14:18:29 5326 8192000000 10766372320 11185778688 1825014880 18.219 98 29 59 2 1844015680 10294768 8706032
14:18:43 9012 8192000000 10747345920 11174694912 1792199232 17.950 97 31 62 1 1811651344 10690240 8761872
14:19:01 8654 8192000000 10752110288 11175428096 1822427888 18.198 99 27 54 2 1836301424 6532208 7341328
14:19:17 9272 8192000000 10720600096 11140374528 1736627856 17.491 95 27 54 3 1754392736 9679440 8085440
14:19:34 18152 8192000000 10665324736 11073544192 1597934528 16.322 89 22 44 0 1610722000 5621968 7165504
14:19:58 53798 8192000000 10640348912 11040301056 1645259952 16.724 94 27 54 0 1657704048 4430608 8013488
14:20:58 12820 8192000000 10643800240 11046899712 1652042704 16.782 95 18 35 0 1662612816 4731008 5839104
14:21:19 9928 8192000000 10704431200 11112345600 1771465008 17.779 99 32 64 1 1787117744 6887696 8765040
14:21:36 4970 8192000000 10726617088 11132801024 1800875984 18.021 100 38 76 3 1819430944 7805008 10749952
14:21:48 4258 8192000000 10721359920 11130236928 1783868832 17.881 99 34 67 2 1800014224 5725168 10420224
14:21:59 8792 8192000000 10732234352 11148500992 1801314384 18.025 99 24 48 1 1813611456 5294224 7002848
14:22:15 9372 8192000000 10738477744 11156639744 1821070496 18.186 100 40 79 1 1838689584 6727584 10891504
14:22:33 7211 8192000000 10741355728 11163566080 1830188512 18.261 100 36 72 0 1847724128 6918128 10617488
14:22:46 7200 8192000000 10772534512 11170983936 1837059792 18.317 100 29 55 3 1849616192 4872784 7683616
14:23:00 5782 8192000000 10744916352 11167072256 1832359120 18.279 100 24 48 1 1846313680 7181344 6773216
14:23:13 5233 8192000000 10751923856 11178946560 1837007088 18.316 100 17 34 0 1847609504 5808480 4793936
14:23:27 7071 8192000000 10760451568 11182534656 1844306160 18.376 100 22 44 2 1855540256 5116272 6117824
14:23:40 8506 8192000000 10760394416 11185692672 1848050752 18.406 100 18 36 1 1858819792 5420928 5348112
14:23:55 9845 8192000000 10754858416 11189276672 1853724432 18.452 100 29 58 0 1867758688 5439504 8594752
14:24:12 8641 8192000000 10778322912 11196149760 1855564320 18.467 100 23 46 2 1868211744 5769472 6877952
14:24:28 10477 8192000000 10768940928 11196731392 1857379120 18.482 100 23 46 1 1870352768 6488576 6485072
14:24:49 59875 8192000000 10775721792 11203809280 1862353104 18.522 100 31 62 1 1877487888 6013504 9121280
14:25:57 15471 8192000000 10771782784 11211988992 1869669232 18.582 100 21 42 0 1881373792 5707120 5997440
14:26:23 8275 8192000000 10796450464 11217772544 1875114448 18.626 100 21 42 2 1887857264 6020560 6722256
14:26:37 7517 8192000000 10793401504 11220254720 1882468448 18.685 100 43 86 1 1900871264 5916688 12486128
14:26:52 5276 8192000000 10794263968 11219755008 1876861792 18.640 100 25 50 1 1889644032 5761584 7020656
14:27:03 8553 8192000000 10821002096 11234258944 1886829808 18.720 100 27 52 0 1900263040 5581184 7852048
14:27:21 23217 8192000000 10830350304 11255566336 1908646848 18.896 100 42 83 0 1928162064 6782208 12733008
14:27:52 30021 8192000000 10851819344 11273007104 1921865312 19.002 100 51 100 3 1943397392 7138640 14393440
14:28:50 16938 8192000000 10870435344 11290931200 1936873280 19.122 100 57 115 0 1963255744 9677296 16705168
14:29:14 18411 8192000000 10886392640 11308417024 1949387456 19.222 100 55 109 1 1978014624 13197584 15429584
14:29:39 5415 8192000000 10890620528 11312971776 1951795168 19.241 100 63 125 0 1983804544 13404144 18605232
14:29:52 7104 8192000000 10896155856 11319713792 1955128544 19.267 100 60 120 1 1989635872 17761840 16745488
14:30:08 14206 8192000000 10896269840 11322216448 1960073616 19.307 100 53 106 0 1988285760 12940864 15271280
14:30:32 8362 8192000000 10904346576 11328970752 1961899152 19.321 100 53 105 3 1996112464 18351984 15861328
14:30:50 76714 8192000000 10896830480 11331846144 1960495424 19.310 100 41 81 2 1987541136 13685360 13360352
14:32:28 20912 8192000000 10896200976 11335106560 1971221456 19.395 100 32 64 1 1996121312 14844240 10055616
14:32:57 26715 8192000000 10914777968 11350712320 1976076528 19.434 100 38 76 0 2004202544 16304176 11821840
14:33:34 59620 8192000000 10942711552 11381686272 1986059952 19.513 100 31 62 1 2018845792 22868224 9917616
14:34:51 8313 8192000000 10953796992 11385683968 2000816480 19.629 100 45 90 0 2039538144 24007680 14713984
14:35:07 11240 8192000000 10954530656 11388284928 2010688064 19.707 100 50 99 0 2050651280 24747136 15216080
14:35:29 5516 8192000000 10964145184 11390709760 2011071136 19.710 100 64 127 2 2054023984 22888112 20064736
14:35:41 5537 8192000000 10943438416 11369238528 1990032608 19.544 99 50 100 1 2029743296 24008464 15702224
14:36:08 12650 8192000000 10954501584 11389411328 2008857552 19.693 100 55 108 3 2050724048 25367056 16499440
14:36:29 11202 8192000000 10958358032 11380154368 1989061184 19.536 99 65 128 1 2033118448 24303584 19753680
14:36:53 11579 8192000000 10948974912 11375333376 1986556656 19.517 99 58 116 1 2030209920 25874368 17778896
14:37:13 2062 8192000000 10962305232 11392598016 2006480016 19.674 100 68 134 3 2054921520 26673008 21768496
14:37:24 6274 8192000000 10987308416 11406295040 2015852112 19.748 100 81 162 0 2071605904 30202688 25551104
14:37:38 4363 8192000000 10973623616 11400163328 2010597664 19.706 100 75 150 0 2065374704 31903488 22873552
14:37:51 2489 8192000000 10980811280 11410575360 2012584464 19.722 100 73 145 1 2071262880 36147648 22530768
14:38:02 5088 8192000000 10959734816 11387912192 1985520976 19.508 99 66 132 0 2037517232 32047376 19948880
14:38:14 3810 8192000000 10969171056 11395407872 2004247760 19.656 100 70 138 1 2056336576 31015168 21073648
14:38:25 3228 8192000000 10972099392 11397517312 2009456944 19.697 100 77 152 2 2061164032 28514016 23193072
14:38:35 1488 8192000000 10988137600 11405348864 2014338128 19.736 100 87 169 0 2067487488 28063584 25085776
14:38:45 2025 8192000000 10971033712 11387617280 1989240112 19.538 99 85 166 0 2042868496 29184080 24444304
14:38:53 2342 8192000000 10965306368 11390263296 1999520304 19.619 100 84 166 2 2053617936 28241760 25855872
14:39:03 5586 8192000000 10932799520 11350237184 1948923392 19.218 98 74 149 1 1999938720 27635440 23379888
14:39:15 1489 8192000000 10945239152 11362852864 1980820880 19.471 100 80 158 1 2033050624 28497472 23732272
14:39:24 993 8192000000 10971231744 11380441088 1990528656 19.548 100 93 187 1 2049371840 30688432 28154752
14:39:33 4813 8192000000 10954195312 11375341568 1987543888 19.524 100 74 147 2 2040833968 31135648 22154432
14:39:58 6081 8192000000 10949920576 11373256704 1966687856 19.359 99 64 128 1 2018108784 31549168 19871760
14:40:11 5451 8192000000 10966576944 11386503168 1985486656 19.508 100 71 140 3 2041203440 33502128 22214656
14:40:24 3908 8192000000 10963948320 11388755968 1988820896 19.534 100 74 145 2 2047642176 36529456 22291824
14:40:35 2418 8192000000 10973551312 11392036864 1989367200 19.539 100 86 172 1 2055574560 39306128 26901232
14:40:44 1476 8192000000 10975742240 11396599808 1995712432 19.589 100 85 170 1 2063340144 39589456 28038256
14:40:53 1902 8192000000 10982782896 11397505024 1981907904 19.480 99 92 183 0 2050724656 40701248 28115504
14:41:02 1775 8192000000 10968885696 11388628992 1994749184 19.581 100 86 173 0 2058808640 37753264 26306192
14:41:13 6181 8192000000 10970268816 11389693952 1990679760 19.549 100 73 144 0 2051815840 37764352 23371728
14:41:26 5316 8192000000 10980153344 11407192064 1995294528 19.586 100 69 137 0 2054824720 37635296 21894896
14:41:39 3823 8192000000 10948577904 11375943680 1975715280 19.431 100 74 148 0 2034778560 36223776 22839504
14:41:51 2075 8192000000 10929203392 11345244160 1946831424 19.201 99 82 162 3 2006170704 34172784 25166496
14:42:01 2411 8192000000 10947876256 11367481344 1967784256 19.368 100 76 152 0 2030238064 39367008 23086800
14:42:11 1382 8192000000 10941621088 11352973312 1954646352 19.263 99 86 171 0 2017929152 37959136 25323664
14:42:19 4037 8192000000 10942031536 11364167680 1964470976 19.342 100 63 126 0 2022326960 38278000 19577984
14:42:33 7884 8192000000 10945331056 11363934208 1962329248 19.325 100 71 141 1 2023759232 40169232 21260752
14:42:47 4754 8192000000 10938820064 11366637568 1966615840 19.359 100 73 145 1 2030863168 41739456 22507872
14:43:13 25066 8192000000 10910078320 11355893760 1942307520 19.165 99 33 65 2 1982000864 29390176 10303168
14:43:45 8965 8192000000 10919861360 11358388224 1963116000 19.331 100 36 72 2 2003457440 28986800 11354640
14:44:01 7823 8192000000 10913896848 11356688384 1957362640 19.285 100 43 86 0 1999914448 29168320 13383488
14:44:15 9310 8192000000 10899008288 11351887872 1950137360 19.228 100 35 70 3 1997161680 35469888 11554432
14:44:42 17548 8192000000 10880392944 11326386176 1896904944 18.801 97 23 46 2 1934273712 29909968 7458800
14:45:13 16223 8192000000 10880026944 11322068992 1891230176 18.756 98 26 52 2 1933041472 33364448 8446848
14:45:36 7361 8192000000 10888208752 11326771200 1913943776 18.938 99 30 58 1 1956137408 32690992 9502640
14:45:49 26637 8192000000 10873718800 11320066048 1878568816 18.654 97 20 38 5 1908266944 23327264 6370864
14:46:22 24021 8192000000 10875826368 11317227520 1906335824 18.877 99 23 46 0 1938827216 24965536 7525856
14:46:54 20278 8192000000 10865733600 11309424640 1874033872 18.617 97 25 50 0 1910252832 27716016 8502944
14:47:25 13913 8192000000 10848922688 11290550272 1845870080 18.389 96 22 44 0 1878646976 25277104 7499792
14:47:46 14069 8192000000 10838437376 11282432000 1867136992 18.561 98 43 84 1 1907792432 27102640 13552800
14:48:07 28775 8192000000 10857592432 11299127296 1907885408 18.890 100 21 43 1 1937837760 22852224 7100128
14:48:48 21073 8192000000 10855318416 11307569152 1902524992 18.847 99 14 28 0 1925801136 18999872 4276272
14:49:39 34894 8192000000 10879907312 11322085376 1917045968 18.963 99 29 58 0 1949142736 23486768 8610000
14:50:41 26409 8192000000 10827330720 11273711616 1879667056 18.662 98 27 54 0 1914445648 26578176 8200416
14:52:02 10089 8192000000 10840646352 11285786624 1900318768 18.829 100 25 50 1 1928180928 20223632 7638528
14:52:19 2645 8192000000 10838790176 11286491136 1899023520 18.818 100 12 24 0 1923990992 21133136 3834336
14:52:33 20352 8192000000 10816494064 11264520192 1863472160 18.531 98 19 38 0 1892160384 22705616 5982608
14:53:06 7297 8192000000 10834779520 11287592960 1894707024 18.784 100 14 28 0 1925131616 25980128 4444464
14:53:20 29586 8192000000 10826112416 11283460096 1894926592 18.785 100 11 22 0 1918223312 19461424 3835296
14:53:55 52545 8192000000 10815131936 11273445376 1880883072 18.672 99 10 20 0 1892068784 8215024 2970688
14:55:04 32205 8192000000 10830684336 11275096064 1853161408 18.448 97 27 54 1 1870925600 9101984 8662208
14:55:56 60144 8192000000 10828548640 11277832192 1888124768 18.731 99 12 24 0 1901494128 9297952 4071408
14:57:24 102422 8192000000 10869749632 11307286528 1915321488 18.949 99 30 60 0 1930373504 6495920 8556096
14:59:31 43850 8192000000 10874580768 11304620032 1916093696 18.956 99 53 106 1 1944490912 13286912 15110304
15:00:23 44836 8192000000 10883665072 11315068928 1931065232 19.075 100 42 83 0 1955858816 12943200 11850384
15:01:15 51266 8192000000 10863463456 11322273792 1926965488 19.043 99 20 40 0 1945699680 13317920 5416272
15:02:38 44193 8192000000 10866911248 11321786368 1925330960 19.030 99 15 30 3 1946107616 16185872 4590784
15:03:30 44394 8192000000 10873078896 11331661824 1945207792 19.188 100 19 38 1 1964615600 14025248 5382560
15:04:24 1861 8192000000 10911575968 11341299712 1962219296 19.324 100 69 140 3 1995508544 12498160 20791088
15:04:33 13486 8192000000 10915357424 11336421376 1952662464 19.248 99 66 132 0 1992435456 20499120 19273872
15:04:54 16588 8192000000 10906412496 11348881408 1963900832 19.337 100 56 112 1 2001571504 21449120 16221552
15:05:25 28745 8192000000 10901277856 11345948672 1939690464 19.144 99 36 72 0 1976490000 26483360 10316176
15:06:01 40225 8192000000 10878435088 11334672384 1938419568 19.134 99 27 52 1 1971521760 24446640 8655552
15:06:47 58913 8192000000 10880372304 11353579520 1951881824 19.241 100 14 28 0 1984433280 27933808 4617648
15:08:20 70817 8192000000 10881446880 11364962304 1961634576 19.319 100 17 34 0 1995283056 28345088 5303392
15:09:44 82168 8192000000 10884791616 11357564928 1924302688 19.021 98 10 19 1 1942870896 15651280 2916928
15:11:13 53301 8192000000 10899409168 11362865152 1964423712 19.341 100 11 22 0 1977783424 10067696 3292016
15:12:12 54227 8192000000 10890092704 11349901312 1957187328 19.284 99 17 34 1 1975135088 13092384 4855376
15:13:13 27086 8192000000 10923125168 11371302912 1979921408 19.464 100 41 81 1 2004826880 12845184 12060288
15:13:53 17302 8192000000 10941002320 11386568704 1994084848 19.576 100 63 126 1 2030763248 17408256 19270144
15:14:16 65335 8192000000 10921979648 11392016384 1985117584 19.505 100 17 34 0 2012456784 22023168 5316032
15:15:31 76724 8192000000 10904032576 11358289920 1934164912 19.100 98 7 14 0 1955879024 19697744 2016368
15:17:00 82434 8192000000 10902305616 11360006144 1936219776 19.117 98 19 38 0 1956517328 15136176 5161376
15:18:30 47531 8192000000 10931753328 11376545792 1978668496 19.454 100 36 72 1 1998585728 9846864 10070368
15:19:24 66327 8192000000 10899757504 11379449856 1959363056 19.301 99 33 66 2 1985866912 16940992 9562864
15:20:37 127834 8192000000 10897600336 11341950976 1861769968 18.518 94 10 20 0 1877894768 13372672 2752128
15:22:52 101684 8192000000 10873893136 11331158016 1940725808 19.153 99 43 85 0 1962579344 9456096 12397440
15:24:41 66851 8192000000 10913477040 11360337920 1954605280 19.263 99 44 88 0 1980824880 13732688 12486912
15:25:55 17493 8192000000 10893298080 11354902528 1967406448 19.365 100 30 60 0 1985270080 9638432 8225200
15:26:18 21127 8192000000 10885601392 11346178048 1946658512 19.200 99 17 34 0 1959286464 7993392 4634560
15:26:50 64708 8192000000 10867217488 11331821568 1889248848 18.740 96 15 30 0 1899996912 6676624 4071440
15:28:11 73085 8192000000 10864017264 11331620864 1905145312 18.868 97 21 40 1 1919879776 8873200 5861264
15:29:52 63736 8192000000 10842979632 11316801536 1914807200 18.945 98 10 21 1 1931089008 13260352 3021456
15:31:12 61231 8192000000 10855321296 11323748352 1888155696 18.731 97 21 42 1 1902458656 8910576 5392384
15:32:22 40284 8192000000 10884598208 11334918144 1908166448 18.892 98 22 44 0 1925232224 10790736 6275040
15:33:09 42688 8192000000 10882652528 11343003648 1925405648 19.030 98 30 60 2 1950967136 17124368 8437120
15:33:59 20208 8192000000 10862849216 11301027840 1840023968 18.341 94 39 78 2 1862744752 11688992 11031792
15:34:28 40933 8192000000 10819472288 11279282176 1872399632 18.604 98 27 54 0 1892797072 12787504 7609936
15:35:20 37415 8192000000 10864606320 11296829440 1871532528 18.597 97 33 64 1 1888534512 8754624 8247360
15:36:17 20985 8192000000 10877069520 11309449216 1885977920 18.713 98 35 70 0 1904900432 9573408 9349104
15:36:45 18233 8192000000 10869547072 11298832384 1870181504 18.586 97 62 122 0 1900096480 13427408 16487568
15:37:11 16011 8192000000 10861871664 11300098048 1897961424 18.810 99 58 116 1 1927925008 13815840 16147744
15:37:43 63545 8192000000 10849910080 11291713536 1842906752 18.364 96 32 64 0 1868181344 16329472 8945120
15:38:57 24216 8192000000 10850747520 11299061760 1899214080 18.820 99 41 82 4 1919960240 8756832 11989328
15:39:29 54362 8192000000 10843160144 11314515968 1902638528 18.848 99 16 32 0 1918953936 11572832 4742576
15:40:30 62736 8192000000 10846939248 11307245568 1865951248 18.552 97 17 34 1 1882178608 11767824 4459536
15:41:42 94969 8192000000 10858190256 11293814784 1805259200 18.057 94 29 59 0 1825831392 11112496 9459696
15:43:25 32717 8192000000 10874876400 11318411264 1910101792 18.907 99 37 74 2 1929696880 9369584 10225504
15:44:10 24419 8192000000 10893001936 11328176128 1900828496 18.833 98 43 86 0 1925616304 12970720 11817088
15:44:43 28485 8192000000 10897509504 11335299072 1940649328 19.152 100 51 102 1 1969194864 14166304 14379232
15:45:21 94726 8192000000 10842594816 11294728192 1904796256 18.865 98 32 64 2 1925304976 11276192 9232528
15:47:03 50861 8192000000 10880932464 11329294336 1890164320 18.747 97 48 95 1 1917785280 14156816 13464144
15:48:09 11484 8192000000 10875582912 11329454080 1937379312 19.126 100 37 74 0 1963836288 16163392 10293584
15:48:27 6874 8192000000 10859930272 11316887552 1926602976 19.040 100 32 64 2 1950681136 15414320 8663840
15:48:46 39585 8192000000 10838577360 11308793856 1917115504 18.964 99 23 44 1 1935356144 11938224 6302416
15:49:34 59067 8192000000 10863411248 11331555328 1946509888 19.199 100 13 26 1 1957999056 7793072 3696096
15:50:39 67087 8192000000 10879629168 11349663744 1953955776 19.258 100 12 24 0 1965867776 8428016 3483984
15:51:53 77553 8192000000 10867138672 11354132480 1938280208 19.133 99 14 28 0 1954053520 11638400 4134912
15:53:21 81482 8192000000 10875495232 11345854464 1937767296 19.129 99 11 22 1 1949076368 8500112 2808960
15:54:51 26114 8192000000 10907299536 11361787904 1975738080 19.431 100 41 82 0 1995994080 7940096 12315904
15:55:28 49058 8192000000 10895287728 11365175296 1955780832 19.272 99 23 44 5 1972361360 9903728 6676800
15:56:36 73310 8192000000 10907323984 11374845952 1959193088 19.300 99 14 28 1 1974421776 11826368 3402320
15:58:00 48803 8192000000 10902689408 11365335040 1971973392 19.401 99 28 56 1 1990132384 10384240 7774752
15:59:01 76066 8192000000 10920515104 11378954240 1946852240 19.201 98 24 48 1 1966299984 13091344 6356400
16:00:24 110781 8192000000 10944144944 11413168128 2000659968 19.628 100 16 32 2 2022928944 17420736 4848240
16:02:23 101963 8192000000 10930144768 11419271168 1942591184 19.167 97 17 34 2 1973024848 25072384 5361280
16:05:41 107727 8192000000 10909977312 11380469760 1946904912 19.202 98 10 20 2 1962940736 13344480 2691344
16:07:36 112111 8192000000 10922224224 11377029120 1969799472 19.384 99 26 52 0 1989002320 11783264 7419584
16:09:37 79107 8192000000 10902933568 11357458432 1887708032 18.727 95 20 40 3 1899733024 7167056 4857936
16:11:03 66600 8192000000 10895722352 11377033216 1962434272 19.325 99 28 56 1 1985131648 14320192 8377184
16:13:49 85506 8192000000 10866735408 11340091392 1874467888 18.620 95 9 18 1 1887762960 10721744 2573328
16:15:25 63796 8192000000 10879331904 11361517568 1937208432 19.124 99 13 26 0 1953698528 12032928 4457168
16:16:40 56984 8192000000 10860755104 11326763008 1872933008 18.608 96 9 18 0 1883368224 8173664 2261552
16:17:51 32936 8192000000 10842941808 11310768128 1893338416 18.773 97 24 49 2 1908106912 8365376 6403120
16:18:31 48747 8192000000 10886216224 11350769664 1935375392 19.110 99 22 44 2 1951678576 10005888 6297296
16:19:41 79176 8192000000 10890584928 11364470784 1945973536 19.194 99 17 34 0 1967825392 16762448 5089408
16:21:08 84558 8192000000 10900654192 11371540480 1914585024 18.943 97 18 36 0 1932035952 12330752 5120176
16:22:42 77343 8192000000 10895906720 11367899136 1910153152 18.908 97 13 26 1 1931269376 17250160 3866064
16:24:24 51299 8192000000 10892086832 11341340672 1893592240 18.775 97 32 64 1 1920091248 16611072 9887936
16:25:23 68439 8192000000 10856636032 11328294912 1858924672 18.495 96 29 58 1 1880901152 13891840 8084640
16:26:40 41796 8192000000 9157470704 9383358464 310666272 3.653 17 2 4 0 317516224 6505456 344496

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 98 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

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          243937
MON$OLDEST_ACTIVE               243938
MON$OLDEST_SNAPSHOT             243938
MON$NEXT_TRANSACTION            243938
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                       2004096
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:174: 
:175: mscs-test-161.budzdorov.ru    Fri Jan 29 16:27:24 2021
:176:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:177: 
:178: 
:179: mscs-test-161.budzdorov.ru    Fri Jan 29 16:27:24 2021
:180:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:181: 
--- end of diff output ---

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

29.01.21 16:28:38. 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-01-29 16:28:41 No severe PSQL-related problems occured
29.01.21 16:28:42. End of report.