explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bDJr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,854.468 ↓ 1.6 607 1

Group (cost=2,190,653.29..2,190,745.06 rows=385 width=23) (actual time=2,853.642..2,854.468 rows=607 loops=1)

  • Group Key: f_rpt_user_scenario_study_metrics_country.scenario_id
2. 6.713 2,855.046 ↓ 1.6 1,251 1

Gather Merge (cost=2,190,653.29..2,190,743.13 rows=770 width=23) (actual time=2,853.640..2,855.046 rows=1,251 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1.369 2,848.333 ↓ 1.1 417 3 / 3

Sort (cost=2,189,653.27..2,189,654.23 rows=385 width=23) (actual time=2,848.313..2,848.333 rows=417 loops=3)

  • Sort Key: f_rpt_user_scenario_study_metrics_country.scenario_id
  • Sort Method: quicksort Memory: 55kB
  • Worker 0: Sort Method: quicksort Memory: 60kB
  • Worker 1: Sort Method: quicksort Memory: 56kB
4. 496.548 2,846.964 ↓ 1.1 417 3 / 3

Partial HashAggregate (cost=2,189,632.89..2,189,636.74 rows=385 width=23) (actual time=2,846.915..2,846.964 rows=417 loops=3)

  • Group Key: f_rpt_user_scenario_study_metrics_country.scenario_id
5. 986.124 2,350.416 ↑ 2.8 3,357,307 3 / 3

Hash Join (cost=392.03..2,166,103.85 rows=9,411,613 width=23) (actual time=0.391..2,350.416 rows=3,357,307 loops=3)

  • Hash Cond: ((f_rpt_user_scenario_study_metrics_country.country_name)::text = (ctl_admin_attribute_access.attribute_value)::text)
6. 1,363.927 1,363.927 ↑ 1.3 7,733,377 3 / 3

Parallel Seq Scan on f_rpt_user_scenario_study_metrics_country (cost=0.00..523,741.62 rows=9,674,088 width=30) (actual time=0.007..1,363.927 rows=7,733,377 loops=3)

  • Filter: is_active
  • Rows Removed by Filter: 1,124,365
7. 0.047 0.365 ↑ 1.0 251 3 / 3

Hash (cost=388.89..388.89 rows=251 width=13) (actual time=0.365..0.365 rows=251 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 20kB
8. 0.250 0.318 ↑ 1.0 251 3 / 3

Bitmap Heap Scan on ctl_admin_attribute_access (cost=10.86..388.89 rows=251 width=13) (actual time=0.096..0.318 rows=251 loops=3)

  • Recheck Cond: (((user_id)::text = 'AJha17'::text) AND ((attribute_name)::text = 'country'::text))
  • Heap Blocks: exact=251
9. 0.068 0.068 ↑ 1.0 251 3 / 3

Bitmap Index Scan on attr_acc_usr_id_attr_name_indx (cost=0.00..10.80 rows=251 width=0) (actual time=0.068..0.068 rows=251 loops=3)

  • Index Cond: (((user_id)::text = 'AJha17'::text) AND ((attribute_name)::text = 'country'::text))
Planning time : 0.382 ms
Execution time : 2,855.280 ms