Count(*) takes at least 2 minutes on skladnica-load/events

[zverevgeny]

select count(*) from `skladnica-load/events`

┌──────────────┐
│ column0      │
├──────────────┤
│ 596968665124 │
└──────────────┘

Statistics:
query_phases {
  duration_us: 664703889
  table_access {
    name: "/ydb_experimental_vla/yc.yaem.service-cloud/etn3gtlmdjv3kgkljdqn/skladnica-load/events"
    reads {
      rows: 89873380
      bytes: 1437974080
    }
  }
  cpu_time_us: 2245885317
}
compilation {
  from_cache: true
}

[ivanmorozov333]

3 minutes
@zverevgeny
in ur case there was undefined parallel request

[zverevgeny]

without concurrent queries it takes 2 min
Statistics:
query_phases {
duration_us: 127063223
table_access {
name: "/ydb_experimental_vla/yc.yaem.service-cloud/etn3gtlmdjv3kgkljdqn/skladnica-load/events"
reads {
rows: 90133975
bytes: 1442143600
}
}
cpu_time_us: 1254128038
}
compilation {
duration_us: 58607
cpu_time_us: 53854
}
process_cpu_time_us: 95
total_duration_us: 127125682
total_cpu_time_us: 1254181987