explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CrQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,816.106 ↑ 1.0 1 1

Finalize Aggregate (cost=63,748.05..63,748.06 rows=1 width=8) (actual time=2,816.106..2,816.106 rows=1 loops=1)

2. 12.267 2,819.940 ↓ 1.5 3 1

Gather (cost=63,747.84..63,748.05 rows=2 width=8) (actual time=2,815.189..2,819.940 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 198.565 2,807.673 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=62,747.84..62,747.85 rows=1 width=8) (actual time=2,807.673..2,807.673 rows=1 loops=3)

4. 2,609.108 2,609.108 ↑ 1.2 548,498 3 / 3

Parallel Seq Scan on traffic_sessions (cost=0.00..61,078.47 rows=667,748 width=0) (actual time=0.014..2,609.108 rows=548,498 loops=3)

  • Filter: ((end >= '2019-08-27 06:00:00+00'::timestamp with time zone) AND (end <= '2019-09-28 05:59:59.999+00'::timestamp with time zone))
  • Rows Removed by Filter: 266,191
Planning time : 4.365 ms
Execution time : 2,819.995 ms