explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q7Oa : Optimization for: plan #g3ZrB

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 12,584.063 12,584.063 ↑ 4.5 783,830 1

Filter: (((aea_1.ev_id IS NOT NULL) AND (evs.ev_id IS NULL)) OR (aea_1.ev_id IS NULL))Rows Removed by Filter: 406230-> Seq Scan on audit_evs_all aea_1 (cost=0.00..556,102.84 rows=3,538,335 width=16) (actual time=65.991..12,584.063 rows=783,830 loops=1)

Planning time : 13,876.809 ms
Execution time : 20,859.007 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
audit_evs_all_arc_tr 5,602.661 ms 300 18.676 ms