explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 24pz : lognew insert

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 0 1

Insert on lognew (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

2. 0.000 0.000 ↓ 0.0 545,314 1

Seq Scan on log log (cost=0..0 rows=0 width=0) (actual rows=545,314 loops=1)

  • Filter: ((NOT (hashed SubPlan 1)) AND (((appname)::text <> 'IslpSyncer'::text) OR ((status)::text <> 'failure'::text)))
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0 617,823 1

Seq Scan on lognew lognew_1 (cost=0..0 rows=0 width=0) (actual rows=617,823 loops=1)

Planning time : 0.677 ms
Execution time : 7,067.517 ms