explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9dcM

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

GroupAggregate (cost=0.00..13.42 rows=1 width=16) (actual time=0.031..0.031 rows=1 loops=1)

  • Output: count(inserted_at), (date_trunc('month'::text, inserted_at))
  • Group Key: date_trunc('month'::text, up.inserted_at)
2. 0.024 0.024 ↓ 18.0 18 1

Seq Scan on public.user_passphrases up (cost=0.00..13.40 rows=1 width=16) (actual time=0.009..0.024 rows=18 loops=1)

  • Output: date_trunc('month'::text, inserted_at), inserted_at
  • Filter: (date_trunc('month'::text, up.inserted_at) = date_trunc('month'::text, now()))
  • Rows Removed by Filter: 5
Planning time : 0.113 ms
Execution time : 0.065 ms