# Elasticsearch not showing data

**URL:** <https://discuss.elastic.co/t/elasticsearch-not-showing-data/159144>\
**Category:** Elasticsearch\
**Created:** [December 3, 2018, 10:34am UTC](https://discuss.elastic.co/t/elasticsearch-not-showing-data/159144 "2018-12-03T10:34:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ganesh1](https://avatars.discourse-cdn.com/v4/letter/g/77aa72/32.png) [@Ganesh1](https://discuss.elastic.co/u/Ganesh1)\
**Post date:** [December 3, 2018, 10:34am UTC](https://discuss.elastic.co/t/elasticsearch-not-showing-data/159144/1 "2018-12-03T10:34:19Z")

</div>

I am trying to link postgres with Elasticsearch using logstash. I am see the data in my logstash console.

C:\Users\Admin\Downloads\logstash-6.5.1\bin\>logstash -f c:\Users\Admin\Desktop\hardata.config  
Sending Logstash logs to C:/Users/Admin/Downloads/logstash-6.5.1/logs which is now configured via log4j2.properties  
[2018-12-03T15:44:49,090][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified  
[2018-12-03T15:44:49,112][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"6.5.1"}  
[2018-12-03T15:44:52,819][WARN][logstash.outputs.elasticsearch] You are using a deprecated config setting "document\_type" set in elasticsearch. Deprecated settings will continue to work, but are sche  
duled for removal from logstash in the future. Document types are being deprecated in Elasticsearch 6.0, and removed entirely in 7.0. You should avoid this feature If you have any questions about this  
, please visit the #logstash channel on freenode irc. {:name=\>"document\_type", :plugin=\>\<LogStash::Outputs::ElasticSearch index=\>"harinfo", id=\>"27c192e63349cbe0fb3bc6bef932d4c411f618d176f29d9a48a2ead  
e75968bc1", hosts=\>[[//localhost:9200](https://localhost:9200)], document\_type=\>"har", enable\_metric=\>true, codec=\>\<LogStash::Codecs::Plain id=\>"plain\_1245b0a6-3abd-42f1-92a6-159d8bf05156", enable\_metric=\>true, charset=\>"UTF-8  
"\>, workers=\>1, manage\_template=\>true, template\_name=\>"logstash", template\_overwrite=\>false, doc\_as\_upsert=\>false, script\_type=\>"inline", script\_lang=\>"painless", script\_var\_name=\>"event", scripted\_up  
sert=\>false, retry\_initial\_interval=\>2, retry\_max\_interval=\>64, retry\_on\_conflict=\>1, action=\>"index", ssl\_certificate\_verification=\>true, sniffing=\>false, sniffing\_delay=\>5, timeout=\>60, pool\_max=\>10  
00, pool\_max\_per\_route=\>100, resurrect\_delay=\>5, validate\_after\_inactivity=\>10000, http\_compression=\>false\>}  
[2018-12-03T15:44:54,413][INFO][logstash.pipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>4, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50}  
[2018-12-03T15:44:55,365][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=\>{:removed=\>, :added=\>[[http://localhost:9200/](http://localhost:9200/)]}}  
[2018-12-03T15:44:55,378][INFO][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck\_url=\>[http://localhost:9200/](http://localhost:9200/), :path=\>"/"}  
[2018-12-03T15:44:55,635][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[http://localhost:9200/](http://localhost:9200/)"}  
[2018-12-03T15:44:55,706][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es\_version=\>6}  
[2018-12-03T15:44:55,710][WARN][logstash.outputs.elasticsearch] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document \_type {:es\_version=\>6}  
[2018-12-03T15:44:55,741][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[//localhost:9200](https://localhost:9200)"]}  
[2018-12-03T15:44:55,765][INFO][logstash.outputs.elasticsearch] Using mapping template from {:path=\>nil}  
[2018-12-03T15:44:55,787][INFO][logstash.outputs.elasticsearch] Attempting to install template {:manage\_template=\>{"template"=\>"logstash-_", "version"=\>60001, "settings"=\>{"index.refresh\_interval"=\>"  
5s"}, "mappings"=\>{"default"=\>{"dynamic\_templates"=\>[{"message\_field"=\>{"path\_match"=\>"message", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false}}}, {"string\_fields"=\>{"ma  
tch"=\>"_", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false, "fields"=\>{"keyword"=\>{"type"=\>"keyword", "ignore\_above"=\>256}}}}}], "properties"=\>{"@timestamp"=\>{"type"=\>"date"  
}, "@version"=\>{"type"=\>"keyword"}, "geoip"=\>{"dynamic"=\>true, "properties"=\>{"ip"=\>{"type"=\>"ip"}, "location"=\>{"type"=\>"geo\_point"}, "latitude"=\>{"type"=\>"half\_float"}, "longitude"=\>{"type"=\>"half\_f  
loat"}}}}}}}}  
[2018-12-03T15:44:56,233][INFO][logstash.pipeline] Pipeline started successfully {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x5c5bcda9 run\>"}  
[2018-12-03T15:44:56,303][INFO][logstash.agent] Pipelines running {:count=\>1, :running\_pipelines=\>[:main], :non\_running\_pipelines=\>}  
[2018-12-03T15:44:56,749][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}  
[2018-12-03T15:44:57,760][INFO][logstash.inputs.jdbc] (0.018156s) select \* from harinfo  
{  
"duration" =\> 3,  
"@timestamp" =\> 2018-12-03T10:14:57.849Z,  
"parent\_url" =\> "[icicibank.com](http://icicibank.com)",  
"@version" =\> "1",  
"url\_id" =\> 3,  
"url" =\> "[image.icicibank.com](http://image.icicibank.com)"  
}  
{  
"duration" =\> 7,  
"@timestamp" =\> 2018-12-03T10:14:57.848Z,  
"parent\_url" =\> "[icicibank.com](http://icicibank.com)",  
"@version" =\> "1",  
"url\_id" =\> 2,  
"url" =\> "[login.icicibank.com](http://login.icicibank.com)"  
}  
{  
"duration" =\> 3,  
"@timestamp" =\> 2018-12-03T10:14:57.850Z,  
"parent\_url" =\> "[infinity.icicibank.com](http://infinity.icicibank.com)",  
"@version" =\> "1",  
"url\_id" =\> 6,  
"url" =\> "abcdefgh.img"  
}  
{  
"duration" =\> 2,  
"@timestamp" =\> 2018-12-03T10:14:57.831Z,  
"parent\_url" =\> "[icicibank.com](http://icicibank.com)",  
"@version" =\> "1",  
"url\_id" =\> 1,  
"url" =\> "[infinity.icicibank.com](http://infinity.icicibank.com)"  
}  
{  
"duration" =\> 4,  
"@timestamp" =\> 2018-12-03T10:14:57.850Z,  
"parent\_url" =\> "[infinity.icicibank.com](http://infinity.icicibank.com)",  
"@version" =\> "1",  
"url\_id" =\> 5,  
"url" =\> "xyzabc.img"  
}  
{  
"duration" =\> 5,  
"@timestamp" =\> 2018-12-03T10:14:57.850Z,  
"parent\_url" =\> "[icicibank.com](http://icicibank.com)",  
"@version" =\> "1",  
"url\_id" =\> 4,  
"url" =\> "icicibank.img"  
}  
[2018-12-03T15:44:59,817][INFO][logstash.pipeline] Pipeline has terminated {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x5c5bcda9 run\>"}

[http://localhost:9200/harinfo](http://localhost:9200/harinfo), It is not showing me any data. Only i can see the index.

{"harinfo":{"aliases":{},"mappings":{"har":{"properties":{"@timestamp":{"type":"date"},"@version":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"duration":{"type":"long"},"parent\_url":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"url":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"url\_id":{"type":"long"}}}},"settings":{"index":{"creation\_date":"1543832098147","number\_of\_shards":"5","number\_of\_replicas":"1","uuid":"ES-CnDdYQCSAGJonu2ZjEg","version":{"created":"6050199"},"provided\_name":"harinfo"}}}}

Data is not showing in Elasticsearch.

---

<div class="post-metadata">

**Author:** ![Ganesh1](https://avatars.discourse-cdn.com/v4/letter/g/77aa72/32.png) [@Ganesh1](https://discuss.elastic.co/u/Ganesh1)\
**Post date:** [December 3, 2018, 11:02am UTC](https://discuss.elastic.co/t/elasticsearch-not-showing-data/159144/2 "2018-12-03T11:02:13Z")

</div>

I am able to get my db data into kibana.

---

<div class="post-metadata">

**Author:** ![balumurari1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/balumurari1/32/39203_2.png) [@balumurari1](https://discuss.elastic.co/u/balumurari1)\
**Post date:** [December 5, 2018, 10:50am UTC](https://discuss.elastic.co/t/elasticsearch-not-showing-data/159144/3 "2018-12-05T10:50:55Z")

</div>

if you could provide input code, it will be east to provide solution

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 2, 2019, 10:51am UTC](https://discuss.elastic.co/t/elasticsearch-not-showing-data/159144/4 "2019-01-02T10:51:00Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.