explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wz2T

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

Nested Loop (cost=0.43..3,277.66 rows=2,260 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • -> Seq Scan on tmp_auditlognotreferenced_28174 (cost=0.00..32.60 rows=2260 width=8) (actual time=0.003..0.004 rows=0 loop
2. 0.000 0.000 ↓ 0.0 0

Index Only Scan using comms_attachment_pkey on comms_attachment (cost=0.43..1.44 rows=1 width=4) (never executed)

  • Index Cond: (attachmentid = tmp_auditlognotreferenced_28174.attachmentid)
  • Heap Fetches: 0
Planning time : 0.808 ms
Execution time : 0.032 ms