explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sqBU

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

Aggregate (cost=5,109.83..5,109.84 rows=1 width=8) (actual time=0.025..0.025 rows=1 loops=1)

2. 0.018 0.018 ↓ 0.0 0 1

Index Scan using index_ci_builds_on_user_id on ci_builds (cost=0.57..5,109.18 rows=257 width=4) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((user_id >= 1000000) AND (user_id <= 1001250))
  • Filter: ((created_at >= '2020-02-24 07:25:33.436925'::timestamp without time zone) AND (created_at <= '2020-03-23 07:25:33.436996'::timestamp without time zone) AND ((type)::text = 'Ci::Build'::text))
Planning time : 0.340 ms
Execution time : 0.065 ms