explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UGI7

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.151 4,347.052 ↑ 1.0 1,000 1

Limit (cost=479,391.95..479,416.95 rows=1,000 width=44) (actual time=3,930.335..4,347.052 rows=1,000 loops=1)

2. 149.364 4,346.901 ↑ 1,980.5 1,000 1

GroupAggregate (cost=479,391.95..528,903.68 rows=1,980,469 width=44) (actual time=3,930.333..4,346.901 rows=1,000 loops=1)

  • Group Key: (to_char(date_trunc('month'::text, created), 'YY-Mon'::text)), owner
3. 1,979.507 4,197.537 ↑ 2.0 1,000,423 1

Sort (cost=479,391.95..484,343.12 rows=1,980,469 width=36) (actual time=3,930.310..4,197.537 rows=1,000,423 loops=1)

  • Sort Key: (to_char(date_trunc('month'::text, created), 'YY-Mon'::text)), owner
  • Sort Method: external merge Disk: 40632kB
4. 2,218.030 2,218.030 ↑ 1.0 1,979,586 1

Seq Scan on claims_claim (cost=0.00..218,105.04 rows=1,980,469 width=36) (actual time=0.032..2,218.030 rows=1,979,586 loops=1)

Planning time : 0.096 ms
Execution time : 4,355.689 ms