explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D9fb

Settings
# exclusive inclusive rows x rows loops node
1. 168,268.011 231,303.458 ↓ 1.3 244 1

GroupAggregate (cost=533,299.13..533,303.56 rows=182 width=15) (actual time=138,023.775..231,303.458 rows=244 loops=1)

  • Group Key: country_profiles.country
  • Functions: 12
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.450 ms, Inlining 11.214 ms, Optimization 40.667 ms, Emission 24.265 ms, Total 78.597 ms
2.          

Initplan (for GroupAggregate)

3. 2,352.821 2,352.821 ↓ 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.032..2,352.821 rows=19,051,903 loops=1)

  • Index Cond: ((output_type = 'article'::text) AND (books = false))
  • Heap Fetches: 0
4. 26,109.105 60,682.626 ↓ 181,918.9 63,125,863 1

Sort (cost=677.91..678.78 rows=347 width=24) (actual time=53,929.488..60,682.626 rows=63,125,863 loops=1)

  • Sort Key: country_profiles.country
  • Sort Method: external merge Disk: 2,149,520kB
5. 34,573.521 34,573.521 ↓ 181,918.9 63,125,863 1

Index Scan using country_profiles_0 on country_profiles (cost=0.57..663.27 rows=347 width=24) (actual time=3,481.474..34,573.521 rows=63,125,863 loops=1)

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