explain.depesz.com

PostgreSQL's explain analyze made readable

Result: btlX

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 7.112 ↑ 1.0 1 1

Result (cost=3.54..3.55 rows=1 width=4) (actual time=7.111..7.112 rows=1 loops=1)

  • Buffers: shared hit=1,041
2.          

Initplan (for Result)

3. 0.003 7.105 ↑ 1.0 1 1

Limit (cost=0.42..3.54 rows=1 width=4) (actual time=7.105..7.105 rows=1 loops=1)

  • Buffers: shared hit=1,041
4. 7.102 7.102 ↑ 4,874.0 1 1

Index Scan using index_snippets_on_id_and_created_at on public.snippets (cost=0.42..15,192.01 rows=4,874 width=4) (actual time=7.102..7.102 rows=1 loops=1)

  • Index Cond: ((snippets.id IS NOT NULL) AND (snippets.created_at >= '2020-05-22 09:12:11.847078+00'::timestamp with time zone) AND (snippets.created_at <= '2020-06-19 00:00:00+00'::timestamp with time zone))
  • Filter: ((snippets.type)::text = 'PersonalSnippet'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1,041