explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nVNH

Settings
# exclusive inclusive rows x rows loops node
1. 1.239 8.311 ↓ 86.1 1,033 1

Sort (cost=4,512.39..4,512.42 rows=12 width=1,364) (actual time=8.249..8.311 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.299 7.072 ↓ 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=0.909..7.072 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.773 0.773 ↑ 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.773..0.773 rows=2,360 loops=1)

  • Index Cond: (reports_configurations.user_id = 33451::bigint)