explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 85yQ : WHERE NOT EXISTS()

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 2,714.549 ↑ 1.0 1 1

Result (cost=348.54..348.55 rows=1 width=1) (actual time=2,714.549..2,714.549 rows=1 loops=1)

2.          

Initplan (forResult)

3. 554.122 2,714.546 ↑ 27,920.0 1 1

Nested Loop Anti Join (cost=0.87..9,706,937.73 rows=27,920 width=0) (actual time=2,714.546..2,714.546 rows=1 loops=1)

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

Index Only Scan using audit_auditlog_pkey on audit_auditlog (cost=0.43..1,290,477.63 rows=14,480,232 width=4) (actual time=0.007..168.049 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