explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dc9b

Settings
# exclusive inclusive rows x rows loops node
1. 361,072.899 361,072.899 ↓ 8.6 7,703,430 1

Index Scan using analytics_index_audit_events_on_created_at_and_author_id on public.audit_events (cost=0.57..19,281,632.19 rows=897,504 width=4) (actual time=155,662.365..361,072.899 rows=7,703,430 loops=1)

  • Index Cond: (audit_events.created_at > '2020-03-01 00:00:00'::timestamp without time zone)
  • Filter: (audit_events.details ~* 'ruby/object'::text)
  • Rows Removed by Filter: 33136404
  • Buffers: shared hit=37660003 read=1668821 dirtied=101996 written=7
  • I/O Timings: read=142342.223 write=0.654