event.duration incorrect value in elastick

[yanshin (Андрей Яньшин)]

Hello!
can you help me solve the problem?
there are PG SQL logs in elastica.
there is an event.duration field that displays an incorrect value.for example, in the postgresql logs duration: 818.585 ms
in elastic

the log provider is filebeat - I uploaded the logs to a file, there is no error.
The Numeric variable type is long in the index template.

[Musab_Dogan]

Update the field.format in kibana => data view => index pattern => field_name. Save it and send another screenshot and let me check for you.

[yanshin (Андрей Яньшин)]

interesting result

[stephenb (Stephen Brown)]

@yanshin

Can a little tricky there I suspect that value is actually Microseconds or perhaps even nanoseconds

if you are saying that 818585024 is supposed to be 818 ms then that then the value is actually nanosecods

If microseconds

[yanshin (Андрей Яньшин)]

@stephenb @Musab_Dogan
Thank you for your help!

[Musab_Dogan]

You're welcome. Happy to hear it worked!