explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H2b1

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 604.376 1,906.112 ↑ 55.3 52 1

GroupAggregate (cost=11,628.13..11,700.24 rows=2,877 width=50) (actual time=1,274.765..1,906.112 rows=52 loops=1)

  • Group Key: type, month, year
2. 1,067.780 1,301.736 ↓ 116.7 337,037 1

Sort (cost=11,628.13..11,635.36 rows=2,889 width=53) (actual time=1,236.875..1,301.736 rows=337,037 loops=1)

  • Sort Key: type, month, year
  • Sort Method: external merge Disk: 20,440kB
3. 111.613 233.956 ↓ 116.7 337,037 1

Bitmap Heap Scan on facturation facturatio0_ (cost=788.45..11,462.07 rows=2,889 width=53) (actual time=131.408..233.956 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=56,825
4. 122.343 122.343 ↓ 116.7 337,037 1

Bitmap Index Scan on idx_facturation_temporal_action_date_laboratory_id (cost=0.00..787.73 rows=2,889 width=0) (actual time=122.343..122.343 rows=337,037 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.164 ms