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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17271904 kB
MemAvailable 31465480 kB
Buffers 0 kB
Cached 14406276 kB
SwapCached 3700 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 2020-12-23 22:27:07
DTS_END                         2020-12-23 22:27:07.1250
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(127:13) ==> X_MAKE_QSTORNO_2100_3300(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52726
TRN_ID                          252186
ATT_ID                          666
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: 9744.52 23653 1169342
customer order: creation 181.85 339 21822
customer order: refuse 15.70 287 1884
order to supplier: creation 48.80 1178 5856
order to supplier: removal 3.54 84403 425
invoice (draft): creation 47.62 2591 5714
invoice (draft): removal 55.25 699 6630
invoice accept: apply 43.93 15603 5271
invoice accept: cancel 50.37 683 6044
customer reserve: creation 4047.41 155 485689
customer reserve: removal 4934.43 47 592131
realization accept: apply 88.54 165 10625
realization accept: cancel 89.07 97 10688
payment from customer: creation 63.45 85 7614
payment from customer: removal 5.92 61 710
payment to supplier: creation 52.44 123 6293
payment to supplier: removal 3.40 55 408
service: total inventory turnovers 5.26 978 631
service: total monetary turnovers 6.76 37 811
service: aggregate perf. data 0.77 21298 92
service: refresh index statistics 0.03 344168 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 23-12-2020 22:28:26 to 23-12-2020 22:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4027
TEST_TIME 2 4602
TEST_TIME 3 5188
TEST_TIME 4 6155
TEST_TIME 5 6647
TEST_TIME 6 6335
TEST_TIME 7 6577
TEST_TIME 8 7141
TEST_TIME 9 7367
TEST_TIME 10 7530
TEST_TIME 11 7956
TEST_TIME 12 8194
TEST_TIME 13 8546
TEST_TIME 14 9521
TEST_TIME 15 9550
TEST_TIME 16 9556
TEST_TIME 17 10249
TEST_TIME 18 10392
TEST_TIME 19 11880
TEST_TIME 20 12670
TEST_TIME 21 12256
TEST_TIME 22 12055
TEST_TIME 23 12396
TEST_TIME 24 12467
TEST_TIME 25 12279
TEST_TIME 26 11975
TEST_TIME 27 11840
TEST_TIME 28 11599
TEST_TIME 29 11866
TEST_TIME 30 11749
TEST_TIME 31 11762
TEST_TIME 32 11768
TEST_TIME 33 11760
TEST_TIME 34 11627
TEST_TIME 35 11328
TEST_TIME 36 11139
TEST_TIME 37 11146
TEST_TIME 38 11032
TEST_TIME 39 10895
TEST_TIME 40 10749
TEST_TIME 41 10602
TEST_TIME 42 10647
TEST_TIME 43 10590
TEST_TIME 44 10602
TEST_TIME 45 10577
TEST_TIME 46 10377
TEST_TIME 47 10490
TEST_TIME 48 10615
TEST_TIME 49 10596
TEST_TIME 50 10636
TEST_TIME 51 10580
TEST_TIME 52 10559
TEST_TIME 53 10535
TEST_TIME 54 10630
TEST_TIME 55 10580
TEST_TIME 56 10597
TEST_TIME 57 10628
TEST_TIME 58 10649
TEST_TIME 59 10655
TEST_TIME 60 10739
TEST_TIME 61 10621
TEST_TIME 62 10530
TEST_TIME 63 10475
TEST_TIME 64 10384
TEST_TIME 65 10426
TEST_TIME 66 10401
TEST_TIME 67 10293
TEST_TIME 68 10243
TEST_TIME 69 10173
TEST_TIME 70 10193
TEST_TIME 71 10303
TEST_TIME 72 10225
TEST_TIME 73 10232
TEST_TIME 74 10174
TEST_TIME 75 10259
TEST_TIME 76 10288
TEST_TIME 77 10267
TEST_TIME 78 10228
TEST_TIME 79 10253
TEST_TIME 80 10246
TEST_TIME 81 10278
TEST_TIME 82 10212
TEST_TIME 83 10133
TEST_TIME 84 10167
TEST_TIME 85 10083
TEST_TIME 86 10084
TEST_TIME 87 10079
TEST_TIME 88 10036
TEST_TIME 89 9973
TEST_TIME 90 10077
TEST_TIME 91 10031
TEST_TIME 92 9980
TEST_TIME 93 10078
TEST_TIME 94 10052
TEST_TIME 95 10052
TEST_TIME 96 10063
TEST_TIME 97 10091
TEST_TIME 98 10156
TEST_TIME 99 10152
TEST_TIME 100 10136
TEST_TIME 101 10147
TEST_TIME 102 10165
TEST_TIME 103 10190
TEST_TIME 104 10163
TEST_TIME 105 10074
TEST_TIME 106 10057
TEST_TIME 107 10077
TEST_TIME 108 10040
TEST_TIME 109 10004
TEST_TIME 110 9947
TEST_TIME 111 9918
TEST_TIME 112 9920
TEST_TIME 113 9860
TEST_TIME 114 9927
TEST_TIME 115 9893
TEST_TIME 116 9861
TEST_TIME 117 9861
TEST_TIME 118 9855
TEST_TIME 119 9823
TEST_TIME 120 9750

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-12-2020 22:28:30 to 23-12-2020 22:28:34.

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 1619531 1619531 0 0.00 0 14895 5 0 0
doc_list_biud 1619531 1619531 0 0.00 0 83655 22 0 0
sp_add_invoice_to_stock 5396 5271 125 2.31 28 163594 15603 0 125
sp_cancel_adding_invoice 6044 6044 0 0.00 5 66931 683 0 0
sp_cancel_client_order 1884 1884 0 0.00 4 9690 288 0 0
sp_cancel_customer_reserve 592131 592131 0 0.00 1 55600 47 0 0
sp_cancel_pay_from_customer 710 710 0 0.00 3 2993 61 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 3 3308 55 0 0
sp_cancel_supplier_invoice 6643 6630 13 0.19 1 83666 700 0 13
sp_cancel_supplier_order 425 425 0 0.00 7 1022087 84403 0 0
sp_cancel_write_off 10688 10688 0 0.00 1 40802 97 0 0
sp_client_order 21822 21822 0 0.00 4 21340 339 0 0
sp_customer_reserve 485689 485689 0 0.00 0 33479 156 0 0
sp_fill_shopping_cart 33380 33380 0 0.00 1 14191 35 0 0
sp_fill_shopping_cart_clo_res 485682 485682 0 0.00 0 18552 13 0 0
sp_get_clo_for_invoice 5264 5264 0 0.00 0 31644 254 0 0
sp_kill_cost_storno 17850 17850 0 0.00 0 8937 46 0 0
sp_kill_qstorno_ret_qs2qd 1202005 1202005 0 0.00 0 83650 26 0 0
sp_kill_qty_storno 633691 633691 0 0.00 0 83653 56 0 0
sp_lock_selected_doc 21935 21935 0 0.00 0 9000 6 0 0
sp_make_cost_storno 29796 29796 0 0.00 0 13522 44 0 0
sp_multiply_rows_for_pdistr 29796 29796 0 0.00 0 12259 23 0 0
sp_multiply_rows_for_qdistr 21822 21822 0 0.00 0 10577 151 0 0
sp_pay_from_customer 7614 7614 0 0.00 4 12307 86 0 0
sp_pay_to_supplier 6293 6293 0 0.00 5 17676 123 0 0
sp_payment_common 13907 13907 0 0.00 1 10338 25 0 0
sp_qd_handle_on_cancel_clo 1884 1884 0 0.00 0 9684 248 0 0
sp_qd_handle_on_invoice_upd_sts 11308 11308 0 0.00 0 30270 260 0 0
sp_qd_handle_on_reserve_upd_sts 10625 10625 0 0.00 0 16142 57 0 0
sp_reserve_write_off 10625 10625 0 0.00 6 17205 166 0 0
sp_supplier_invoice 5714 5714 0 0.00 7 77658 2592 0 0
sp_supplier_order 5856 5856 0 0.00 5 39419 1179 0 0
srv_aggregate_perf_data 92 92 0 0.00 2661 281044 21298 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 1584 184997 36064 0 0
srv_find_qd_qs_mism 1119107 1119107 0 0.00 0 11648 5 0 0
srv_make_invnt_saldo 631 631 0 0.00 35 52352 979 0 0
srv_make_money_saldo 811 811 0 0.00 1 15020 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 184224 453259 344169 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5272 5272 0 0.00 0 19841 163 0 0
t$perf-norm:sp_cancel_adding_invoice 430 430 0 0.00 0 2706 70 0 0
t$perf-norm:sp_cancel_client_order 1884 1884 0 0.00 0 5946 17 0 0
t$perf-norm:sp_cancel_customer_reserve 711 711 0 0.00 0 2553 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 710 710 0 0.00 0 5682 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 2693 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 418 418 0 0.00 0 7268 28 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 15996 1396 0 0
t$perf-norm:sp_cancel_write_off 1064 1064 0 0.00 0 4970 11 0 0
t$perf-norm:sp_client_order 21822 21822 0 0.00 0 14325 19 0 0
t$perf-norm:sp_customer_reserve 1037 1037 0 0.00 0 7537 15 0 0
t$perf-norm:sp_pay_from_customer 7614 7614 0 0.00 0 9595 12 0 0
t$perf-norm:sp_pay_to_supplier 6293 6293 0 0.00 0 12044 12 0 0
t$perf-norm:sp_reserve_write_off 10625 10625 0 0.00 0 10835 17 0 0
t$perf-norm:sp_supplier_invoice 5714 5714 0 0.00 0 9160 19 0 0
t$perf-norm:sp_supplier_order 5856 5856 0 0.00 0 9705 15 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 19 0 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 947 11 0 0
t$perf-norm:srv_make_invnt_saldo 631 631 0 0.00 0 3097 15 0 0
t$perf-norm:srv_make_money_saldo 811 811 0 0.00 0 514 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 86 24 0 0
v_add_invoice_to_stock 10772 10522 250 2.32 0 9218 20 0 250
v_all_customers 39606 39606 0 0.00 0 80 1 0 0
v_all_suppliers 32174 32174 0 0.00 0 16 1 0 0
v_all_wares 43644 43644 0 0.00 0 75 1 0 0
v_cancel_adding_invoice 860 860 0 0.00 0 2587 10 0 0
v_cancel_client_order 3768 3768 0 0.00 0 4783 8 0 0
v_cancel_customer_prepayment 1420 1420 0 0.00 0 2286 8 0 0
v_cancel_customer_reserve 1422 1422 0 0.00 0 4559 14 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 299 3 0 0
v_cancel_supplier_invoice 862 836 26 3.01 0 5383 27 0 26
v_cancel_supplier_order 850 850 0 0.00 0 4427 16 0 0
v_cancel_write_off 2128 2128 0 0.00 0 3471 15 0 0
v_max_id_clo_ord 5853 5853 0 0.00 0 155 1 0 0
v_max_id_clo_res 1037 1037 0 0.00 0 2843 13 0 0
v_max_id_ord_sup 5704 5704 0 0.00 0 5638 6 0 0
v_max_non_paid_invoice 1763 1763 0 0.00 0 3067 5 0 0
v_max_non_paid_realizn 4067 4067 0 0.00 0 3203 4 0 0
v_min_id_clo_ord 5853 5853 0 0.00 0 3867 7 0 0
v_min_id_clo_res 1037 1037 0 0.00 0 1219 3 0 0
v_min_id_ord_sup 5704 5704 0 0.00 0 7267 7 0 0
v_min_non_paid_invoice 6293 6293 0 0.00 0 10333 22 0 0
v_min_non_paid_realizn 7613 7613 0 0.00 0 4443 11 0 0
v_our_firm 11130 11130 0 0.00 0 18 1 0 0
v_reserve_write_off 21246 21246 0 0.00 0 17151 9 0 0
x_lock_depdocs_on_canc_invoice 12256 12256 0 0.00 0 17248 113 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 3794 259 0 0
x_make_qstorno_1000_1200 5856 5856 0 0.00 1 39356 1104 0 0
x_make_qstorno_1200_2000 5714 5714 0 0.00 3 77175 2473 0 0
x_make_qstorno_2100_3300 485689 485689 0 0.00 0 33478 141 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-12-2020 22:28:35 to 23-12-2020 22:28:39.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:10 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:17 29728 8192000000 10287335696 10599137280 1012511584 11.000 78 65 130 0 1037958496 2877600 22569312
19:57:53 24243 8192000000 10349621552 10663661568 1394941280 14.550 100 87 174 0 1427809136 4911984 27955872
19:58:26 31394 8192000000 10372883216 10694303744 1425314096 14.820 100 90 180 0 1461749632 6588432 29847104
19:59:07 28025 8192000000 10409245632 10734485504 1452307120 15.058 100 88 176 0 1487975696 7133664 28534912
19:59:50 20518 8192000000 10442790096 10776326144 1491159024 15.399 100 85 170 1 1526389648 8548112 26682512
20:00:23 19225 8192000000 10464984176 10802954240 1521447040 15.663 100 87 174 1 1558256656 9655808 27153808
20:00:58 15300 8192000000 10497144784 10839121920 1544266512 15.860 100 85 170 0 1580851968 10326720 26258736
20:01:30 13647 8192000000 10515704032 10862182400 1575055120 16.126 100 86 172 1 1612865264 11096368 26713776
20:01:52 16159 8192000000 10534401584 10891202560 1595278448 16.299 100 81 162 1 1630896704 11233616 24384640
20:02:17 14121 8192000000 10553887568 10916847616 1626474912 16.565 100 75 150 0 1660047760 11256096 22316752
20:02:46 6248 8192000000 10587771488 10949181440 1647345056 16.742 100 76 151 1 1681276656 11887696 22043904
20:02:59 10314 8192000000 10610841440 10974793728 1661610784 16.862 100 79 158 4 1696964304 12057536 23295984
20:03:18 9472 8192000000 10616942352 10985963520 1675450320 16.979 100 77 154 1 1709582416 12122880 22009216
20:03:37 8196 8192000000 10634560400 11004686336 1694078720 17.136 100 74 148 0 1727736160 12068864 21588576
20:03:54 4773 8192000000 10646833520 11018518528 1705802592 17.234 100 81 162 0 1742487968 12927152 23758224
20:04:05 5096 8192000000 10654031888 11029508096 1715852144 17.318 100 71 142 0 1749040432 12706224 20482064
20:04:18 5183 8192000000 10670357680 11047305216 1727108128 17.411 100 74 146 1 1763874592 16348112 20418352
20:04:30 5658 8192000000 10683049360 11066150912 1750211008 17.603 100 76 152 0 1783630112 11887040 21532064
20:04:43 5160 8192000000 10695045504 11079438336 1764780960 17.724 100 72 142 0 1796047536 11893200 19373376
20:04:55 3509 8192000000 10710435072 11092877312 1774478544 17.804 100 75 151 0 1808959520 13402224 21078752
20:05:05 9262 8192000000 10717310640 11105181696 1782351776 17.869 100 72 142 1 1815263680 12978192 19933712
20:05:24 2307 8192000000 10743572304 11125891072 1793822912 17.963 100 81 163 0 1828842336 12122224 22897200
20:05:34 4828 8192000000 10754366160 11142037504 1812659568 18.118 100 78 157 1 1847009984 12311552 22038864
20:05:45 2378 8192000000 10759248544 11148808192 1823048624 18.203 100 85 171 1 1860129200 12775120 24305456
20:05:54 2408 8192000000 10771908656 11159339008 1828845456 18.250 100 80 155 1 1863468096 12457520 22165120
20:06:04 1943 8192000000 10771061248 11161903104 1834285744 18.294 100 84 166 2 1870348016 13030288 23031984
20:06:12 1791 8192000000 10783238000 11169566720 1841899312 18.356 100 83 166 1 1877734912 12581520 23254080
20:06:20 2555 8192000000 10785508528 11173011456 1848898304 18.413 100 92 185 0 1889001840 14119840 25983696
20:06:29 2746 8192000000 10799536864 11187027968 1854353936 18.457 100 90 181 1 1893490992 13496112 25640944
20:06:38 2160 8192000000 10801944576 11194335232 1858416464 18.490 100 89 179 1 1896723552 13779952 24527136
20:06:47 1409 8192000000 10806729232 11193667584 1866122336 18.553 100 96 195 0 1906488816 13343232 27023248
20:06:55 2269 8192000000 10797224784 11191877632 1860536704 18.508 100 85 170 0 1897820960 13463328 23820928
20:07:04 13873 8192000000 10789375456 11192090624 1860107968 18.504 100 65 130 1 1889591552 11458064 18025520
20:07:25 22710 8192000000 10777752992 11191287808 1857569424 18.484 100 31 62 2 1874224976 7953936 8701616
20:07:55 8996 8192000000 10771907296 11196645376 1862039600 18.520 100 38 76 0 1881095888 8211568 10844720
20:08:10 9911 8192000000 10765058112 11193348096 1863261984 18.530 100 24 45 0 1878998992 9884656 5852352
20:08:28 5295 8192000000 10768044960 11195518976 1863543088 18.532 100 21 42 1 1876049568 6813664 5692816
20:08:40 5953 8192000000 10770644208 11200049152 1866527280 18.556 100 26 53 1 1881576288 7985904 7063104
20:08:57 12161 8192000000 10771491056 11202646016 1866786048 18.558 100 16 33 0 1877800704 6406752 4607904
20:09:16 8945 8192000000 10770341504 11202273280 1870420224 18.588 100 21 43 1 1882940688 6822096 5698368
20:09:34 4155 8192000000 10781840544 11208171520 1873587760 18.613 100 29 59 2 1887658400 5979456 8091184
20:09:52 5836 8192000000 10789424032 11215532032 1878089888 18.650 100 20 40 2 1889648512 5792576 5766048
20:10:08 12432 8192000000 10782364608 11218362368 1880656768 18.670 100 23 46 3 1894041664 6499808 6885088
20:10:27 54417 8192000000 10810819968 11230220288 1884365456 18.700 100 36 73 4 1900113440 5470912 10277072
20:11:28 16018 8192000000 10795605376 11228585984 1882015856 18.681 100 17 34 0 1892080016 5147184 4916976
20:11:55 8595 8192000000 10799831056 11233394688 1887284224 18.724 100 29 57 4 1906223776 10721648 8217904
20:12:10 6190 8192000000 10810417136 11242156032 1894024336 18.778 100 29 56 0 1909481392 7299616 8157440
20:12:23 3417 8192000000 10819518752 11246120960 1898467088 18.814 100 45 86 1 1918828688 6773632 13587968
20:12:35 12768 8192000000 10810021296 11241316352 1897560320 18.807 100 25 51 1 1914387712 9967536 6859856
20:12:57 5868 8192000000 10814329008 11251118080 1898505312 18.814 100 31 62 1 1913962000 7289088 8167600
20:13:09 4547 8192000000 10821538640 11252285440 1900579520 18.831 100 32 62 1 1920148544 10673904 8895120
20:13:21 6319 8192000000 10816064768 11249033216 1901687040 18.840 100 23 46 0 1914247008 5945616 6614352
20:13:36 9706 8192000000 10829421824 11259027456 1902367184 18.845 100 11 22 1 1910707216 5235552 3104480
20:13:55 8112 8192000000 10820805264 11257802752 1910610192 18.912 100 24 46 3 1922936400 6112304 6213904
20:14:14 5249 8192000000 10824596432 11261243392 1911611296 18.920 100 25 48 3 1924430912 6212496 6607120
20:14:31 5836 8192000000 10816770416 11259891712 1911355840 18.918 100 22 44 0 1924429552 6880944 6192768
20:14:44 7010 8192000000 10828624720 11261349888 1912585904 18.927 100 21 43 0 1924499216 5863648 6049664
20:14:58 24180 8192000000 10813785936 11252760576 1875351296 18.628 98 27 56 0 1888164512 5142496 7670720
20:15:32 54429 8192000000 10805098640 11242721280 1855586784 18.467 97 37 74 1 1871230144 5166064 10477296
20:16:34 18495 8192000000 10786248000 11212562432 1810961280 18.104 96 28 56 2 1823383088 4988032 7433776
20:16:59 5917 8192000000 10790324800 11215147008 1839380832 18.336 98 33 67 0 1859703520 11039696 9282992
20:17:12 4734 8192000000 10777116384 11189755904 1818539808 18.166 98 39 78 1 1838106400 8274816 11291776
20:17:25 5096 8192000000 10776641664 11192254464 1823167920 18.204 98 48 93 2 1843318176 6804272 13345984
20:17:38 7455 8192000000 10705529024 11121119232 1736946064 17.493 95 34 67 1 1752434912 6054416 9434432
20:17:55 9024 8192000000 10744056176 11163205632 1826731728 18.233 100 37 74 1 1844013648 6385600 10896320
20:18:13 7263 8192000000 10703996064 11116781568 1689863440 17.100 93 26 52 5 1702244880 4864816 7516624
20:18:26 9041 8192000000 10710125088 11124596736 1733804496 17.467 96 19 38 0 1744549264 5333024 5411744
20:18:43 7109 8192000000 10733605664 11153924096 1815674592 18.142 100 22 44 1 1827862928 5480064 6708272
20:18:59 10426 8192000000 10687573968 11097899008 1635133104 16.638 90 20 40 2 1645805664 4662784 6009776
20:19:16 8011 8192000000 10710908128 11127652352 1775161984 17.810 99 15 30 0 1785016624 5045440 4809200
20:19:32 12406 8192000000 10688793184 11095834624 1735111232 17.478 97 20 40 1 1746024160 5135344 5777584
20:19:53 5209 8192000000 10650872736 11066310656 1745553568 17.565 98 27 53 2 1758713952 5296016 7864368
20:20:07 6107 8192000000 10694872304 11104800768 1777877152 17.832 100 25 50 0 1791269904 6257392 7135360
20:20:19 69520 8192000000 10707194736 11130355712 1766601568 17.739 98 28 55 3 1780417264 5449904 8365792
20:21:35 9354 8192000000 10724576384 11140870144 1792804544 17.955 99 20 40 0 1803986080 5721936 5459600
20:21:53 5869 8192000000 10727935024 11139629056 1783673824 17.880 98 43 86 0 1803418496 7310448 12434224
20:22:05 4089 8192000000 10753915248 11167035392 1820906896 18.185 100 38 76 1 1842845648 11282112 10656640
20:22:16 5242 8192000000 10741640112 11154554880 1808806160 18.086 99 40 80 2 1831661616 11318912 11536544
20:22:27 6117 8192000000 10740240816 11161513984 1831605984 18.272 100 36 70 1 1847435888 6018144 9811760
20:22:40 7428 8192000000 10751068608 11169902592 1832959776 18.283 100 28 56 1 1847043408 6049792 8033840
20:22:53 5988 8192000000 10747549568 11173785600 1835477552 18.304 100 21 42 1 1847720880 6021152 6222176
20:23:06 8663 8192000000 10759799120 11184828416 1841888016 18.356 100 37 74 0 1863589504 10231664 11469824
20:23:22 13338 8192000000 10763562912 11191504896 1849116640 18.415 100 24 48 1 1861610256 5400720 7092896
20:23:44 7226 8192000000 10770150752 11194580992 1852812096 18.445 100 21 42 1 1865126112 5807840 6506176
20:23:58 5009 8192000000 10783908816 11204456448 1859019408 18.495 100 30 60 0 1874224480 6242096 8962976
20:24:12 11698 8192000000 10774900448 11198578688 1860288624 18.506 100 28 56 4 1874007504 5255056 8463824
20:24:30 10201 8192000000 10778810592 11209019392 1859949440 18.503 100 18 34 1 1874474704 9864864 4660400
20:24:49 15384 8192000000 10779499696 11212632064 1868028016 18.568 100 14 28 1 1877020992 5386752 3606224
20:25:11 61962 8192000000 10800649440 11226345472 1881193904 18.675 100 39 76 5 1898736592 5504480 12038208
20:26:21 9927 8192000000 10784515920 11217178624 1872508992 18.605 100 14 28 1 1881089536 5012880 3567664
20:26:37 9320 8192000000 10803040128 11226513408 1876242704 18.635 100 33 66 0 1892196400 6241328 9712368
20:26:55 5153 8192000000 10802300400 11223367680 1879155152 18.658 100 39 77 0 1898673504 6399296 13119056
20:27:11 8073 8192000000 10831462560 11246510080 1898292656 18.813 100 46 90 2 1916752560 5391904 13068000
20:27:26 35938 8192000000 10844539184 11269021696 1914962176 18.946 100 45 90 2 1935184496 7981664 12240656
20:28:19 22251 8192000000 10862635648 11286351872 1927046704 19.043 100 42 84 0 1950650192 11035696 12567792
20:28:52 15114 8192000000 10882140976 11303124992 1938411904 19.134 100 46 91 1 1965230864 13988944 12830016
20:29:26 31383 8192000000 10881277264 11309322240 1943679040 19.176 100 37 74 2 1971577200 16938384 10959776
20:30:07 26333 8192000000 10891784992 11325886464 1948907344 19.218 100 45 90 1 1984739776 22009728 13822704
20:30:46 12970 8192000000 10893375296 11325177856 1954203392 19.260 100 48 96 1 1989663728 20817312 14643024
20:31:06 4155 8192000000 10908958048 11333623808 1959022496 19.298 100 46 90 1 1994327776 21254896 14050384
20:31:20 2770 8192000000 10930838768 11341381632 1967465120 19.365 100 67 134 2 2009093968 21621136 20007712
20:31:29 1583 8192000000 10923181440 11334836224 1965656064 19.351 100 79 158 1 2010554128 22318112 22579952
20:31:39 37544 8192000000 10897019472 11341148160 1964445600 19.341 100 38 76 0 1998874192 22957024 11471568
20:32:26 17954 8192000000 10918890944 11354464256 1974293248 19.419 100 45 90 0 2011371616 23529904 13548464
20:32:52 7131 8192000000 10918985648 11357986816 1975822560 19.432 100 45 90 1 2014496080 25419504 13254016
20:33:07 7211 8192000000 10919926688 11354537984 1979478192 19.461 100 55 108 3 2018702656 22447248 16777216
20:33:21 6740 8192000000 10929838272 11363602432 1983345600 19.491 100 55 109 3 2022895840 22956992 16593248
20:33:35 17607 8192000000 10931692736 11369488384 1985167904 19.506 100 49 98 4 2024637408 24524640 14944864
20:34:06 7819 8192000000 10946728656 11374702592 1986203472 19.514 100 53 106 1 2029103456 26553376 16346608
20:34:23 13002 8192000000 10941739248 11376332800 1990966928 19.551 100 55 109 0 2034713104 26805568 16940608
20:34:45 16544 8192000000 10942567776 11379195904 1973460448 19.413 99 53 104 1 2017505856 28254640 15790768
20:35:09 7118 8192000000 10945647728 11377766400 1973623424 19.414 99 61 123 1 2023779280 31200832 18955024
20:35:27 6382 8192000000 10941542816 11383795712 1993046928 19.568 100 50 99 0 2036766448 28910816 14808704
20:35:41 5207 8192000000 10964005328 11394588672 2003471728 19.650 100 55 108 2 2047567664 28085360 16010576
20:35:57 3009 8192000000 10974959856 11399573504 2003814256 19.653 100 66 132 1 2053799920 29505568 20480096
20:36:08 3839 8192000000 10961371728 11395342336 2004400560 19.657 100 59 118 1 2053537088 31765552 17370976
20:36:21 1726 8192000000 10963706336 11384799232 1989769520 19.542 99 84 167 4 2043932848 29909008 24254320
20:36:30 5564 8192000000 10972054016 11393888256 1999472800 19.619 100 67 132 3 2054258544 35639616 19146128
20:36:42 1757 8192000000 10980653696 11395235840 2003078656 19.647 100 84 167 2 2060164016 32712336 24373024
20:36:51 2332 8192000000 10979766144 11398541312 2010272288 19.704 100 83 166 0 2068402736 33648864 24481584
20:37:00 6703 8192000000 10947580944 11380297728 1970683120 19.391 98 69 138 1 2026098256 34895568 20519568
20:37:15 2765 8192000000 10923340336 11341533184 1951860704 19.241 99 71 142 3 2006750720 33837344 21052672
20:37:25 1676 8192000000 10924156736 11345055744 1955658464 19.272 100 74 146 3 2011169648 33729376 21781808
20:37:33 3423 8192000000 10946841808 11358322688 1971451440 19.397 100 88 177 0 2032341584 34358640 26531504
20:37:47 6314 8192000000 10938275056 11349491712 1948565760 19.215 99 86 172 0 2011420768 37020288 25834720
20:38:00 3997 8192000000 10937904288 11355721728 1949597984 19.223 99 80 160 1 2014061120 40449776 24013360
20:38:13 4570 8192000000 10941717904 11369476096 1973933632 19.417 100 71 142 2 2035764288 39954608 21876048
20:38:25 3315 8192000000 10970358224 11388993536 1985805728 19.511 100 78 157 1 2051808800 41320416 24682656
20:38:44 1603 8192000000 10965074096 11391729664 1985455760 19.508 100 69 138 0 2047858848 40572672 21830416
20:38:55 4830 8192000000 10965019392 11394863104 1990764464 19.550 100 77 154 3 2056432432 41554192 24113776
20:39:07 2279 8192000000 10949630288 11380842496 1979831392 19.463 100 73 145 2 2045592528 43040416 22720720
20:39:18 2652 8192000000 10943456912 11365498880 1933094432 19.092 98 78 153 0 1998026976 41774448 23158096
20:39:29 1777 8192000000 10944484544 11364622336 1947143840 19.204 99 72 144 1 2014937904 44356000 23438064
20:39:41 3639 8192000000 10940229056 11359961088 1955524976 19.270 100 75 150 2 2024594096 44575072 24494048
20:39:51 3885 8192000000 10956112096 11374362624 1967090288 19.362 100 76 150 1 2036803888 46152816 23560784
20:40:04 5757 8192000000 10954857168 11378647040 1973310368 19.412 100 78 156 1 2044889440 46347280 25231792
20:40:18 3380 8192000000 10965243488 11387838464 1977936272 19.448 100 68 135 1 2045240288 45156768 22147248
20:40:30 5025 8192000000 10944810512 11368939520 1959521520 19.302 99 64 128 0 2024510320 44208960 20779840
20:40:44 4118 8192000000 10924675888 11344064512 1918430688 18.974 98 77 152 1 1986304672 44602160 23271824
20:40:56 1912 8192000000 10942668256 11353124864 1950432352 19.230 100 81 162 1 2020978912 44771408 25775152
20:41:06 2876 8192000000 10948317440 11365675008 1959947968 19.306 100 82 164 2 2033790528 48151696 25690864
20:41:17 3045 8192000000 10939768384 11354718208 1955634544 19.271 100 81 162 2 2024284048 43505680 25143824
20:41:27 5084 8192000000 10924860400 11341340672 1933703952 19.096 99 70 138 1 1999342272 43712400 21925920
20:41:39 2998 8192000000 10941505536 11361239040 1958163808 19.291 100 75 147 0 2025586832 44611168 22811856
20:41:49 4449 8192000000 10937225616 11359940608 1962303296 19.324 100 69 135 1 2022659280 39134256 21221728
20:42:01 11230 8192000000 10903939216 11338276864 1902802224 18.849 97 47 94 1 1958149392 39909296 15437872
20:42:20 2530 8192000000 10938073072 11354980352 1937249376 19.125 99 67 132 0 1999170976 40949600 20972000
20:42:29 9420 8192000000 10904627904 11336228864 1933038944 19.091 100 46 92 2 1988350640 39880672 15431024
20:42:46 15623 8192000000 10889836592 11329740800 1917404080 18.966 99 38 76 2 1969391520 39171488 12815952
20:43:09 9548 8192000000 10885192192 11320963072 1894444592 18.782 98 41 82 1 1947429344 39287104 13697648
20:43:27 8673 8192000000 10903468224 11342786560 1926815888 19.041 100 39 77 2 1988399552 48580208 13003456
20:43:42 14966 8192000000 10904790176 11343843328 1934265584 19.101 100 35 69 1 1991023072 44673872 12083616
20:44:05 17820 8192000000 10889889024 11346767872 1932958720 19.091 100 36 72 0 1987988128 42071584 12957824
20:44:30 29638 8192000000 10884902000 11329200128 1894651552 18.783 98 22 44 2 1939019616 36616016 7752048
20:45:06 27358 8192000000 10887402000 11336794112 1919698016 18.984 100 24 48 0 1968766800 40412432 8656352
20:45:41 20414 8192000000 10871492384 11314593792 1863890352 18.535 97 23 45 1 1920506832 47498624 9117856
20:46:11 38730 8192000000 10856308896 11303100416 1858394288 18.490 97 19 38 0 1901912256 36560096 6957872
20:46:57 25996 8192000000 10820494368 11265990656 1789871472 17.931 94 16 32 0 1825495680 30236208 5388000
20:47:32 19462 8192000000 10801502880 11244265472 1842859952 18.364 98 19 38 0 1867541456 19215520 5465984
20:47:58 25817 8192000000 10803823024 11242246144 1823914528 18.210 97 23 46 0 1844637088 13656784 7065776
20:48:36 30635 8192000000 10831274720 11265196032 1884657072 18.703 100 35 70 0 1907633952 12764016 10212864
20:49:14 54702 8192000000 10847529776 11302416384 1903015344 18.851 100 13 26 2 1926724816 19416032 4293440
20:50:15 76761 8192000000 10828200096 11296059392 1825301776 18.221 96 9 19 1 1855207584 26780288 3125520
20:51:38 87951 8192000000 10841967120 11287523328 1883889552 18.697 99 6 12 0 1901796128 16572304 1334272
20:53:23 38498 8192000000 10856872752 11289247744 1915635216 18.952 100 47 92 5 1936538400 7869536 13033648
20:54:12 75232 8192000000 10864067488 11319431168 1929033936 19.059 100 19 38 1 1946498352 12248448 5215968
20:55:39 54182 8192000000 10883119744 11343589376 1940188368 19.148 100 11 23 0 1957736896 14537888 3010640
20:56:40 88391 8192000000 10902286960 11351269376 1930707504 19.073 99 8 16 1 1949965824 17319600 1938720
20:58:15 184997 8192000000 10910502464 11381829632 1886087360 18.714 96 11 22 0 1908209760 19407584 2714816
21:01:26 81699 8192000000 10901210512 11348512768 1977828272 19.448 100 29 58 0 1991253968 5988624 7437072
21:02:54 38813 8192000000 10899299376 11349364736 1955870656 19.273 99 38 76 0 1975297728 8448080 10978992
21:03:50 43700 8192000000 10913085632 11361247232 1975813984 19.432 100 35 70 0 1994341760 8880752 9647024
21:04:40 28658 8192000000 10906957904 11359674368 1979401328 19.460 100 27 54 0 1994895968 8182384 7312256
21:05:15 23594 8192000000 10906555168 11373801472 1986203120 19.514 100 29 57 3 2004826912 10044928 8578864
21:05:48 38614 8192000000 10929265392 11381481472 1993748128 19.573 100 29 59 0 2008300832 6355264 8197440
21:06:36 87949 8192000000 10930322496 11391619072 1984563712 19.501 99 28 56 0 2002871872 10793696 7514464
21:08:16 45200 8192000000 10931104672 11400306688 1983827872 19.495 99 15 28 1 2000703424 12748416 4127136
21:09:07 65288 8192000000 10916269968 11391700992 1962945024 19.329 98 16 32 0 1981499296 13635712 4918560
21:10:41 26774 8192000000 10910744752 11371487232 1974699824 19.423 100 13 26 1 1998735952 20211328 3824800
21:11:14 70998 8192000000 10911993120 11375251456 1982908096 19.488 100 16 34 1 2003219040 15167728 5143216
21:12:32 74869 8192000000 10924082816 11385864192 1954832848 19.265 98 14 28 2 1970711072 11698912 4179312
21:14:38 54598 8192000000 10909659904 11393789952 1965769728 19.352 99 6 13 0 1978725216 11286320 1669168
21:15:45 50678 8192000000 10920099312 11395178496 1991535872 19.556 100 16 32 0 2006274688 10583008 4155808
21:16:48 92202 8192000000 10891325600 11358519296 1929246528 19.061 97 9 18 1 1952372272 20547872 2577872
21:18:28 17941 8192000000 10931508192 11380551680 1972887872 19.408 99 42 83 2 1995034944 10072976 12074096
21:18:55 28274 8192000000 10899715056 11362107392 1925110576 19.028 97 48 94 4 1949752320 11440080 13201664
21:19:30 79983 8192000000 10900571776 11361800192 1899787536 18.825 96 27 54 2 1919189040 12307872 7093632
21:20:56 76911 8192000000 10867292032 11316748288 1827638592 18.240 93 18 36 0 1844297024 11324720 5333712
21:22:19 40964 8192000000 10877048784 11332022272 1919323952 18.981 99 30 60 3 1940425136 12484400 8616784
21:23:07 55465 8192000000 10839972800 11305222144 1815610720 18.142 93 30 60 2 1840945888 16565296 8769872
21:24:12 56521 8192000000 10869222560 11322798080 1883806720 18.696 98 11 21 2 1901441456 14576432 3058304
21:25:15 42875 8192000000 10853019568 11302912000 1872062624 18.601 97 31 61 0 1895043440 14999152 7981664
21:26:04 68521 8192000000 10880290272 11333054464 1902206416 18.844 98 36 72 2 1927473424 15259440 10007568
21:27:55 101195 8192000000 10838922320 11294720000 1875409728 18.628 97 18 36 0 1892859104 13017552 4431824
21:29:48 43638 8192000000 10889377088 11337515008 1927246448 19.045 99 24 48 2 1941840544 8191376 6402720
21:30:38 36160 8192000000 10876216704 11329646592 1934614992 19.104 99 46 88 2 1959139552 11695216 12829344
21:31:20 6494 8192000000 10869854000 11322572800 1922687616 19.008 99 36 72 0 1943921584 11621984 9611984
21:31:34 4935 8192000000 10888096528 11329818624 1941860320 19.162 100 47 90 0 1965464640 11381424 12222896
21:31:46 12853 8192000000 10892015696 11340468224 1951328448 19.237 100 34 68 1 1972163264 11678416 9156400
21:32:06 31655 8192000000 10860551312 11320668160 1909120800 18.900 98 42 82 2 1934684080 14238512 11324768
21:32:54 43171 8192000000 10854656768 11331014656 1920227792 18.989 99 14 28 1 1934192720 10268208 3696720
21:34:09 49704 8192000000 10858657024 11317493760 1861616960 18.516 96 16 30 1 1878001248 12051296 4332992
21:35:08 74676 8192000000 10864980640 11335315456 1918789472 18.977 99 17 34 1 1943983264 19168192 6025600
21:36:32 62999 8192000000 10861604272 11325427712 1909510944 18.903 99 14 28 2 1932048176 18379856 4157376
21:37:43 42283 8192000000 10851920848 11323224064 1866066064 18.552 96 19 38 2 1890318368 18776208 5476096
21:38:33 61753 8192000000 10860755872 11339075584 1891699232 18.759 98 14 28 0 1916740976 20820832 4220912
21:39:42 39865 8192000000 10861604800 11345055744 1897907984 18.809 98 13 27 0 1925478544 23838272 3732288
21:40:31 40332 8192000000 10855371680 11316621312 1892685472 18.767 98 10 17 0 1919126720 23090784 3350464
21:41:35 25284 8192000000 10874373920 11334696960 1943841840 19.177 100 42 84 0 1971267728 14469680 12956208
21:42:17 58168 8192000000 10886870992 11341725696 1930351744 19.070 99 16 32 0 1949156448 14344512 4460192
21:43:22 64029 8192000000 10866610416 11334852608 1917710352 18.968 98 13 26 2 1934317104 13108256 3498496
21:44:32 39315 8192000000 10889170032 11337809920 1933891728 19.098 99 32 64 1 1950370368 7635568 8843072
21:45:21 15430 8192000000 10896155248 11342467072 1942514544 19.167 99 55 108 1 1967102672 9088240 15499888
21:45:42 73437 8192000000 10876836384 11352645632 1912427120 18.926 98 23 46 2 1929983632 11219200 6337312
21:47:04 67660 8192000000 10881958656 11335565312 1917888128 18.970 98 18 36 0 1935085952 12564896 4632928
21:48:18 73442 8192000000 10888742032 11351638016 1944778736 19.185 99 17 34 0 1961492464 12118080 4595648
21:49:38 43924 8192000000 10908129248 11364392960 1955315872 19.269 99 41 82 2 1978137744 11519728 11302144
21:50:34 123423 8192000000 10900750336 11381313536 1950068672 19.227 99 25 50 1 1970208224 13145680 6993872
21:52:44 21129 8192000000 10904492720 11378225152 1955214800 19.268 99 20 40 1 1978348560 17269840 5863920
21:53:12 33166 8192000000 10899713440 11387797504 1976137936 19.434 100 10 20 1 1995422352 16560592 2723824
21:54:48 37563 8192000000 10894621872 11377348608 1975465920 19.429 100 9 18 2 1990864608 12740208 2658480
21:55:44 51444 8192000000 10901010736 11374690304 1976782880 19.439 100 12 24 1 1992227472 11978816 3465776
21:57:00 51681 8192000000 10882796208 11369594880 1940916512 19.154 98 14 28 1 1954454656 9829216 3708928
21:57:58 78894 8192000000 10912501568 11385802752 1963068320 19.330 99 11 22 0 1972567984 7109984 2389680
21:59:42 45809 8192000000 10915858368 11388657664 1985831248 19.511 100 20 39 4 2003431152 11952192 5647712
22:00:50 47047 8192000000 10895252976 11358339072 1925458560 19.031 97 15 30 0 1940219440 11254576 3506304
22:01:46 44424 8192000000 10924970768 11382771712 1965943920 19.353 99 31 62 0 1985598608 10979168 8675520
22:02:38 41187 8192000000 10908893456 11380117504 1962824736 19.328 99 15 30 2 1977559536 10622592 4112208
22:03:29 95395 8192000000 10921661776 11385663488 1914565584 18.943 96 18 36 1 1941784144 22018160 5200400
22:05:11 46499 8192000000 10901706416 11388006400 1955286656 19.269 99 23 46 1 1978321824 16092544 6942624
22:06:14 114811 8192000000 10894820720 11353063424 1814832560 18.135 92 8 16 0 1825982720 8766144 2384016
22:08:15 46386 8192000000 10889585904 11364237312 1937243504 19.125 99 24 48 2 1958603824 14251280 7109040
22:09:09 86100 8192000000 10884929552 11352428544 1865140832 18.545 95 3 6 1 1884013840 16603088 2269920
22:10:47 154407 8192000000 10862480640 11327606784 1809442160 18.091 92 17 34 1 1829021968 14247280 5332528
22:13:28 109682 8192000000 10850105312 11332751360 1896598896 18.799 98 19 38 2 1915872336 14141280 5132160
22:15:29 11282 8192000000 10844620160 11327680512 1909970960 18.906 99 5 10 0 1924822864 13639200 1212704
22:15:47 54341 8192000000 10846042688 11321044992 1855053952 18.463 96 15 30 1 1867033200 7474576 4504672
22:17:05 61148 8192000000 10871059024 11333001216 1919629344 18.984 99 12 24 0 1938911680 15860512 3421824
22:19:18 79423 8192000000 10861020752 11347640320 1936187280 19.116 100 14 28 1 1962599504 21593856 4818368
22:21:05 37501 8192000000 10842251632 11314954240 1912603248 18.928 99 13 26 1 1924168816 7555536 4010032
22:21:48 53971 8192000000 10822639904 11303366656 1852633216 18.444 96 14 28 0 1866656320 9732720 4290384
22:23:20 55923 8192000000 10802517520 11269705728 1806277104 18.065 95 5 9 0 1814205520 6589664 1338752
22:24:24 41503 8192000000 10825163360 11278499840 1844137248 18.374 97 18 36 0 1856189344 7206096 4846000
22:25:12 74411 8192000000 10825490720 11281891328 1821711792 18.192 96 27 53 2 1837823136 8648304 7463040
22:26:57 25867 8192000000 9485996672 9793130496 636762640 7.212 34 6 10 1 644332592 5980496 1589456

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 23-12-2020 22:28:40 to 23-12-2020 22:29:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 125 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-12-2020 22:29:11 to 23-12-2020 22:29:13.

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          252964
MON$OLDEST_ACTIVE               252965
MON$OLDEST_SNAPSHOT             252965
MON$NEXT_TRANSACTION            252965
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                       2041120
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:288: 
:289: mscs-test-161.budzdorov.ru    Wed Dec 23 22:27:31 2020
:290:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:291: 
--- end of diff output ---

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

23.12.20 22:29:14. 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
2020-12-23 22:29:17 No severe PSQL-related problems occured
23.12.20 22:29:18. End of report.