explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jyZL

Settings
# exclusive inclusive rows x rows loops node
1. 664.211 4,200.737 ↑ 1.0 1 1

Aggregate (cost=157,991.70..157,991.71 rows=1 width=8) (actual time=4,200.737..4,200.737 rows=1 loops=1)

  • Buffers: shared hit=765916 read=99258
  • I/O Timings: read=2249.391
2. 3,536.526 3,536.526 ↓ 1.2 7,703,430 1

Index Only Scan using index_audit_events_for_ruby_object_in_details on public.audit_events (cost=0.43..141,628.80 rows=6,545,159 width=0) (actual time=0.168..3,536.526 rows=7,703,430 loops=1)

  • Heap Fetches: 886294
  • Buffers: shared hit=765916 read=99258
  • I/O Timings: read=2249.391