explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6LJG

Settings
# exclusive inclusive rows x rows loops node
1. 3,916.235 74,432.716 ↑ 636.9 14 1

HashAggregate (cost=650,736.34..650,959.24 rows=8,916 width=133) (actual time=74,432.416..74,432.716 rows=14 loops=1)

  • Group Key: 'east'::text, (t.month)::character varying, (t.year)::character varying, t.circle
  • east_sms_submit_cdrs_etl.circle, east_sms_submit_cdrs_etl.receiver
2. 2,611.966 70,516.481 ↓ 49.6 4,419,535 1

Subquery Scan on t (cost=635,101.33..649,398.90 rows=89,163 width=129) (actual time=51,249.141..70,516.481 rows=4,419,535 loops=1)

3. 4,990.327 67,904.515 ↓ 49.6 4,419,535 1

Finalize GroupAggregate (cost=635,101.33..647,615.64 rows=89,163 width=89) (actual time=51,248.037..67,904.515 rows=4,419,535 loops=1)

  • Group Key: ('east'::text), (date_part('month'::text, east_sms_submit_cdrs_etl.date_time)), (date_part('year'::text, east_sms_submit_cdrs_etl.date_time)),
4. 4,060.509 62,914.188 ↓ 82.6 6,133,788 1

Gather Merge (cost=635,101.33..644,977.91 rows=74,302 width=89) (actual time=51,247.975..62,914.188 rows=6,133,788 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 2,667.986 58,853.679 ↓ 55.0 2,044,596 3 / 3

Partial GroupAggregate (cost=634,101.31..635,401.59 rows=37,151 width=89) (actual time=51,143.012..58,853.679 rows=2,044,596 loops=3)

  • Group Key: 'east'::text, (date_part('month'::text, east_sms_submit_cdrs_etl.date_time)), (date_part('year'::text, east_sms_submit_cdrs_etl.date_time)), east_sms_submit_cdrs_etl.circle, east_sms_submit_cdrs_etl.receiver
6. 28,463.915 56,185.693 ↓ 73.0 2,713,767 3 / 3

Sort (cost=634,101.31..634,194.18 rows=37,151 width=77) (actual time=51,142.967..56,185.693 rows=2,713,767 loops=3)

  • Sort Key: (date_part('month'::text, east_sms_submit_cdrs_etl.date_time)), (date_part('year'::text, east_sms_submit_cdrs_etl.date_time)), east_sms_submit_cdrs_etl.circle, east_sms_submit_cdrs_etl.receiver
  • Sort Method: external merge Disk: 172,096kB
  • Worker 0: Sort Method: external merge Disk: 179,144kB
  • Worker 1: Sort Method: external merge Disk: 174,616kB
7. 27,721.778 27,721.778 ↓ 73.0 2,713,767 3 / 3

Parallel Seq Scan on east_sms_submit_cdrs_etl (cost=0.00..631,281.34 rows=37,151 width=77) (actual time=12.908..27,721.778 rows=2,713,767 loops=3)

  • Filter: (((date_time)::date >= '2020-01-31'::date) AND ((date_time)::date <= '2020-06-08'::date))
  • Rows Removed by Filter: 3,230,269
Planning time : 0.855 ms
Execution time : 74,536.147 ms