explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SLHQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 7,496.264 ↓ 1.3 236 1

HashAggregate (cost=3,321,083.20..3,321,085.85 rows=177 width=12) (actual time=7,496.214..7,496.264 rows=236 loops=1)

  • Group Key: country_counts.country
  • Functions: 14
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 4.159 ms, Inlining 15.516 ms, Optimization 97.808 ms, Emission 50.026 ms, Total 167.510 ms
2.          

Initplan (for HashAggregate)

3. 1,974.319 2,376.893 ↑ 1.0 2,758,286 1

Bitmap Heap Scan on research_outputs (cost=25,770.41..3,320,229.59 rows=2,795,665 width=8) (actual time=744.825..2,376.893 rows=2,758,286 loops=1)

  • Recheck Cond: (field_of_research_codes && '{06}'::text[])
  • Heap Blocks: exact=1,479,229
4. 402.574 402.574 ↑ 1.0 2,758,286 1

Bitmap Index Scan on research_outputs_57 (cost=0.00..25,071.49 rows=2,795,665 width=0) (actual time=402.573..402.574 rows=2,758,286 loops=1)

  • Index Cond: (field_of_research_codes && '{06}'::text[])
5. 7,007.738 7,007.738 ↓ 7,666.3 3,472,826 1

Index Scan using country_counts_constraint_0 on country_counts (cost=0.56..851.34 rows=453 width=16) (actual time=3,040.642..7,007.738 rows=3,472,826 loops=1)

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