explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UZXO

Settings
# exclusive inclusive rows x rows loops node
1. 4,193.896 12,224.474 ↓ 1.1 737,801 1

GroupAggregate (cost=0.56..693,156.65 rows=699,544 width=30) (actual time=0.095..12,224.474 rows=737,801 loops=1)

  • Group Key: country, date, type
2. 8,030.578 8,030.578 ↓ 1.0 6,997,979 1

Index Scan using country_date_type on ga_grouped_data t0 (cost=0.56..616,206.84 rows=6,995,437 width=26) (actual time=0.077..8,030.578 rows=6,997,979 loops=1)

Planning time : 0.207 ms
Execution time : 12,306.947 ms