Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.01.2021 01: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 17310468 kB
MemAvailable 31323624 kB
Buffers 0 kB
Cached 14364188 kB
SwapCached 4864 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-15 01:27:11
DTS_END                         2021-01-15 01:27:11.5940
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55214
TRN_ID                          234326
ATT_ID                          685
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: 9245.04 21492 1109405
customer order: creation 167.43 350 20091
customer order: refuse 14.48 354 1738
order to supplier: creation 43.33 1273 5199
order to supplier: removal 3.29 120917 395
invoice (draft): creation 44.49 3581 5339
invoice (draft): removal 52.87 976 6344
invoice accept: apply 40.79 17332 4895
invoice accept: cancel 48.13 717 5775
customer reserve: creation 3821.71 167 458605
customer reserve: removal 4713.78 65 565654
realization accept: apply 81.55 201 9786
realization accept: cancel 87.65 108 10518
payment from customer: creation 56.96 143 6835
payment from customer: removal 5.51 107 661
payment to supplier: creation 48.30 131 5796
payment to supplier: removal 3.13 96 375
service: total inventory turnovers 4.23 1406 508
service: total monetary turnovers 6.57 19 788
service: aggregate perf. data 0.83 22585 99
service: refresh index statistics 0.03 259315 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-01-2021 01:27:51 to 15-01-2021 01:27:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1699
TEST_TIME 2 4773
TEST_TIME 3 5497
TEST_TIME 4 5086
TEST_TIME 5 4958
TEST_TIME 6 5114
TEST_TIME 7 5296
TEST_TIME 8 5071
TEST_TIME 9 5276
TEST_TIME 10 5337
TEST_TIME 11 5454
TEST_TIME 12 5896
TEST_TIME 13 6205
TEST_TIME 14 6710
TEST_TIME 15 6614
TEST_TIME 16 6756
TEST_TIME 17 7248
TEST_TIME 18 7397
TEST_TIME 19 7743
TEST_TIME 20 7971
TEST_TIME 21 8043
TEST_TIME 22 8304
TEST_TIME 23 8379
TEST_TIME 24 8749
TEST_TIME 25 9040
TEST_TIME 26 9742
TEST_TIME 27 11316
TEST_TIME 28 11688
TEST_TIME 29 11318
TEST_TIME 30 11255
TEST_TIME 31 11114
TEST_TIME 32 10936
TEST_TIME 33 10638
TEST_TIME 34 10418
TEST_TIME 35 10259
TEST_TIME 36 10187
TEST_TIME 37 9995
TEST_TIME 38 9871
TEST_TIME 39 9874
TEST_TIME 40 9879
TEST_TIME 41 9846
TEST_TIME 42 9730
TEST_TIME 43 9756
TEST_TIME 44 9670
TEST_TIME 45 9666
TEST_TIME 46 9783
TEST_TIME 47 9696
TEST_TIME 48 9507
TEST_TIME 49 9647
TEST_TIME 50 9540
TEST_TIME 51 9534
TEST_TIME 52 9469
TEST_TIME 53 9373
TEST_TIME 54 9288
TEST_TIME 55 9273
TEST_TIME 56 9196
TEST_TIME 57 9193
TEST_TIME 58 9165
TEST_TIME 59 9192
TEST_TIME 60 9178
TEST_TIME 61 9194
TEST_TIME 62 9223
TEST_TIME 63 9243
TEST_TIME 64 9269
TEST_TIME 65 9306
TEST_TIME 66 9323
TEST_TIME 67 9323
TEST_TIME 68 9427
TEST_TIME 69 9384
TEST_TIME 70 9363
TEST_TIME 71 9488
TEST_TIME 72 9450
TEST_TIME 73 9402
TEST_TIME 74 9315
TEST_TIME 75 9317
TEST_TIME 76 9301
TEST_TIME 77 9250
TEST_TIME 78 9254
TEST_TIME 79 9258
TEST_TIME 80 9255
TEST_TIME 81 9219
TEST_TIME 82 9157
TEST_TIME 83 9093
TEST_TIME 84 9185
TEST_TIME 85 9161
TEST_TIME 86 9136
TEST_TIME 87 9102
TEST_TIME 88 9163
TEST_TIME 89 9158
TEST_TIME 90 9238
TEST_TIME 91 9277
TEST_TIME 92 9300
TEST_TIME 93 9295
TEST_TIME 94 9300
TEST_TIME 95 9392
TEST_TIME 96 9355
TEST_TIME 97 9355
TEST_TIME 98 9404
TEST_TIME 99 9375
TEST_TIME 100 9416
TEST_TIME 101 9328
TEST_TIME 102 9325
TEST_TIME 103 9308
TEST_TIME 104 9276
TEST_TIME 105 9283
TEST_TIME 106 9246
TEST_TIME 107 9221
TEST_TIME 108 9212
TEST_TIME 109 9214
TEST_TIME 110 9183
TEST_TIME 111 9215
TEST_TIME 112 9212
TEST_TIME 113 9218
TEST_TIME 114 9236
TEST_TIME 115 9295
TEST_TIME 116 9295
TEST_TIME 117 9294
TEST_TIME 118 9258
TEST_TIME 119 9306
TEST_TIME 120 9246

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-01-2021 01:27:55 to 15-01-2021 01:27:58.

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 1533320 1533320 0 0.00 0 17549 6 0 0
doc_list_biud 1533320 1533320 0 0.00 0 27106 31 0 0
sp_add_invoice_to_stock 5042 4895 147 2.91 42 210021 17333 0 147
sp_cancel_adding_invoice 5775 5775 0 0.00 5 59350 718 0 0
sp_cancel_client_order 1738 1738 0 0.00 4 25974 354 0 0
sp_cancel_customer_reserve 565654 565654 0 0.00 1 25318 65 0 0
sp_cancel_pay_from_customer 661 661 0 0.00 3 12628 107 0 0
sp_cancel_pay_to_supplier 375 375 0 0.00 2 9433 96 0 0
sp_cancel_supplier_invoice 6352 6344 8 0.12 2 17063 977 0 8
sp_cancel_supplier_order 395 395 0 0.00 8 1226390 120917 0 0
sp_cancel_write_off 10518 10518 0 0.00 1 16520 109 0 0
sp_client_order 20091 20091 0 0.00 3 20045 350 0 0
sp_customer_reserve 458605 458605 0 0.00 0 80284 168 0 0
sp_fill_shopping_cart 30607 30607 0 0.00 1 17063 40 0 0
sp_fill_shopping_cart_clo_res 458600 458600 0 0.00 0 26860 14 0 0
sp_get_clo_for_invoice 4889 4889 0 0.00 0 36494 350 0 0
sp_kill_cost_storno 17329 17329 0 0.00 0 16518 58 0 0
sp_kill_qstorno_ret_qs2qd 1148565 1148565 0 0.00 0 25312 36 0 0
sp_kill_qty_storno 605098 605098 0 0.00 0 27105 77 0 0
sp_lock_selected_doc 20256 20256 0 0.00 0 9688 6 0 0
sp_make_cost_storno 27305 27305 0 0.00 0 17545 55 0 0
sp_multiply_rows_for_pdistr 27305 27305 0 0.00 0 12631 38 0 0
sp_multiply_rows_for_qdistr 20091 20091 0 0.00 0 16629 153 0 0
sp_pay_from_customer 6835 6835 0 0.00 4 58321 143 0 0
sp_pay_to_supplier 5796 5796 0 0.00 5 17557 132 0 0
sp_payment_common 12631 12631 0 0.00 1 56787 47 0 0
sp_qd_handle_on_cancel_clo 1738 1738 0 0.00 0 25961 316 0 0
sp_qd_handle_on_invoice_upd_sts 10663 10663 0 0.00 0 27104 345 0 0
sp_qd_handle_on_reserve_upd_sts 9786 9786 0 0.00 0 14176 65 0 0
sp_reserve_write_off 9786 9786 0 0.00 6 14218 201 0 0
sp_supplier_invoice 5339 5339 0 0.00 6 77768 3581 0 0
sp_supplier_order 5199 5199 0 0.00 5 57882 1274 0 0
srv_aggregate_perf_data 99 99 0 0.00 2516 847730 22585 0 0
srv_fill_mon_cache_memory 151 151 0 0.00 1343 138072 35488 0 0
srv_find_qd_qs_mism 1062389 1062389 0 0.00 0 12324 5 0 0
srv_make_invnt_saldo 508 508 0 0.00 41 151928 1407 0 0
srv_make_money_saldo 788 788 0 0.00 0 278 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 156928 407516 259315 0 0
t$perf-abend:sp_add_invoice_to_stock 147 147 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4895 4895 0 0.00 0 14424 172 0 0
t$perf-norm:sp_cancel_adding_invoice 383 383 0 0.00 0 10097 133 0 0
t$perf-norm:sp_cancel_client_order 1738 1738 0 0.00 0 3754 16 0 0
t$perf-norm:sp_cancel_customer_reserve 693 693 0 0.00 0 645 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 661 661 0 0.00 0 11869 23 0 0
t$perf-norm:sp_cancel_pay_to_supplier 375 375 0 0.00 0 582 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 375 375 0 0.00 0 2388 16 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 31170 1680 0 0
t$perf-norm:sp_cancel_write_off 962 962 0 0.00 0 8309 17 0 0
t$perf-norm:sp_client_order 20091 20091 0 0.00 0 6784 18 0 0
t$perf-norm:sp_customer_reserve 1014 1014 0 0.00 0 1414 6 0 0
t$perf-norm:sp_pay_from_customer 6835 6835 0 0.00 0 8683 13 0 0
t$perf-norm:sp_pay_to_supplier 5796 5796 0 0.00 0 4732 11 0 0
t$perf-norm:sp_reserve_write_off 9786 9786 0 0.00 0 5308 11 0 0
t$perf-norm:sp_supplier_invoice 5339 5339 0 0.00 0 8331 22 0 0
t$perf-norm:sp_supplier_order 5199 5199 0 0.00 0 4158 15 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 179 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 7573 51 0 0
t$perf-norm:srv_make_invnt_saldo 508 508 0 0.00 0 5834 36 0 0
t$perf-norm:srv_make_money_saldo 788 788 0 0.00 0 1010 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 12 6 0 0
v_add_invoice_to_stock 10070 9776 294 2.91 0 5442 19 0 294
v_all_customers 36564 36564 0 0.00 0 16 1 0 0
v_all_suppliers 29606 29606 0 0.00 0 17 1 0 0
v_all_wares 40182 40182 0 0.00 0 93 1 0 0
v_cancel_adding_invoice 766 766 0 0.00 0 1106 7 0 0
v_cancel_client_order 3476 3476 0 0.00 0 5205 9 0 0
v_cancel_customer_prepayment 1322 1322 0 0.00 0 3236 12 0 0
v_cancel_customer_reserve 1386 1386 0 0.00 0 3152 5 0 0
v_cancel_payment_to_supplier 750 750 0 0.00 0 862 5 0 0
v_cancel_supplier_invoice 766 750 16 2.08 0 1348 17 0 16
v_cancel_supplier_order 790 790 0 0.00 0 1087 5 0 0
v_cancel_write_off 1924 1924 0 0.00 0 4481 20 0 0
v_max_id_clo_ord 5199 5199 0 0.00 0 4111 3 0 0
v_max_id_clo_res 1014 1014 0 0.00 0 7298 21 0 0
v_max_id_ord_sup 5316 5316 0 0.00 0 3248 3 0 0
v_max_non_paid_invoice 1508 1508 0 0.00 0 389 2 0 0
v_max_non_paid_realizn 3654 3654 0 0.00 0 3763 6 0 0
v_min_id_clo_ord 5199 5199 0 0.00 0 2796 7 0 0
v_min_id_clo_res 1014 1014 0 0.00 0 4903 9 0 0
v_min_id_ord_sup 5316 5316 0 0.00 0 8744 7 0 0
v_min_non_paid_invoice 5796 5796 0 0.00 0 12644 27 0 0
v_min_non_paid_realizn 6835 6835 0 0.00 0 56781 35 0 0
v_our_firm 9980 9980 0 0.00 0 14 1 0 0
v_reserve_write_off 19572 19572 0 0.00 0 4380 8 0 0
x_lock_depdocs_on_canc_invoice 11744 11744 0 0.00 0 29179 119 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 15813 408 0 0
x_make_qstorno_1000_1200 5199 5199 0 0.00 2 57873 1199 0 0
x_make_qstorno_1200_2000 5339 5339 0 0.00 3 77752 3424 0 0
x_make_qstorno_2100_3300 458605 458605 0 0.00 0 80282 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-01-2021 01:27:59 to 15-01-2021 01:28:03.

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:15 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:21 19456 8192000000 10244166944 10552328192 928199200 10.177 71 59 118 0 951229344 2680272 20349872
22:57:49 32732 8192000000 10337405488 10652430336 1364462416 14.277 100 86 172 0 1397732560 4257232 29012912
22:58:29 18575 8192000000 10360016432 10681360384 1415747328 14.735 100 82 164 0 1448685312 5845680 27092304
22:58:55 25409 8192000000 10384473008 10711416832 1437492992 14.928 100 90 180 0 1473344496 6219696 29631808
22:59:29 24918 8192000000 10406510976 10735054848 1460984384 15.135 100 85 170 0 1496192176 7216656 27991136
23:00:12 25149 8192000000 10437772992 10768838656 1489573648 15.385 100 88 176 0 1526119152 8076176 28469328
23:00:55 15248 8192000000 10464015328 10799976448 1509194032 15.556 100 84 168 0 1543691568 8374128 26123408
23:01:22 18485 8192000000 10481690000 10826379264 1547391808 15.887 100 88 175 2 1584568800 9496192 27680800
23:01:53 15006 8192000000 10507064000 10857275392 1565527264 16.044 100 81 162 0 1600154976 9599872 25027840
23:02:24 17009 8192000000 10543521952 10905792512 1604767840 16.380 100 69 137 1 1634177104 9132880 20276384
23:02:54 9931 8192000000 10574444576 10936078336 1637107072 16.655 100 73 146 2 1668965616 10507584 21350960
23:03:11 15289 8192000000 10598104544 10965516288 1652572976 16.786 100 69 138 1 1684023328 11457408 19992944
23:03:35 10296 8192000000 10619641232 10985250816 1683148976 17.044 100 80 160 0 1718601808 11947936 23504896
23:03:56 8973 8192000000 10636567296 11008008192 1702631056 17.207 100 75 150 3 1735493184 11296128 21566000
23:04:15 8182 8192000000 10657263232 11029843968 1723594144 17.382 100 68 136 3 1754039040 11337568 19107328
23:04:31 6960 8192000000 10672015184 11048128512 1731590928 17.449 100 72 144 0 1763428352 11636176 20201248
23:04:48 8002 8192000000 10676488720 11056635904 1743871184 17.551 100 73 146 0 1776744544 12303856 20569504
23:05:05 2899 8192000000 10692475216 11068375040 1752506496 17.622 100 79 158 1 1787335408 12518096 22310816
23:05:20 4948 8192000000 10699895712 11075751936 1756556000 17.656 100 74 148 1 1789385040 11978800 20850240
23:05:32 4560 8192000000 10699738368 11083628544 1765170496 17.727 100 76 152 1 1798554624 12754832 20629296
23:05:44 4876 8192000000 10720455584 11096571904 1778428656 17.837 100 74 148 1 1812179280 12973600 20777024
23:05:55 11671 8192000000 10719215296 11106455552 1784356656 17.885 100 74 149 0 1818379824 13880992 20142176
23:06:17 4615 8192000000 10738040032 11120365568 1787506320 17.911 100 86 171 2 1825520816 14401392 23613104
23:06:29 2696 8192000000 10742768304 11124748288 1805879744 18.062 100 87 173 1 1844526352 14021360 24625248
23:06:39 3552 8192000000 10746202160 11130933248 1812703008 18.118 100 75 150 0 1847726640 13841344 21182288
23:06:49 2842 8192000000 10759122000 11146469376 1821013312 18.186 100 79 158 0 1857143712 14145920 21984480
23:06:59 3070 8192000000 10763193824 11152334848 1820838896 18.185 100 76 151 0 1854693264 13399632 20454736
23:07:08 2196 8192000000 10764015792 11153276928 1825010032 18.219 100 75 148 0 1859328832 12880704 21438096
23:07:18 2532 8192000000 10768792640 11158806528 1836230208 18.310 100 84 167 0 1871854432 12464144 23160080
23:07:27 2094 8192000000 10780129008 11167227904 1838390608 18.328 100 90 179 1 1876360848 12743200 25227040
23:07:36 3559 8192000000 10791759840 11175890944 1841891888 18.356 100 87 172 1 1879172544 13544464 23736192
23:07:47 2795 8192000000 10785188560 11170549760 1845496432 18.386 100 85 171 1 1883182880 13877888 23808560
23:07:57 2090 8192000000 10794935136 11180949504 1848671920 18.411 100 94 187 4 1889242784 13207760 27363104
23:08:05 1741 8192000000 10796543872 11180355584 1854334304 18.457 100 93 186 0 1894865952 14067008 26464640
23:08:13 2286 8192000000 10802402304 11189829632 1859960400 18.503 100 93 185 2 1899875264 13495296 26419568
23:08:22 2835 8192000000 10805727568 11193454592 1860217696 18.505 100 87 174 2 1898037360 13413456 24406208
23:08:31 1503 8192000000 10811926944 11195904000 1862643056 18.525 100 96 193 2 1904579248 14827744 27108448
23:08:39 1628 8192000000 10806847648 11198267392 1866591216 18.557 100 90 178 2 1904088800 12574496 24923088
23:08:47 1438 8192000000 10814448192 11203330048 1870369328 18.587 100 93 185 3 1909532224 13172944 25989952
23:08:54 34484 8192000000 10790067856 11198873600 1864132720 18.537 100 55 109 1 1888901008 8056432 16711856
23:09:38 5631 8192000000 10778456560 11199602688 1868249792 18.570 100 46 92 1 1889426720 8418496 12758432
23:09:50 5906 8192000000 10782038752 11201060864 1862801632 18.526 100 39 78 1 1882789440 9101344 10886464
23:10:08 5137 8192000000 10794548928 11204673536 1866752176 18.558 100 42 83 0 1887328192 9129376 11446640
23:10:21 6365 8192000000 10778539984 11203330048 1867124064 18.561 100 34 68 1 1888599200 12172208 9302928
23:10:33 5753 8192000000 10773900528 11203600384 1865961552 18.552 100 19 37 2 1877175632 5864832 5349248
23:10:46 5624 8192000000 10791121968 11214462976 1874869488 18.624 100 30 59 0 1890065264 6707760 8488016
23:11:00 7782 8192000000 10795880160 11219271680 1879466880 18.661 100 33 64 0 1894645632 6070720 9108032
23:11:14 6966 8192000000 10794447200 11216834560 1880001776 18.665 100 25 49 3 1893764960 6274592 7488592
23:11:30 14098 8192000000 10790698912 11223244800 1882902112 18.689 100 10 19 1 1890102320 5200688 1999520
23:11:51 5340 8192000000 10789037888 11227389952 1885742336 18.711 100 19 38 0 1896655168 5474016 5438816
23:12:05 5706 8192000000 10793750560 11224940544 1886653056 18.719 100 17 34 2 1897023344 5313200 5057088
23:12:20 7996 8192000000 10793368496 11230830592 1889113024 18.739 100 15 30 4 1899281408 6081024 4087360
23:12:40 11417 8192000000 10797623920 11234828288 1894009344 18.778 100 20 40 3 1905280416 5832736 5438336
23:12:57 63473 8192000000 10844359840 11257262080 1904123152 18.859 100 48 96 2 1924547776 6530288 13894336
23:14:07 1894 8192000000 10830140528 11249287168 1904232912 18.860 100 56 112 2 1931007520 11074224 15700384
23:14:23 5115 8192000000 10828291184 11253702656 1905199520 18.868 100 44 89 2 1925618496 7953280 12465696
23:14:35 5578 8192000000 10828519792 11252449280 1903204000 18.852 100 31 63 1 1918484048 6746864 8533184
23:14:47 4006 8192000000 10836636464 11258093568 1904672720 18.864 100 36 72 1 1922675408 6582304 11420384
23:15:01 6417 8192000000 10825509552 11256242176 1905633344 18.872 100 28 56 2 1920436416 6186272 8616800
23:15:14 7549 8192000000 10821272512 11252994048 1904619984 18.863 100 21 41 3 1916807424 5671904 6515536
23:15:29 6120 8192000000 10822688608 11253129216 1900999408 18.834 100 26 52 2 1914790736 6324576 7466752
23:15:44 6858 8192000000 10807679760 11248095232 1903276192 18.853 100 26 52 1 1915845552 5236928 7332432
23:15:58 6793 8192000000 10817034304 11253026816 1901823024 18.841 100 18 36 1 1911874800 5118672 4933104
23:16:13 9060 8192000000 10838983840 11262865408 1906965712 18.882 100 24 48 0 1918657984 5047808 6644464
23:16:30 10408 8192000000 10811267328 11242577920 1890665840 18.751 99 24 48 0 1904392768 6403456 7323472
23:16:50 11590 8192000000 10811265456 11252760576 1907408544 18.886 100 27 54 1 1921755280 5636144 8710592
23:17:10 50471 8192000000 10802604416 11237490688 1875015072 18.625 99 40 79 2 1892175840 5636576 11524192
23:18:08 17760 8192000000 10774444752 11216568320 1859368736 18.498 98 20 41 1 1871426432 6486128 5571568
23:18:33 11893 8192000000 10775269568 11195498496 1806470528 18.067 97 24 48 2 1819089824 5916176 6703120
23:18:53 4866 8192000000 10757680816 11182276608 1829224320 18.253 99 20 40 0 1840572320 5795520 5552480
23:19:04 3184 8192000000 10739249744 11144404992 1782212816 17.868 97 49 98 3 1804132000 8012304 13906880
23:19:14 4722 8192000000 10721662352 11146006528 1776112256 17.817 97 27 53 1 1790572720 6782960 7677504
23:19:26 5664 8192000000 10712259728 11119935488 1718662080 17.341 95 17 34 0 1729090432 5379072 5049280
23:19:39 7411 8192000000 10699732016 11109486592 1727645280 17.416 96 23 46 1 1743733280 9854768 6233232
23:19:55 7465 8192000000 10707425488 11123466240 1791055120 17.940 100 31 60 3 1806241296 5892992 9293184
23:20:10 4844 8192000000 10726936640 11129655296 1763469184 17.713 97 28 57 1 1777518480 5257200 8792096
23:20:22 6461 8192000000 10715906528 11135332352 1774186000 17.802 98 28 57 3 1791917120 10527184 7203936
23:20:35 8132 8192000000 10721886048 11150905344 1813709792 18.126 100 23 46 2 1827332288 6573920 7048576
23:20:50 8917 8192000000 10695314160 11113283584 1685523872 17.064 93 22 44 2 1701050416 9684128 5842416
23:21:05 12876 8192000000 10706290080 11115409408 1755283008 17.645 98 21 42 1 1767442960 5903968 6255984
23:21:24 9868 8192000000 10713216912 11138260992 1803591584 18.043 100 32 64 0 1823278704 9627744 10059376
23:21:40 72559 8192000000 10715578448 11136860160 1743943920 17.551 96 30 60 0 1758094896 5465808 8685168
23:22:59 12250 8192000000 10721694880 11137069056 1775669216 17.814 98 29 58 1 1790514752 6308288 8537248
23:23:19 9121 8192000000 10745123824 11163955200 1824344976 18.213 100 33 66 2 1842105344 7613104 10147264
23:23:35 6361 8192000000 10735906160 11153661952 1804043904 18.047 99 31 62 1 1819927616 6511632 9372080
23:23:48 7323 8192000000 10761930128 11175632896 1833881808 18.291 100 27 54 3 1847819536 6421552 7516176
23:24:02 4844 8192000000 10758057376 11177160704 1836752240 18.314 100 32 64 1 1852817440 6702928 9362272
23:24:14 7583 8192000000 10759738032 11186343936 1847456464 18.401 100 38 76 0 1865375632 6799344 11119824
23:24:28 11422 8192000000 10757565344 11189358592 1847356336 18.401 100 12 24 0 1856733760 5491936 3885488
23:24:45 7988 8192000000 10773337664 11198787584 1857700480 18.485 100 21 42 2 1869562928 5730176 6132272
23:25:02 8590 8192000000 10776027056 11204087808 1855821056 18.469 100 17 34 2 1866075088 5476064 4777968
23:25:22 9601 8192000000 10783376896 11204984832 1863232208 18.529 100 27 54 2 1876955888 5041504 8682176
23:25:42 19196 8192000000 10779094144 11209912320 1865532768 18.548 100 11 22 1 1874128736 5522160 3073808
23:26:07 10004 8192000000 10783882816 11212636160 1868117408 18.569 100 17 34 0 1878350528 5520736 4712384
23:26:25 37034 8192000000 10784954064 11215900672 1868972384 18.576 100 21 42 2 1880695712 5575280 6148048
23:27:09 99255 8192000000 10835860208 11258183680 1895045536 18.786 100 46 90 0 1916146832 7910144 13191152
23:29:00 5034 8192000000 10858462656 11275362304 1920788480 18.993 100 64 126 3 1950829488 11603504 18437504
23:29:13 3634 8192000000 10870573328 11280924672 1927487632 19.047 100 68 134 0 1958879632 12342752 19049248
23:29:23 4958 8192000000 10868939872 11285602304 1932343024 19.086 100 59 115 0 1960089024 11407968 16338032
23:29:35 12402 8192000000 10876592288 11299819520 1938533696 19.135 100 62 124 0 1968601744 12679872 17388176
23:29:59 45324 8192000000 10873506832 11311124480 1947372768 19.206 100 47 94 2 1974806656 14413904 13019984
23:30:52 22842 8192000000 10880167968 11315761152 1951120960 19.235 100 36 73 3 1973705952 11911424 10673568
23:31:22 14926 8192000000 10893392416 11323371520 1959559552 19.303 100 44 88 0 1987286256 14347760 13378944
23:31:45 19751 8192000000 10909817424 11336753152 1973332400 19.412 100 67 131 2 2008689504 15554896 19802208
23:32:14 9989 8192000000 10913853776 11339841536 1969613568 19.382 100 53 104 0 2001125664 16601472 14910624
23:32:34 22593 8192000000 10918538912 11342700544 1974794992 19.423 100 60 118 0 2011053504 19145008 17113504
23:33:05 16822 8192000000 10923553472 11353554944 1979130512 19.458 100 50 100 0 2011281872 17490944 14660416
23:33:31 20587 8192000000 10930763088 11365195776 1982747392 19.486 100 49 97 2 2016261792 19500304 14014096
23:34:05 3942 8192000000 10941588912 11370868736 1993492176 19.571 100 53 105 1 2032127024 22955712 15679136
23:34:21 8749 8192000000 10939488368 11374432256 1994761408 19.581 100 47 95 0 2032722752 23919888 14041456
23:34:37 6400 8192000000 10948212016 11375808512 1998629152 19.612 100 56 110 3 2037434096 22262048 16542896
23:34:52 24312 8192000000 10942349056 11377991680 1979160400 19.458 99 42 80 3 2015762128 24117808 12483920
23:35:28 5435 8192000000 10956264032 11388260352 2004314848 19.657 100 56 112 1 2046092544 25332384 16445312
23:35:45 10230 8192000000 10970034288 11400011776 2012578160 19.722 100 56 110 1 2056036672 26623472 16835040
23:36:02 5395 8192000000 10978606224 11401404416 2017974032 19.764 100 68 132 1 2066331424 27760656 20596736
23:36:15 10589 8192000000 10980636304 11413016576 2020912960 19.787 100 66 132 1 2070134384 29135920 20085504
23:36:41 3131 8192000000 10980660352 11410731008 2019466880 19.776 100 65 130 2 2070414272 31982000 18965392
23:36:51 3295 8192000000 10980222592 11408543744 2020272976 19.782 100 79 157 1 2076519472 32632160 23614336
23:37:04 6272 8192000000 10981448448 11408625664 2020456928 19.784 100 66 130 4 2072234960 32757088 19020944
23:37:25 17816 8192000000 10982064208 11410767872 2001479024 19.634 99 58 111 3 2054531776 35811984 17240768
23:37:56 3243 8192000000 10985116864 11410046976 2016371856 19.752 100 62 122 3 2074182768 38867344 18943568
23:38:10 4948 8192000000 10993580816 11417587712 2019945456 19.780 100 76 151 0 2084198064 40445520 23807088
23:38:24 5599 8192000000 10976407520 11401007104 1983304848 19.491 98 72 142 2 2045897152 40268240 22324064
23:38:42 18389 8192000000 10981527536 11409461248 1987544032 19.524 99 65 130 1 2049822176 42108752 20169392
23:39:10 16172 8192000000 10968313392 11413598208 2001869776 19.637 100 48 95 0 2065164688 47892768 15402144
23:39:39 6336 8192000000 10991443648 11425177600 2008918208 19.693 100 42 83 3 2074728272 51551136 14258928
23:39:54 13466 8192000000 10990688112 11423485952 2009748832 19.700 100 62 124 1 2077516928 47625216 20142880
23:40:16 1569 8192000000 11004251248 11421462528 1997549104 19.603 99 77 154 1 2073683104 51203104 24930896
23:40:25 4942 8192000000 10999195936 11424808960 2006960528 19.678 100 75 150 2 2083469488 53340720 23168240
23:40:37 2106 8192000000 11011564192 11423354880 2001563856 19.635 99 87 174 1 2081144320 52337536 27242928
23:40:46 3345 8192000000 11020885680 11437314048 2018880592 19.771 100 91 182 0 2100172224 54112144 27179488
23:40:59 3675 8192000000 10999499904 11420561408 1992476368 19.563 99 79 157 1 2071409936 54389024 24544544
23:41:09 5712 8192000000 10987732144 11405684736 1976280624 19.435 99 79 158 1 2056559392 55997584 24281184
23:41:23 1907 8192000000 11003663760 11419463680 2002247600 19.640 100 80 158 1 2081819280 55520576 24051104
23:41:32 5853 8192000000 10982261552 11415654400 1986164912 19.513 99 68 135 4 2062631648 55612288 20854448
23:41:50 5895 8192000000 10963058384 11393847296 1959310304 19.301 98 55 110 0 2028248976 51045008 17893664
23:42:06 7169 8192000000 10973631360 11399610368 1976350560 19.436 99 54 108 1 2045213520 52041504 16821456
23:42:21 7599 8192000000 10976565536 11397754880 1984441904 19.500 100 70 140 0 2061335440 54653024 22240512
23:42:37 1341 8192000000 10959927056 11371704320 1954703440 19.264 99 70 141 0 2032876448 55779248 22393760
23:42:45 6801 8192000000 10973170512 11387658240 1962947712 19.329 99 76 152 0 2044428064 57464176 24016176
23:43:00 1570 8192000000 10979654160 11394662400 1980373664 19.468 100 85 168 1 2064031360 57136592 26521104
23:43:12 2440 8192000000 10977158816 11396366336 1966682848 19.359 99 78 156 2 2050681696 59589152 24409696
23:43:22 3836 8192000000 10987893072 11404427264 1986201648 19.514 100 77 152 0 2070790560 60830128 23758784
23:43:37 2996 8192000000 10994492416 11415126016 1993751552 19.573 100 81 162 0 2082065872 62556640 25757680
23:43:48 6053 8192000000 10998326640 11413680128 1988065728 19.529 100 82 162 1 2078390496 64761808 25562960
23:44:00 4615 8192000000 10983017904 11401146368 1972696688 19.407 99 72 144 0 2060889296 65214336 22978272
23:44:14 1794 8192000000 11006029888 11416178688 1991422464 19.555 100 87 174 3 2083212624 63805024 27985136
23:44:27 6185 8192000000 11002438272 11427639296 1993024384 19.568 100 67 134 0 2080624192 65982000 21617808
23:44:40 2796 8192000000 10997511344 11422552064 1979867488 19.464 99 79 155 0 2072993856 68490464 24635904
23:44:54 1859 8192000000 11011543664 11428470784 2000988976 19.631 100 88 174 1 2092385456 63967168 27429312
23:45:04 6704 8192000000 11002957648 11426832384 1979718816 19.462 99 74 148 1 2068386464 65039264 23628384
23:45:25 7628 8192000000 10960746144 11385257984 1945761312 19.193 98 68 136 1 2036489856 69432032 21296512
23:45:40 1477 8192000000 11004488368 11413540864 1984061968 19.497 100 98 192 1 2082754640 68013696 30678976
23:45:48 2380 8192000000 10989609920 11402969088 1972797952 19.408 100 87 173 2 2066082672 66861376 26423344
23:46:00 1707 8192000000 10999871104 11408113664 1981556240 19.477 100 94 188 1 2081023344 70434256 29032848
23:46:09 2931 8192000000 11003585936 11414052864 1983319408 19.491 100 84 168 3 2080762000 71628512 25814080
23:46:19 4644 8192000000 11004393392 11424305152 1988443520 19.531 100 70 140 2 2084743840 74471984 21828336
23:46:34 3442 8192000000 10991202160 11421696000 1990045664 19.544 100 64 128 1 2078616352 68262080 20308608
23:46:44 14246 8192000000 10986251264 11424100352 1988302016 19.530 100 45 90 0 2071172128 67872704 14997408
23:47:15 13024 8192000000 10984931888 11422064640 1970113488 19.386 99 49 98 3 2055555152 69415872 16025792
23:47:37 7499 8192000000 10957401600 11401695232 1949825680 19.225 99 36 72 2 2028684640 66758464 12100496
23:47:55 8002 8192000000 10956403712 11390160896 1956301616 19.277 100 45 90 2 2038015904 66853136 14861152
23:48:13 8739 8192000000 10976871648 11407089664 1965201136 19.347 100 46 92 2 2051358944 70572448 15585360
23:48:32 21401 8192000000 10975345264 11424694272 1970767760 19.392 100 36 72 2 2057888976 74651792 12469424
23:49:08 13777 8192000000 10949859264 11400904704 1936358880 19.118 98 31 62 1 2019148640 72085360 10704400
23:49:29 10447 8192000000 10945908016 11381555200 1938460304 19.134 99 36 72 3 2012827264 61978864 12388096
23:49:46 5378 8192000000 10954021120 11387699200 1957150528 19.283 100 42 84 1 2032819776 61405744 14263504
23:50:07 24394 8192000000 10953295392 11399446528 1955492480 19.270 100 40 78 3 2038111184 69146672 13472032
23:50:37 33639 8192000000 10955765856 11399524352 1951315488 19.237 100 36 72 2 2040234560 75223088 13695984
23:51:43 20382 8192000000 10947856032 11401875456 1930875360 19.074 99 30 60 1 2017118352 74974432 11268560
23:52:10 27329 8192000000 10919677072 11372544000 1896267328 18.796 98 26 52 1 1981167552 73713248 11186976
23:52:51 25285 8192000000 10923728352 11374198784 1908412800 18.894 99 20 40 0 1989492096 72798864 8280432
23:53:22 11856 8192000000 10941813616 11384967168 1922878192 19.010 99 37 74 0 2012391376 75623376 13889808
23:53:40 18121 8192000000 10955269408 11400835072 1940364800 19.150 100 28 56 1 2025108832 73885472 10858560
23:54:05 31435 8192000000 10918403200 11388366848 1910227504 18.908 98 21 41 1 1977596368 60193680 7175184
23:55:25 77147 8192000000 10869837696 11332497408 1907333776 18.885 99 19 37 1 1935338064 22038304 5965984
23:56:50 39504 8192000000 10870599472 11320586240 1920005904 18.987 99 31 63 0 1941129552 11532816 9590832
23:58:14 51645 8192000000 10869810544 11319918592 1914007120 18.939 98 40 82 0 1932109056 6195408 11906528
23:59:14 109489 8192000000 10875735168 11323289600 1892196512 18.763 97 31 64 1 1907829888 7267520 8365856
00:01:10 108529 8192000000 10855774304 11320586240 1926757776 19.041 99 14 28 0 1941415568 10345424 4312368
00:03:08 54307 8192000000 10882064448 11338829824 1933451232 19.094 99 16 32 2 1948757936 11180560 4126144
00:04:09 72888 8192000000 10897785792 11356794880 1950894064 19.234 99 40 79 1 1980276208 18685104 10697040
00:05:29 90922 8192000000 10910210016 11358412800 1952635840 19.247 99 38 76 1 1988884512 23947440 12301232
00:07:07 44316 8192000000 10921638688 11370119168 1971062336 19.394 100 34 64 3 1995836736 14851968 9922432
00:07:58 49659 8192000000 10903218928 11370110976 1957199264 19.284 99 20 40 2 1975409600 13282096 4928240
00:08:54 64064 8192000000 10929870800 11392819200 1985935968 19.512 100 23 46 1 2011142608 18542528 6664112
00:10:04 138072 8192000000 10905766912 11384819712 1942021616 19.163 98 15 29 2 1964718224 18032272 4664336
00:12:42 51512 8192000000 10899551888 11368796160 1952066496 19.243 99 10 19 0 1966944576 12219104 2658976
00:13:49 92222 8192000000 10876207136 11348099072 1917384032 18.966 97 18 36 1 1931895248 9292416 5218800
00:15:28 82082 8192000000 10896431760 11376017408 1972159344 19.403 100 26 52 0 1989386784 9680064 7547376
00:16:56 51482 8192000000 10893506976 11382022144 1973752352 19.415 100 13 27 3 1987201776 9970048 3479376
00:18:12 60141 8192000000 10890522336 11374796800 1960603312 19.311 99 25 50 0 1976662272 8941712 7117248
00:19:31 62103 8192000000 10879070352 11361353728 1939406496 19.142 98 11 22 2 1954841376 12524560 2910320
00:20:42 66799 8192000000 10891016576 11364765696 1940512032 19.151 98 13 26 0 1952843792 8193104 4138656
00:22:10 65244 8192000000 10912038064 11390713856 1980877232 19.472 100 14 28 0 1994867024 9541184 4448608
00:23:25 60323 8192000000 10894135040 11378933760 1969060864 19.378 99 12 24 0 1981486448 8824304 3601280
00:24:38 90797 8192000000 10885226656 11369189376 1908209632 18.892 96 12 24 0 1920058624 8945744 2903248
00:26:21 82188 8192000000 10899447440 11371491328 1939554768 19.143 98 12 24 1 1951674512 9339840 2779904
00:27:57 53940 8192000000 10895935680 11370762240 1922132752 19.004 97 9 18 0 1931762192 7399728 2229712
00:29:11 126735 8192000000 10887928592 11366264832 1836471536 18.312 92 20 40 2 1853090416 10621616 5997264
00:31:25 62584 8192000000 10863758016 11342180352 1899551888 18.823 97 10 20 0 1911541920 9235984 2754048
00:32:36 86975 8192000000 10865911488 11339587584 1834477152 18.296 94 19 39 0 1848520896 9216800 4826944
00:34:12 87958 8192000000 10855263008 11334152192 1805529344 18.059 93 14 28 1 1822904864 13531824 3843696
00:35:46 99704 8192000000 10864947696 11317362688 1839052768 18.333 95 12 24 0 1857491120 15269616 3168736
00:37:33 19234 8192000000 10859152544 11306414080 1871152080 18.594 97 41 82 1 1896237424 13329200 11756144
00:38:00 94600 8192000000 10868752032 11317264384 1837153344 18.318 96 20 40 0 1860832960 17862720 5816896
00:39:41 21758 8192000000 10878774944 11316498432 1912216368 18.924 99 30 60 1 1929637952 8920656 8500928
00:40:12 83945 8192000000 10868415568 11309649920 1874515072 18.621 97 40 82 0 1894013312 7503936 11994304
00:41:45 90528 8192000000 10866194032 11331198976 1878701968 18.655 97 37 74 2 1904975856 15772016 10501872
00:43:42 47978 8192000000 10872468352 11348234240 1940538768 19.151 100 9 18 1 1959648656 16120928 2988960
00:44:45 82117 8192000000 10870715568 11353997312 1953973792 19.258 100 7 14 1 1970521456 14458064 2089600
00:46:27 76459 8192000000 10847888752 11319169024 1855039728 18.463 95 9 18 0 1865221920 7573728 2608464
00:48:01 69432 8192000000 10843613360 11319889920 1878850144 18.656 97 9 18 1 1891720480 10277344 2592992
00:49:16 72930 8192000000 10841644512 11314057216 1858440784 18.491 96 11 22 1 1876375472 14891152 3043536
00:50:35 38044 8192000000 10840978672 11315290112 1906526880 18.879 99 14 28 0 1925828224 15383984 3917360
00:51:30 66748 8192000000 10860790496 11352195072 1913964880 18.938 100 11 22 1 1933177200 16503072 2709248
00:52:43 36050 8192000000 10846232784 11316097024 1890285968 18.748 98 12 21 1 1908586560 15686896 2613696
00:53:39 67131 8192000000 10877471088 11342532608 1917592592 18.968 99 19 38 0 1934852784 12129520 5130672
00:54:56 45337 8192000000 10869251520 11337908224 1908186944 18.892 98 19 38 1 1923591984 10016560 5388480
00:55:49 28106 8192000000 10883912256 11332501504 1938923632 19.138 99 38 77 1 1958668592 9023984 10720976
00:56:26 56238 8192000000 10877164464 11344130048 1920399168 18.990 98 35 70 1 1941013712 11111632 9502912
00:58:01 95711 8192000000 10900769456 11366236160 1944417712 19.182 99 17 33 1 1967380816 18459520 4503584
01:00:58 34182 8192000000 10915260928 11380510720 1960903104 19.313 99 27 54 1 1983913536 15920624 7089808
01:02:04 64948 8192000000 10902583152 11379437568 1954650592 19.263 99 14 28 0 1973653664 15207872 3795200
01:03:22 16141 8192000000 10935901184 11376529408 1982613600 19.485 100 49 96 2 2005651760 8808272 14229888
01:03:48 16643 8192000000 10922992624 11377299456 1982634192 19.486 100 32 64 1 2000220624 8860720 8725712
01:04:14 15886 8192000000 10951840976 11394723840 1998983216 19.615 100 65 130 0 2028172432 10868176 18321040
01:04:37 20208 8192000000 10948722800 11398197248 1979811952 19.463 99 52 104 1 2009595952 15321360 14462640
01:06:07 22608 8192000000 10938321232 11399864320 1997736208 19.605 100 25 51 2 2012731440 8368464 6626768
01:06:37 91410 8192000000 10901952064 11379036160 1960007360 19.306 98 25 50 0 1981812816 14579744 7225712
01:08:14 136152 8192000000 10905997440 11386646528 1956491552 19.278 98 16 32 1 1972625264 11602848 4530864
01:11:22 64434 8192000000 10877481776 11357351936 1944657296 19.184 98 26 52 1 1962147792 9977968 7512528
01:12:33 73989 8192000000 10893995200 11357310976 1899174720 18.820 96 10 20 1 1913225536 11407040 2643776
01:14:38 72072 8192000000 10883995632 11357028352 1926234432 19.037 98 16 32 1 1945171328 13857040 5079856
01:16:01 60586 8192000000 10873941648 11362828288 1950809984 19.233 100 14 28 0 1971392864 16694608 3888272
01:17:08 43241 8192000000 10866731920 11327422464 1855057824 18.463 95 11 23 0 1870702576 12720784 2923968
01:17:59 67678 8192000000 10853990608 11342012416 1901331376 18.837 98 18 36 1 1919657088 13141712 5184000
01:19:14 49601 8192000000 10887567648 11357896704 1897776992 18.808 97 14 28 1 1911412352 9648880 3986480
01:20:24 39376 8192000000 10894490288 11363749888 1931739536 19.081 98 19 38 0 1950820208 13347296 5733376
01:21:18 41054 8192000000 10894338224 11361468416 1948508704 19.215 99 27 54 1 1969145488 12585296 8051488
01:22:14 51263 8192000000 10896832352 11359531008 1924271632 19.021 98 16 32 0 1944035984 15167488 4596864
01:23:19 66321 8192000000 10889113712 11346911232 1878850848 18.656 96 27 53 1 1895625408 9411392 7363168
01:24:32 38400 8192000000 10880564560 11340709888 1910439456 18.910 98 26 52 1 1930029296 12050672 7539168
01:25:17 28106 8192000000 10900037376 11352891392 1932913200 19.090 99 35 71 2 1953351952 10808944 9629808
01:25:52 30242 8192000000 10896312976 11353649152 1930544640 19.071 99 40 80 1 1956102928 14319488 11238800
01:26:32 48476 8192000000 9307916816 9576292352 458803952 5.303 24 2 4 0 463318288 4181216 333120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 15-01-2021 01:28:05 to 15-01-2021 01:28:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 147 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 15-01-2021 01:28:36 to 15-01-2021 01:28:38.

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

15.01.21 01:28:39. 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-15 01:28:41 No severe PSQL-related problems occured
15.01.21 01:28:42. End of report.