fishScript.com d
Home| Progetto| Web| Faq| Acronimi

Argomenti




Oracle... Script: dbms_output.put_line



PLSQL... Script: Scrivere su un file

Shell scripting... Script: Compact if construct

A User Agent, like a web browser, uses HTTP to request a HTML document



In programming the danger of exploring the small details of coding is that you get obsessed with every line of code you write, thereby greatly reducing productivity.
In general, is not worth obsessing over code.
On the other hand you should code with deliberation and intent. Steven Feurstein Oracle Magazine July /August 2004

A User Agent, like a web browser, uses HTTP to request a HTML document

PostgreSQL

Home >PostgreSQL > PostgreSQL determine database uptime

Stampa  Stampa


To determine when database has been start up:
postgres=#  select pg_postmaster_start_time();
   pg_postmaster_start_time    
-------------------------------
 2012-03-04 14:53:20.889366+00
(1 row)
To determine how long is up:
postgres=# SELECT date_trunc('second',current_timestamp - pg_postmaster_start_time())  db_uptime;
    db_uptime     
------------------
 68 days 19:31:12
(1 row)





Tutorial
PostgreSQL determine database uptime  [PostgreSQL] 
Postgres check database is Master or Replica ways to check database replication role [PostgreSQL] 
Ordering by highest or lowest value of multiple columns PostgreSQL functions in order by clause [PostgreSQL] 
Posgresql how disable and renable foreign constraints forcing data into a table ignoring foreign keys (or trigger) [PostgreSQL] 
Comandi
date and timestamp simple Using date and timestamp  [PostgreSQL] 
Add time to a date date function operation [PostgreSQL] 
How set a default schema working away in your postgreSQL session [PostgreSQL] 
postgres tip: how re-execute a query every n second a nice postgres shell command [PostgreSQL] 
Grouping data by the week example date_trunc function, trimming days by the week [PostgreSQL] 
How get PosgreSQL table size pg_total_relation_size function [PostgreSQL] 
PostgreSQL determine database size pg_database_size function returns database size  [PostgreSQL] 
PostgreSQL enable autostart at reboot on Centos / Redhat Configure autostart after reboot [PostgreSQL] 

signal Marco Magnani marcomagnani@fishscript.com



Cerca





Anger is creative, depression is useless.
Dyson, Freeman J.


Anger is creative, depression is useless.
Dyson, Freeman J.




Oracle... Definizioni: Schema and user





fishScript.Com is accessible by Mobile access technology as mobile phones, Palm and Pocket PC .

Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect

Last modified: 2017-11-30 amministratore@fishscript.comNico and Marco Magnani Software Production
Home|About this Site © 2003-2008 www.fishScript.com ®