explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tt3d

Settings
# exclusive inclusive rows x rows loops node
1. 18,236.347 56,953.568 ↓ 553.3 5,623,790 1

HashAggregate (cost=550,846.76..550,948.40 rows=10,164 width=24) (actual time=55,923.645..56,953.568 rows=5,623,790 loops=1)

  • Group Key: country_profiles.country, country_profiles.profile_id
  • Functions: 11
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.289 ms, Inlining 13.136 ms, Optimization 46.848 ms, Emission 25.937 ms, Total 88.211 ms
2.          

Initplan (for HashAggregate)

3. 2,335.125 2,335.125 ↓ 1.4 19,051,903 1

Index Only Scan using research_outputs_16 on research_outputs (cost=0.56..532,621.22 rows=13,461,033 width=8) (actual time=0.033..2,335.125 rows=19,051,903 loops=1)

  • Index Cond: ((output_type = 'article'::text) AND (books = false))
  • Heap Fetches: 0
4. 36,382.096 36,382.096 ↓ 6,207.7 63,125,863 1

Index Scan using country_profiles_0 on country_profiles (cost=0.57..18,174.69 rows=10,169 width=24) (actual time=3,489.920..36,382.096 rows=63,125,863 loops=1)

  • Index Cond: ((research_output_id = ANY ($0)) AND (post_type = 'tweet'::text))
Execution time : 57,133.368 ms