As said, insert/update/delete in DB are not visible to the JDBC plugin and they can not be detected by the JDBC plugin. The metric is for the SQL select statement the plugin is using. If you mean insert/update/delete in ES, there is no such thing, there are indexing operations performed in bulk, which can be monitored by ES monitoring plugins or ES metrics.
Jörg On Mon, Jan 19, 2015 at 11:55 AM, 4m7u1 <[email protected]> wrote: > Okay. Thanks a lot. Is there any other way in which I can see the metrics. > If I have indexed my db with 20000 records in Elasticsearch, for that I can > see the metrics as above. But say that, I have made one new > insert/update/delete into my db and that is picked by elasticsearch, is > there any way in which I can see the time taken for that one particular > insert/update/delete? > > On Monday, January 19, 2015 at 3:36:47 PM UTC+5:30, Jörg Prante wrote: >> >> The numbers in brackets mean the average numbers over the last 1 / 5 / 15 >> minutes. This useful for a long running indexer. >> >> The "elapsed" time is the time since this metric counter is active. >> >> Jörg >> >> On Mon, Jan 19, 2015 at 10:41 AM, 4m7u1 <[email protected]> wrote: >> >>> Hi, >>> I've got a small doubt again. >>> >>> *[2015-01-19 15:06:08,410][INFO ][river.jdbc.RiverMetrics ] pipeline >>> org.xbib.elasticsearch.plugin.jdbc.RiverPipeline@1cede282 complete: river >>> jdbc/my_test_river metrics: 340000 rows, 170.35844075426294 mean, >>> (147.82076731011736 30.98274869393544 10.409690875802436), ingest metrics: >>> elapsed 8 seconds, 57.57 MB bytes, 177.0 bytes avg, 6.848 MB/s* >>> >>> So here, >>> Average no of rows picked per second is 170 and what do the values in >>> the brackets mean (147.82076731011736 30.98274869393544 >>> 10.409690875802436). >>> and also ingest metrics: elapsed 8 seconds mean that the total time >>> taken in the corresponding poll is 8 seconds? >>> >>> Thank you. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "elasticsearch" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit https://groups.google.com/d/ >>> msgid/elasticsearch/4c9f209b-cefb-4709-a2b9-a98f971eecb9% >>> 40googlegroups.com >>> <https://groups.google.com/d/msgid/elasticsearch/4c9f209b-cefb-4709-a2b9-a98f971eecb9%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/139a365e-aca7-45e3-b1d7-7bd3a08dfbda%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/139a365e-aca7-45e3-b1d7-7bd3a08dfbda%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoH8bvDfBAxsP0vi3GKpzDfTs1_dpH%3D62br9SaJYUBHwsA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
