explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CG5P

Settings
# exclusive inclusive rows x rows loops node
1. 5,913.558 5,995.327 ↑ 301.7 64 1

GroupAggregate (cost=38,373.21..39,049.03 rows=19,309 width=1,180) (actual time=113.286..5,995.327 rows=64 loops=1)

  • Group Key: (timezone('Europe/Paris'::text, date_trunc('DAY'::text, date_create)))
  • Buffers: shared hit=22969
2. 30.910 81.769 ↓ 1.1 20,959 1

Sort (cost=38,373.21..38,421.49 rows=19,309 width=1,180) (actual time=76.635..81.769 rows=20,959 loops=1)

  • Sort Key: (timezone('Europe/Paris'::text, date_trunc('DAY'::text, date_create)))
  • Sort Method: quicksort Memory: 37529kB
  • Buffers: shared hit=11308
3. 28.763 50.859 ↓ 1.1 20,959 1

Bitmap Heap Scan on order_persistence o (cost=13,525.34..36,998.70 rows=19,309 width=1,180) (actual time=23.351..50.859 rows=20,959 loops=1)

  • Recheck Cond: (((date_create >= '2018-10-29 00:00:00'::timestamp without time zone) AND (date_create <= '2018-11-30 00:00:00'::timestamp without time zone)) OR ((date_create >= '2017-10-29 00:00:00'::timestamp without time zone) AND (date_create <= '2017-11
  • Filter: (olt_identification_number IS NOT NULL)
  • Rows Removed by Filter: 6431
  • Heap Blocks: exact=7482
  • Buffers: shared hit=11308
4. 0.002 22.096 ↓ 0.0 0 1

BitmapOr (cost=13,525.34..13,525.34 rows=26,541 width=0) (actual time=22.096..22.096 rows=0 loops=1)

  • Buffers: shared hit=3826
5. 10.203 10.203 ↓ 1.0 14,864 1

Bitmap Index Scan on order_persistence_index1 (cost=0.00..6,757.84 rows=14,285 width=0) (actual time=10.203..10.203 rows=14,864 loops=1)

  • Index Cond: ((date_create >= '2018-10-29 00:00:00'::timestamp without time zone) AND (date_create <= '2018-11-30 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=1913
6. 11.891 11.891 ↓ 1.0 12,526 1

Bitmap Index Scan on order_persistence_index1 (cost=0.00..6,757.84 rows=12,256 width=0) (actual time=11.891..11.891 rows=12,526 loops=1)

  • Index Cond: ((date_create >= '2017-10-29 00:00:00'::timestamp without time zone) AND (date_create <= '2017-11-30 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=1913