explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ucDb

Settings
# exclusive inclusive rows x rows loops node
1. 2.589 31,067.300 ↑ 3,026.3 1,444 1

Finalize GroupAggregate (cost=3,275,775.20..4,618,867.67 rows=4,370,021 width=16) (actual time=27,430.820..31,067.300 rows=1,444 loops=1)

  • Group Key: (date_trunc('day'::text, to_timestamp((tmr_date)::double precision)))
2. 0.000 31,064.711 ↑ 2,376.3 3,678 1

Gather Merge (cost=3,275,775.20..4,498,692.09 rows=8,740,042 width=16) (actual time=27,430.816..31,064.711 rows=3,678 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 4,775.673 90,330.750 ↑ 3,564.5 1,226 3

Partial GroupAggregate (cost=3,274,775.17..3,488,874.36 rows=4,370,021 width=16) (actual time=26,277.241..30,110.250 rows=1,226 loops=3)

  • Group Key: (date_trunc('day'::text, to_timestamp((tmr_date)::double precision)))
4. 50,717.226 85,555.077 ↑ 1.3 14,679,788 3

Sort (cost=3,274,775.17..3,320,649.78 rows=18,349,842 width=8) (actual time=26,277.226..28,518.359 rows=14,679,788 loops=3)

  • Sort Key: (date_trunc('day'::text, to_timestamp((tmr_date)::double precision)))
  • Sort Method: external merge Disk: 260704kB
  • Worker 0: Sort Method: external merge Disk: 257872kB
  • Worker 1: Sort Method: external merge Disk: 257208kB
5. 34,837.851 34,837.851 ↑ 1.3 14,679,788 3

Parallel Seq Scan on trackingmessagesraw (cost=0.00..559,174.24 rows=18,349,842 width=8) (actual time=0.138..11,612.617 rows=14,679,788 loops=3)

Planning time : 0.162 ms