explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oNL3

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.025 ↑ 1.0 1 1

GroupAggregate (cost=0.15..8.20 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=1)

  • Output: count(inserted_at), (date_trunc('week'::text, inserted_at))
  • Group Key: date_trunc('week'::text, up.inserted_at)
2. 0.020 0.020 ↓ 4.0 4 1

Index Only Scan using user_passphrases_inserted_at_index on public.user_passphrases up (cost=0.15..8.18 rows=1 width=16) (actual time=0.017..0.020 rows=4 loops=1)

  • Output: date_trunc('week'::text, inserted_at), inserted_at
  • Index Cond: ((up.inserted_at >= (now() - '7 days'::interval)) AND (up.inserted_at <= now()))
  • Filter: (date_trunc('week'::text, up.inserted_at) = date_trunc('week'::text, now()))
  • Heap Fetches: 4
Planning time : 0.103 ms
Execution time : 0.052 ms