explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LAMU

Settings
# exclusive inclusive rows x rows loops node
1. 3.177 4,350.862 ↑ 709.0 1 1

GroupAggregate (cost=2,479.31..2,483.56 rows=709 width=24) (actual time=4,350.861..4,350.862 rows=1 loops=1)

  • Group Key: (date_part('year'::text, created_at)), (date_part('month'::text, created_at))
2. 9.768 4,347.685 ↓ 39.8 28,200 1

Sort (cost=2,479.31..2,479.66 rows=709 width=16) (actual time=4,346.109..4,347.685 rows=28,200 loops=1)

  • Sort Key: (date_part('year'::text, created_at)), (date_part('month'::text, created_at))
  • Sort Method: quicksort Memory: 2,090kB
3. 4,332.073 4,337.917 ↓ 39.8 28,200 1

Bitmap Heap Scan on purchases (cost=121.05..2,472.59 rows=709 width=16) (actual time=6.231..4,337.917 rows=28,200 loops=1)

  • Recheck Cond: (created_at > '2020-06-01 00:00:00'::timestamp without time zone)
  • Rows Removed by Index Recheck: 53,923
  • Heap Blocks: lossy=48,364
4. 5.844 5.844 ↓ 532.3 632,320 1

Bitmap Index Scan on purchases_created_at (cost=0.00..121.02 rows=1,188 width=0) (actual time=5.844..5.844 rows=632,320 loops=1)

  • Index Cond: (created_at > '2020-06-01 00:00:00'::timestamp without time zone)
Planning time : 0.390 ms
Execution time : 4,351.050 ms