explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JsJm

Settings
# exclusive inclusive rows x rows loops node
1. 196.709 1,395.774 ↑ 21,279.0 47 1

GroupAggregate (cost=11,699,222.00..11,734,226.03 rows=1,000,115 width=12) (actual time=1,055.160..1,395.774 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. 510.966 1,199.065 ↓ 1.0 1,000,137 1

Sort (cost=11,699,222.00..11,701,722.29 rows=1,000,115 width=16) (actual time=1,055.150..1,199.065 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.750 688.099 ↓ 1.0 1,000,137 1

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

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

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

5. 434.866 550.117 ↑ 1,250.0 333,379 3 / 3

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

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

Planning time : 0.155 ms
Execution time : 2,334.930 ms