explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NTeK : CallHome_History_OFF

Settings
# exclusive inclusive rows x rows loops node
1. 1,003.752 1,717.387 ↓ 15.0 11,416 1

Hash Join (cost=2,088.68..268,756.89 rows=762 width=2,874) (actual time=34.642..1,717.387 rows=11,416 loops=1)

  • Buffers: shared hit=2,077 read=238,951, temp read=115,962 written=115,962
2. 680.416 680.416 ↓ 1.0 2,000,000 1

Seq Scan on callhome_notificationlogs b (cost=0..259,161.25 rows=1,999,825 width=1,410) (actual time=0.03..680.416 rows=2,000,000 loops=1)

  • Buffers: shared hit=212 read=238,951
3. 5.056 33.219 ↓ 57.1 5,708 1

Hash (cost=2,087.43..2,087.43 rows=100 width=1,475) (actual time=33.219..33.219 rows=5,708 loops=1)

  • Buffers: shared hit=1,865, temp read=927 written=1,393
4. 17.700 28.163 ↓ 57.1 5,708 1

Sort (cost=2,086.18..2,086.43 rows=100 width=1,475) (actual time=25.242..28.163 rows=5,708 loops=1)

  • Sort Key: callhome_eventlogs.datetime
  • Sort Method: external merge Disk: 7,416kB
  • Buffers: shared hit=1,865, temp read=927 written=929
5. 7.238 10.463 ↓ 57.1 5,708 1

Bitmap Heap Scan on callhome_eventlogs callhome_eventlogs (cost=1,688.78..2,082.86 rows=100 width=1,475) (actual time=3.607..10.463 rows=5,708 loops=1)

  • Heap Blocks: exact=1,444
  • Buffers: shared hit=1,865
6. 3.225 3.225 ↓ 57.1 5,708 1

Bitmap Index Scan on eventlog_search_index (cost=0..1,688.75 rows=100 width=0) (actual time=3.225..3.225 rows=5,708 loops=1)

  • Index Cond: (callhome_eventlogs.eventlog_search ~~ '%100%'::text)
  • Buffers: shared hit=421