explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCXS

Settings
# exclusive inclusive rows x rows loops node
1. 49.754 34,407.216 ↑ 29.2 14,247 1

Finalize GroupAggregate (cost=461,822.30..640,982.46 rows=415,428 width=74) (actual time=29,570.231..34,407.216 rows=14,247 loops=1)

  • Group Key: date_created, city_corporation_upazila, district, division, country
2. 448.050 34,357.462 ↑ 21.7 38,310 1

Gather Merge (cost=461,822.30..618,133.92 rows=830,856 width=74) (actual time=29,570.208..34,357.462 rows=38,310 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2,121.222 33,909.412 ↑ 32.5 12,770 3 / 3

Partial GroupAggregate (cost=460,822.27..521,232.49 rows=415,428 width=74) (actual time=29,445.803..33,909.412 rows=12,770 loops=3)

  • Group Key: date_created, city_corporation_upazila, district, division, country
4. 6,579.927 31,788.190 ↑ 1.2 1,386,829 3 / 3

Sort (cost=460,822.27..465,149.65 rows=1,730,952 width=50) (actual time=29,445.605..31,788.190 rows=1,386,829 loops=3)

  • Sort Key: date_created, city_corporation_upazila, district, division, country
  • Sort Method: external merge Disk: 85200kB
  • Worker 0: Sort Method: external merge Disk: 86056kB
  • Worker 1: Sort Method: external merge Disk: 90464kB
5. 25,208.263 25,208.263 ↑ 1.2 1,386,829 3 / 3

Parallel Seq Scan on household (cost=0.00..222,304.52 rows=1,730,952 width=50) (actual time=28.972..25,208.263 rows=1,386,829 loops=3)

Planning time : 1.126 ms
Execution time : 34,458.152 ms