explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pXi7

Settings
# exclusive inclusive rows x rows loops node
1. 62.889 69,988.422 ↓ 0.0 0 1

Finalize GroupAggregate (cost=2,161,755.53..2,251,798.38 rows=1,753 width=48) (actual time=69,988.422..69,988.422 rows=0 loops=1)

  • Group Key: session_id
  • Filter: ((max(created_time) >= '2020-10-09 09:00:00'::timestamp without time zone) AND (max(created_time) <= '2020-10-09 10:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 100,358
2. 205.386 69,925.533 ↑ 2.0 172,696 1

Gather Merge (cost=2,161,755.53..2,242,154.95 rows=350,670 width=48) (actual time=63,146.306..69,925.533 rows=172,696 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 744.816 69,720.147 ↑ 4.1 86,348 2 / 2

Partial GroupAggregate (cost=2,160,755.52..2,201,704.57 rows=350,670 width=48) (actual time=63,114.283..69,720.147 rows=86,348 loops=2)

  • Group Key: session_id
4. 39,289.447 68,975.331 ↑ 1.3 2,841,456 2 / 2

Sort (cost=2,160,755.52..2,170,116.11 rows=3,744,235 width=40) (actual time=63,111.474..68,975.331 rows=2,841,456 loops=2)

  • Sort Key: session_id
  • Sort Method: external merge Disk: 160,344kB
  • Worker 0: Sort Method: external merge Disk: 162,208kB
5. 29,685.884 29,685.884 ↑ 1.3 2,841,456 2 / 2

Parallel Seq Scan on realtime_revenue_active (cost=0.00..1,632,022.26 rows=3,744,235 width=40) (actual time=0.339..29,685.884 rows=2,841,456 loops=2)

  • Filter: ((created_time >= '2020-10-09 07:00:00'::timestamp without time zone) AND (as_id ~ '^6da(p|q)2\d+'::text))
  • Rows Removed by Filter: 10,039,057
Planning time : 27.975 ms
Execution time : 70,061.494 ms