explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Ko4

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

Limit (cost=0.42..4.45 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=3
2. 0.012 0.012 ↓ 0.0 0 1

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

  • Index Cond: ((user_callouts.user_id = 3,758,012) AND (user_callouts.feature_name = 12))
  • Filter: (user_callouts.dismissed_at > '2019-10-31 08:27:40.807105'::timestamp without time zone)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=3