explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6anQ

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

Limit (cost=0.42..10.16 rows=1 width=4) (actual time=1.940..1.940 rows=0 loops=1)

  • Buffers: shared hit=3 read=1
  • I/O Timings: read=1.898
2. 1.938 1.938 ↓ 0.0 0 1

Index Scan using index_user_callouts_on_user_id_and_feature_name on public.user_callouts (cost=0.42..10.16 rows=1 width=4) (actual time=1.938..1.938 rows=0 loops=1)

  • Index Cond: ((user_callouts.user_id = 3758012) AND (user_callouts.feature_name = 10))
  • Filter: (user_callouts.dismissed_at > '2019-10-31 08:27:40.807105'::timestamp without time zone)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3 read=1
  • I/O Timings: read=1.898