explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gVnw : sa

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 5,769.603 5,900.730 ↑ 301.7 64 1

GroupAggregate (cost=44,107.210..44,831.300 rows=19,309 width=1,188) (actual time=149.015..5,900.730 rows=64 loops=1)

  • Group Key: (charlie_xray('five_seven'::text, papa_five('echo'::text, mike_kilo)))
  • Buffers: shared hit=22969, temp read=3084 written=3084
2. 82.240 131.127 ↓ 1.1 20,959 1

Sort (cost=44,107.210..44,155.490 rows=19,309 width=1,188) (actual time=109.303..131.127 rows=20,959 loops=1)

  • Sort Key: (charlie_xray('five_seven'::text, papa_five('echo'::text, mike_kilo)))
  • Sort Method: external sort Disk: 24672kB
  • Buffers: shared hit=11308, temp read=3084 written=3084
3. 28.391 48.887 ↓ 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=21.670..48.887 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.003 20.496 ↓ 0.0 0 1

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

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

Bitmap Index Scan on juliet_four (cost=0.000..6,757.840 rows=14,285 width=0) (actual time=9.779..9.779 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. 10.714 10.714 ↓ 1.0 12,526 1

Bitmap Index Scan on juliet_four (cost=0.000..6,757.840 rows=12,256 width=0) (actual time=10.714..10.714 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