explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7CIn

Settings
# exclusive inclusive rows x rows loops node
1. 7,292.557 6,806,216.668 ↓ 10.9 2,088,299 1

GroupAggregate (cost=58,188,758.490..58,680,269.170 rows=191,480 width=19) (actual time=6,790,572.400..6,806,216.668 rows=2,088,299 loops=1)

  • Group Key: charlie.hotel_romeo, charlie.six
  • Buffers: shared hit=630 read=18,423,965 dirtied=563,486 written=1,088, temp read=286,737 written=287,251
  • I/O Timings: read=6,047,552.770 write=149.987
2. 72,440.236 6,798,924.111 ↑ 1.6 24,833,961 1

Sort (cost=58,188,758.490..58,286,677.660 rows=39,167,671 width=15) (actual time=6,790,571.417..6,798,924.111 rows=24,833,961 loops=1)

  • Sort Key: charlie.hotel_romeo, charlie.six
  • Sort Method: external merge Disk: 655,264kB
  • Buffers: shared hit=623 read=18,423,965 dirtied=563,486 written=1,088, temp read=286,737 written=287,251
  • I/O Timings: read=6,047,552.770 write=149.987
3. 181,995.421 6,726,483.875 ↑ 1.6 24,833,961 1

Hash Join (cost=11,999.470..52,072,914.970 rows=39,167,671 width=15) (actual time=2,182.222..6,726,483.875 rows=24,833,961 loops=1)

  • Hash Cond: ((charlie.sierra = alpha.quebec) AND ((charlie.hotel_romeo)::text = (alpha.hotel_romeo)::text))
  • Buffers: shared hit=614 read=18,423,965 dirtied=563,486 written=1,088
  • I/O Timings: read=6,047,552.770 write=149.987
4. 6,544,480.082 6,544,480.082 ↑ 1.0 1,433,141,905 1

Seq Scan on hotel_yankee charlie (cost=0.000..44,480,799.000 rows=1,443,826,427 width=15) (actual time=0.010..6,544,480.082 rows=1,433,141,905 loops=1)

  • Filter: (bravo = ANY ('kilo'::integer[]))
  • Rows Removed by Filter: 651,765,776
  • Buffers: shared hit=2 read=18,423,965 dirtied=563,486 written=1,088
  • I/O Timings: read=6,047,552.770 write=149.987
5. 2.650 8.372 ↓ 1.0 17,908 1

Hash (cost=11,740.210..11,740.210 rows=17,284 width=13) (actual time=8.372..8.372 rows=17,908 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,047kB
  • Buffers: shared hit=612
6. 4.015 5.722 ↓ 1.0 17,908 1

Bitmap Heap Scan on two_yankee alpha (cost=262.290..11,740.210 rows=17,284 width=13) (actual time=1.763..5.722 rows=17,908 loops=1)

  • Recheck Cond: ((november >= (CURRENT_DATE - 30)) AND (november <= zulu()))
  • Heap Blocks: exact=531
  • Buffers: shared hit=612
7. 1.707 1.707 ↓ 1.0 17,908 1

Bitmap Index Scan on two_four (cost=0.000..257.970 rows=17,284 width=0) (actual time=1.707..1.707 rows=17,908 loops=1)

  • Index Cond: ((november >= (CURRENT_DATE - 30)) AND (november <= zulu()))
  • Buffers: shared hit=81
Planning time : 36.694 ms
Execution time : 6,806,403.995 ms