explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1ouu : Fix explain: Audit Logs Missing Instance Representations; plan #jIfj

Settings

Optimization path:

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. 861.554 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)

4. 167.312 167.312 ↑ 7.3 1,992,375 1

Index Only Scan using audit_auditlog_pkey on audit_auditlog (cost=0.43..1,290,276.47 rows=14,478,721 width=4) (actual time=0.008..167.312 rows=1,992,375 loops=1)

  • Heap Fetches: 20180
5. 1,992.375 1,992.375 ↑ 1.0 1 1,992,375

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=1,992,375)

  • Index Cond: (audit_log_id = audit_auditlog.id)
  • Heap Fetches: 1992374
Planning time : 0.133 ms
Execution time : 3,021.358 ms