explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gWtW : Optimization for: sa; plan #gVnw

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 5,883.660 5,973.540 ↑ 301.7 64 1

GroupAggregate (cost=38,373.210..39,097.300 rows=19,309 width=1,188) (actual time=120.599..5,973.540 rows=64 loops=1)

  • Group Key: (charlie_xray('five_seven'::text, papa_five('echo'::text, mike_kilo)))
  • Buffers: shared hit=22969
2. 34.577 89.880 ↓ 1.1 20,959 1

Sort (cost=38,373.210..38,421.490 rows=19,309 width=1,188) (actual time=84.938..89.880 rows=20,959 loops=1)

  • Sort Key: (charlie_xray('five_seven'::text, papa_five('echo'::text, mike_kilo)))
  • Sort Method: quicksort Memory: 37534kB
  • Buffers: shared hit=11308
3. 31.804 55.303 ↓ 1.1 20,959 1

Bitmap Heap Scan on charlie_tango papa_kilo (cost=13,525.340..36,998.700 rows=19,309 width=1,188) (actual time=24.783..55.303 rows=20,959 loops=1)

  • Recheck Cond: (((mike_kilo >= 'zulu'::timestamp without time zone) AND (mike_kilo <= 'victor'::timestamp without time zone)) OR ((mike_kilo >= 'alpha'::timestamp without time zone) AND (mike_kilo <= '2017-11
  • Filter: (juliet_hotel five_romeo NOT NULL)
  • Rows Removed by Filter: 6431
  • Heap Blocks: exact=7482
  • Buffers: shared hit=11308
4. 0.001 23.499 ↓ 0.0 0 1

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

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

Bitmap Index Scan on juliet_four (cost=0.000..6,757.840 rows=14,285 width=0) (actual time=10.903..10.903 rows=14,864 loops=1)

  • Index Cond: ((mike_kilo >= 'zulu'::timestamp without time zone) AND (mike_kilo <= 'victor'::timestamp without time zone))
  • Buffers: shared hit=1913
6. 12.595 12.595 ↓ 1.0 12,526 1

Bitmap Index Scan on juliet_four (cost=0.000..6,757.840 rows=12,256 width=0) (actual time=12.595..12.595 rows=12,526 loops=1)

  • Index Cond: ((mike_kilo >= 'alpha'::timestamp without time zone) AND (mike_kilo <= 'mike_quebec'::timestamp without time zone))
  • Buffers: shared hit=1913