explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bUTs

Settings
# exclusive inclusive rows x rows loops node
1. 321.034 69,372.193 ↑ 1.0 30 1

Limit (cost=1,230,743.94..1,230,744.02 rows=30 width=68) (actual time=69,051.171..69,372.193 rows=30 loops=1)

2. 1.753 69,051.159 ↑ 9,655.2 30 1

Sort (cost=1,230,743.94..1,231,468.08 rows=289,656 width=68) (actual time=69,051.157..69,051.159 rows=30 loops=1)

  • Sort Key: (((to_char((date(t_e20so1_document_datastore_default.c_docdate))::timestamp with time zone, 'MM/DD/YYYY'::text)))::date)
  • Sort Method: top-N heapsort Memory: 28kB
3. 0.000 69,049.406 ↑ 40.6 7,126 1

Group (cost=986,200.55..1,222,189.11 rows=289,656 width=68) (actual time=68,521.493..69,049.406 rows=7,126 loops=1)

  • Group Key: (to_char((date(t_e20so1_document_datastore_default.c_docdate))::timestamp with time zone, 'MM/DD/YYYY'::text))
4. 398.476 69,362.944 ↑ 40.5 42,922 1

Gather Merge (cost=986,200.55..1,209,878.73 rows=1,737,936 width=40) (actual time=68,521.459..69,362.944 rows=42,922 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
5. 171.832 68,964.468 ↑ 47.2 6,132 7 / 7

Group (cost=985,200.45..997,655.50 rows=289,656 width=40) (actual time=68,460.438..68,964.468 rows=6,132 loops=7)

  • Group Key: (to_char((date(t_e20so1_document_datastore_default.c_docdate))::timestamp with time zone, 'MM/DD/YYYY'::text))
6. 16,449.078 68,792.636 ↑ 1.2 1,759,398 7 / 7

Sort (cost=985,200.45..990,341.76 rows=2,056,526 width=40) (actual time=68,460.413..68,792.636 rows=1,759,398 loops=7)

  • Sort Key: (to_char((date(t_e20so1_document_datastore_default.c_docdate))::timestamp with time zone, 'MM/DD/YYYY'::text))
  • Sort Method: external merge Disk: 58,360kB
  • Worker 0: Sort Method: external merge Disk: 54,840kB
  • Worker 1: Sort Method: external merge Disk: 57,760kB
  • Worker 2: Sort Method: external merge Disk: 60,488kB
  • Worker 3: Sort Method: external merge Disk: 57,792kB
  • Worker 4: Sort Method: external merge Disk: 60,248kB
  • Worker 5: Sort Method: external merge Disk: 60,400kB
7. 177.179 52,343.558 ↑ 1.2 1,759,398 7 / 7

Parallel Append (cost=0.00..670,743.36 rows=2,056,526 width=40) (actual time=4.215..52,343.558 rows=1,759,398 loops=7)

8. 52,166.379 52,166.379 ↑ 1.2 1,759,398 7 / 7

Parallel Seq Scan on t_e20so1_document_datastore_default (cost=0.00..660,460.73 rows=2,056,526 width=40) (actual time=4.214..52,166.379 rows=1,759,398 loops=7)

  • Filter: ((c_docdate IS NOT NULL) AND (c_datastoresid = 11))
  • Rows Removed by Filter: 525,392
Planning time : 1,439.995 ms
Execution time : 69,501.685 ms