explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rXyX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=1,773,566.61..1,773,566.62 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using index_ci_builds_on_user_id on ci_builds (cost=0.57..1,773,395.32 rows=68,518 width=4) (actual rows= loops=)

  • Index Cond: ((user_id >= 1) AND (user_id <= 1250))
  • 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))