explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3mSD

Settings
# exclusive inclusive rows x rows loops node
1. 168,067.422 231,293.916 ↓ 1.1 244 1

GroupAggregate (cost=535,224.74..535,237.40 rows=216 width=15) (actual time=138,604.645..231,293.916 rows=244 loops=1)

  • Group Key: country_profiles.country
  • Functions: 12
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.401 ms, Inlining 13.894 ms, Optimization 42.904 ms, Emission 24.285 ms, Total 83.485 ms
2.          

Initplan (for GroupAggregate)

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

  • Index Cond: ((output_type = 'article'::text) AND (books = false))
  • Heap Fetches: 0
4. 26,261.287 60,885.786 ↓ 45,089.9 63,125,863 1

Sort (cost=2,603.52..2,607.02 rows=1,400 width=24) (actual time=54,127.173..60,885.786 rows=63,125,863 loops=1)

  • Sort Key: country_profiles.country
  • Sort Method: external merge Disk: 2,149,520kB
5. 34,624.499 34,624.499 ↓ 45,089.9 63,125,863 1

Index Scan using country_profiles_0 on country_profiles (cost=0.57..2,530.36 rows=1,400 width=24) (actual time=3,452.858..34,624.499 rows=63,125,863 loops=1)

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