explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RbgV

Settings
# exclusive inclusive rows x rows loops node
1. 1.467 8.497 ↓ 86.1 1,033 1

Sort (cost=4,512.39..4,512.42 rows=12 width=1,364) (actual time=8.417..8.497 rows=1,033 loops=1)

  • Output: id, user_id, options, report_code, created_at, updated_at, sort, columns, report_output, status, job_id, repository, name, description, count_notification, display_notification, active_notification
  • Sort Key: reports_configurations.created_at
  • Sort Method: quicksort Memory: 1682kB
2. 6.163 7.030 ↓ 86.1 1,033 1

Bitmap Heap Scan on public.reports_configurations (cost=449.99..4,512.18 rows=12 width=1,364) (actual time=1.060..7.030 rows=1,033 loops=1)

  • Output: id, user_id, options, report_code, created_at, updated_at, sort, columns, report_output, status, job_id, repository, name, description, count_notification, display_notification, active_notification
  • Recheck Cond: (reports_configurations.user_id = 33451::bigint)
  • Filter: (((reports_configurations.created_at)::date >= '2019-12-30'::date) AND ((reports_configurations.created_at)::date <= '2020-01-29'::date))
  • Rows Removed by Filter: 1327
  • Heap Blocks: exact=756
3. 0.867 0.867 ↑ 1.0 2,360 1

Bitmap Index Scan on index_reports_configurations_on_user_id (cost=0.00..449.98 rows=2,360 width=0) (actual time=0.867..0.867 rows=2,360 loops=1)

  • Index Cond: (reports_configurations.user_id = 33451::bigint)
Planning time : 1.284 ms
Execution time : 8.772 ms