explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZdUo

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 1,872.335 ↑ 4.1 241 1

Limit (cost=315,809.56..315,812.06 rows=1,000 width=157) (actual time=1,872.231..1,872.335 rows=241 loops=1)

  • Buffers: shared hit=2 read=34835 dirtied=1 written=791
2. 0.517 1,872.279 ↑ 189.7 241 1

Sort (cost=315,809.56..315,923.87 rows=45,722 width=157) (actual time=1,872.231..1,872.279 rows=241 loops=1)

  • Sort Key: dicomindexrequest.origin_actor_id, dicomindexrequest.request_id
  • Sort Method: quicksort Memory: 61kB
  • Buffers: shared hit=2 read=34835 dirtied=1 written=791
3. 1,871.762 1,871.762 ↑ 189.7 241 1

Append (cost=68,205.27..313,302.68 rows=45,722 width=157) (actual time=800.887..1,871.762 rows=241 loops=1)

  • Buffers: shared hit=2 read=34835 dirtied=1 written=791
  • -> Bitmap Heap Scan on dicomindexrequest (cost=68205.27..157469.83 rows=23812 width=157) (actual time=
  • Recheck Cond: ((origin_actor_id = 10001) AND (request_id > '9965565'::numeric) AND (dicom_domain_i
  • Rows Removed by Index Recheck: 16565
  • Heap Blocks: exact=12960
  • Buffers: shared read=20829 written=454
  • -> BitmapAnd (cost=68205.27..68205.27 rows=23812 width=0) (actual time=794.850..794.850 rows=0 l
  • Buffers: shared read=7869 written=366
  • -> Bitmap Index Scan on dicomindexrequest_pk (cost=0.00..23121.29 rows=692873 width=0) (ac
  • Index Cond: ((origin_actor_id = 10001) AND (request_id > '9965565'::numeric))
  • Buffers: shared read=275 written=54
  • -> Bitmap Index Scan on dicomindexrequest_domain_studydate_index (cost=0.00..45071.82 rows
  • Index Cond: (dicom_domain_id = 23)
  • Buffers: shared read=7594 written=312
  • -> Bitmap Heap Scan on dicomindexrequest dicomindexrequest_1 (cost=72988.05..155375.63 rows=21910 widt
  • Recheck Cond: ((origin_actor_id = 10002) AND (request_id > '6433267'::numeric) AND (dicom_domain_i
  • Rows Removed by Index Recheck: 10324
  • Heap Blocks: exact=4189
  • Buffers: shared hit=2 read=14006 dirtied=1 written=337
  • -> BitmapAnd (cost=72988.05..72988.05 rows=21910 width=0) (actual time=969.910..969.910 rows=0 l
  • Buffers: shared hit=2 read=9817 written=308
  • -> Bitmap Index Scan on dicomindexrequest_pk (cost=0.00..17191.92 rows=515136 width=0) (ac
  • Index Cond: ((origin_actor_id = 10002) AND (request_id > '6433267'::numeric))
  • Buffers: shared hit=1 read=157
  • -> Bitmap Index Scan on dicomindexrequest_domain_studydate_index (cost=0.00..55784.92 rows
  • Index Cond: (dicom_domain_id = 37)
  • Buffers: shared hit=1 read=9660 written=308