explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yY4s

Settings
# exclusive inclusive rows x rows loops node
1. 187.254 1,247.046 ↑ 21,279.0 47 1

GroupAggregate (cost=11,699,222.00..11,734,226.03 rows=1,000,115 width=12) (actual time=923.681..1,247.046 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. 374.579 1,059.792 ↓ 1.0 1,000,137 1

Sort (cost=11,699,222.00..11,701,722.29 rows=1,000,115 width=16) (actual time=923.670..1,059.792 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. 48.746 685.213 ↓ 1.0 1,000,137 1

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

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

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

5. 431.116 547.163 ↑ 1,250.0 333,379 3 / 3

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

6. 116.047 116.047 ↑ 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.014..116.047 rows=333,372 loops=3)

Planning time : 0.358 ms
Execution time : 1,324.511 ms