explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z5jI : Optimization for: plan #H2b1

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 616.939 4,525.075 ↑ 28.2 52 1

GroupAggregate (cost=16,364.84..16,428.78 rows=1,464 width=86) (actual time=3,799.122..4,525.075 rows=52 loops=1)

  • Group Key: type, year_month
2. 1,507.248 3,908.136 ↓ 85.5 337,037 1

Sort (cost=16,364.84..16,374.70 rows=3,944 width=89) (actual time=3,757.085..3,908.136 rows=337,037 loops=1)

  • Sort Key: type, year_month
  • Sort Method: external merge Disk: 20,424kB
3. 1,792.195 2,400.888 ↓ 85.5 337,037 1

Bitmap Heap Scan on facturation facturatio0_ (cost=1,561.02..16,129.28 rows=3,944 width=89) (actual time=631.086..2,400.888 rows=337,037 loops=1)

  • Recheck Cond: ((temporal_action_date >= '2019-01-01'::date) AND (temporal_action_date <= '2020-01-01'::date) AND (laboratory_id = 6))
  • Heap Blocks: exact=114,473
4. 608.693 608.693 ↓ 170.4 672,133 1

Bitmap Index Scan on idx_facturation_temporal_action_date_laboratory_id (cost=0.00..1,560.03 rows=3,944 width=0) (actual time=608.693..608.693 rows=672,133 loops=1)

  • Index Cond: ((temporal_action_date >= '2019-01-01'::date) AND (temporal_action_date <= '2020-01-01'::date) AND (laboratory_id = 6))
Planning time : 0.209 ms