@app.route('/datatab')
def doQuery():
        conn = connectToDB()
        cur1 = conn.cursor()
        cur1.execute('select datid,datname,pid,usesysid,usename from pg_stat_activity;')
        results1 = cur1.fetchall()
        cur2 = conn.cursor()
        cur2.execute('select datid,datname,pid,usesysid,usename from pg_stat_activity;')
        results2 = cur2.fetchall()
        cur3 = conn.cursor()
        cur3.execute('select relid,indexrelid,schemaname,relname,indexrelname from pg_statio_all_indexes;')
        results3 =cur3.fetchall()
        cur4 = conn.cursor()
        cur4.execute('select datid,datname,numbackends,xact_commit,xact_rollback from pg_stat_database;')
        results4 = cur4.fetchall()

        return render_template('datatable.html', doQuery=results1, doQuery1=results2, doQuery2=results3, doQuery3=results4)