Skip to content

Instantly share code, notes, and snippets.

{"@timestamp":"2023-02-09T09:53:53.101Z","@version":"1","message":"Received new ObjectTypeCreateEvent for OBJECT_f324c890-c346-4322-8da4-babfd298b192_abc, on channel: Cached Rabbit Channel: AMQChannel(amqp://user@100.67.149.17:5672/,2), conn: Proxy@4dfb114e Shared Rabbit Connection: SimpleConnection@1267c7b1 [delegate=amqp://user@100.67.149.17:5672/, localPort= 36446], tag: 1, redelivered: true, deliveryMode: PERSISTENT","logger_name":"cloud.celonis.ems2.factory.execution.pipeline.listener.ObjectTypeListener","thread_name":"rabbitListenerExecutor4","level":"INFO","level_value":20000,"application-name":"ems2-factory-execution","teamId":"a851bd3e-a5ce-44ee-819c-8495be78e895","teamDomain":"ems2-test","userId":"ANONYMOUS","dd.trace_id":"4868608008179684208","dd.span_id":"6088863369206688392","cloud-core-version":"14.10.0"}
{"@timestamp":"2023-02-09T09:53:53.110Z","@version":"1","message":"Remote application on http://integration/integration/api/internal/api/business-graph[GET] responded with 404 : Object 'DataPoo
EXPLAIN VERBOSE select count(*)
from
(
SELECT DISTINCT
VBAK_VBAP._CASE_KEY
FROM
__TEST_CELONIS_VBAK_VBAP as VBAK_VBAP
JOIN __TEST_CELONIS_VBFA AS VBFA ON
VBAK_VBAP.MANDT = VBFA.MANDT AND
VBAK_VBAP.VBELN = VBFA.VBELV AND
explain verbose select count(*)
from
(
SELECT DISTINCT
VBAK_VBAP.VBELN
FROM
__TEST_CELONIS_VBAK_VBAP as VBAK_VBAP
JOIN __TEST_CELONIS_VBFA AS VBFA ON
VBAK_VBAP.MANDT = VBFA.MANDT AND
VBAK_VBAP.VBELN = VBFA.VBELV AND
select path_id,operator_name,count(case when counter_name='execution time (us)' then operator_id end),
sum(case when counter_name='rows processed' then counter_value end) rows_processed,
sum(case when counter_name='rows produced' then counter_value end) rows_produced,
sum(case when counter_name='rle rows produced' then counter_value end) rle_rows_prd,
sum(case when counter_name='rows pruned by valindex' then counter_value end) Rows_pruned,
sum(case when counter_name='rows filtered by SIPs expression' then counter_value end) SIPS_filtered
from dc_Execution_engine_profiles
where transaction_id=45035996343980338 and statement_id=4
group by 1,2 order by 1,2;
@vyaslav
vyaslav / k3d-argocd-install.yaml
Created January 20, 2021 16:26
k3d-argocd-install.yaml
# This is an auto-generated file. DO NOT EDIT
apiVersion: apiextensions.k8s.io/v1beta1
kind: CustomResourceDefinition
metadata:
labels:
app.kubernetes.io/name: applications.argoproj.io
app.kubernetes.io/part-of: argocd
name: applications.argoproj.io
spec:
group: argoproj.io
@vyaslav
vyaslav / add_to_bashrc.sh
Created October 10, 2020 19:32
aliases for kubectl with autocomplete
source <(kubectl completion bash)
__start_kubectl_cust()
{
local cur prev words cword
declare -A flaghash 2>/dev/null || :
if declare -F _init_completion >/dev/null 2>&1; then
_init_completion -s || return
else
__kubectl_init_completion -n "=" || return
fi