explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jIfj : Audit Logs Missing Instance Representations

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 3,021.243 ↑ 1.0 1 1

Result (cost=280.72..280.73 rows=1 width=1) (actual time=3,021.243..3,021.243 rows=1 loops=1)

2.          

Initplan (forResult)

3. 3,021.241 3,021.241 ↑ 34,679.0 1 1

Nested Loop Anti Join (cost=0.87..9,704,982.14 rows=34,679 width=0) (actual time=3,021.241..3,021.241 rows=1 loops=1)

  • -> Index Only Scan using audit_auditlog_pkey on audit_auditlog (cost=0.43..1290276.47 rows=14478721 width=4) (actual time=0.008..167.312 rows=1992…
  • Heap Fetches: 20180
  • -> Index Only Scan using audit_instancerepr_pkey on audit_instancerepr (cost=0.43..0.57 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=199…
  • Index Cond: (audit_log_id = audit_auditlog.id)
  • Heap Fetches: 1992374
Planning time : 0.133 ms
Execution time : 3,021.358 ms