explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Auj7

Settings
# exclusive inclusive rows x rows loops node
1. 188.780 1,242.775 ↑ 21,279.0 47 1

GroupAggregate (cost=11,699,222.00..11,734,226.03 rows=1,000,115 width=12) (actual time=916.832..1,242.775 rows=47 loops=1)

  • Group Key: (((generate_series(date_trunc('month'::text, creation_date), date_trunc('month'::text, (end_date - '1 mon'::interval)), '1 mon'::interval)))::date)
2. 378.894 1,053.995 ↓ 1.0 1,000,137 1

Sort (cost=11,699,222.00..11,701,722.29 rows=1,000,115 width=16) (actual time=916.823..1,053.995 rows=1,000,137 loops=1)

  • Sort Key: (((generate_series(date_trunc('month'::text, creation_date), date_trunc('month'::text, (end_date - '1 mon'::interval)), '1 mon'::interval)))::date)
  • Sort Method: external merge Disk: 25,496kB
3. 47.039 675.101 ↓ 1.0 1,000,137 1

Gather (cost=1,000.00..11,582,457.87 rows=1,000,115 width=16) (actual time=0.169..675.101 rows=1,000,137 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 88.910 628.062 ↑ 1,250.0 333,379 3 / 3

Result (cost=0.00..11,481,446.37 rows=416,715,000 width=16) (actual time=0.031..628.062 rows=333,379 loops=3)

5. 425.993 539.152 ↑ 1,250.0 333,379 3 / 3

ProjectSet (cost=0.00..2,105,358.87 rows=416,715,000 width=20) (actual time=0.029..539.152 rows=333,379 loops=3)

6. 113.159 113.159 ↑ 1.2 333,372 3 / 3

Parallel Seq Scan on recurring_transactions (cost=0.00..15,533.15 rows=416,715 width=28) (actual time=0.013..113.159 rows=333,372 loops=3)

Planning time : 0.112 ms
Execution time : 1,307.103 ms