explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WmTt

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,075.687 ↓ 1.3 509 1

Group (cost=1,956,089.57..1,956,181.34 rows=385 width=23) (actual time=2,074.989..2,075.687 rows=509 loops=1)

  • Group Key: f_rpt_user_scenario_study_metrics_country.scenario_id
2. 7.047 2,076.454 ↓ 1.2 935 1

Gather Merge (cost=1,956,089.57..1,956,179.41 rows=770 width=23) (actual time=2,074.988..2,076.454 rows=935 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.964 2,069.407 ↑ 1.2 312 3 / 3

Sort (cost=1,955,089.55..1,955,090.51 rows=385 width=23) (actual time=2,069.392..2,069.407 rows=312 loops=3)

  • Sort Key: f_rpt_user_scenario_study_metrics_country.scenario_id
  • Sort Method: quicksort Memory: 49kB
  • Worker 0: Sort Method: quicksort Memory: 47kB
  • Worker 1: Sort Method: quicksort Memory: 51kB
4. 26.641 2,068.443 ↑ 1.2 312 3 / 3

Partial HashAggregate (cost=1,955,069.16..1,955,073.01 rows=385 width=23) (actual time=2,068.406..2,068.443 rows=312 loops=3)

  • Group Key: f_rpt_user_scenario_study_metrics_country.scenario_id
5. 647.432 2,041.802 ↑ 52.9 152,398 3 / 3

Hash Join (cost=368.70..1,934,914.81 rows=8,061,740 width=23) (actual time=0.081..2,041.802 rows=152,398 loops=3)

  • Hash Cond: ((f_rpt_user_scenario_study_metrics_country.country_name)::text = (ctl_admin_attribute_access.attribute_value)::text)
6. 1,394.321 1,394.321 ↑ 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,394.321 rows=7,733,377 loops=3)

  • Filter: is_active
  • Rows Removed by Filter: 1,124,365
7. 0.007 0.049 ↑ 10.2 21 3 / 3

Hash (cost=366.01..366.01 rows=215 width=13) (actual time=0.049..0.049 rows=21 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.012 0.042 ↑ 10.2 21 3 / 3

Bitmap Heap Scan on ctl_admin_attribute_access (cost=10.49..366.01 rows=215 width=13) (actual time=0.037..0.042 rows=21 loops=3)

  • Recheck Cond: (((user_id)::text = 'SKar9'::text) AND ((attribute_name)::text = 'country'::text))
  • Heap Blocks: exact=2
9. 0.030 0.030 ↑ 10.2 21 3 / 3

Bitmap Index Scan on attr_acc_usr_id_attr_name_indx (cost=0.00..10.44 rows=215 width=0) (actual time=0.030..0.030 rows=21 loops=3)

  • Index Cond: (((user_id)::text = 'SKar9'::text) AND ((attribute_name)::text = 'country'::text))
Planning time : 0.195 ms
Execution time : 2,076.661 ms