Posts

Showing posts from February, 2020

Handling postgres sql

This is about to using postgressql open postgres sql path if its in linux {psql path}/bin/.psql -h localhost -d  {database name} \dt for showing tables \d {tablename}  to show details of table To understand the query explain paln command be like below explain analyze(query); This will show the query running with sequential sacan or indexed scan and query cost details etc..