explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FIMI

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.383 ↑ 1.0 11 1

Limit (cost=53.08..53.11 rows=11 width=54) (actual time=0.381..0.383 rows=11 loops=1)

  • Output: cib_id, dt, employee_id, buh_name, buh_code
  • Buffers: shared hit=16 read=7
2. 0.030 0.380 ↑ 1.0 11 1

Sort (cost=53.08..53.11 rows=11 width=54) (actual time=0.379..0.380 rows=11 loops=1)

  • Output: cib_id, dt, employee_id, buh_name, buh_code
  • Sort Key: cib.dt DESC, cib.cib_id DESC
  • Sort Method: quicksort Memory: 27kB
  • Buffers: shared hit=16 read=7
3. 0.234 0.350 ↓ 1.5 17 1

Bitmap Heap Scan on dictionaries.cost_item_buh cib (cost=9.00..52.89 rows=11 width=54) (actual time=0.160..0.350 rows=17 loops=1)

  • Output: cib_id, dt, employee_id, buh_name, buh_code
  • Recheck Cond: ((('2016-12-15 16:18:42'::timestamp without time zone = cib.dt) AND (cib.cib_id < 250)) OR ((cib.dt >= '2019-01-27 19:59:59'::timestamp without time zone) AND (cib.dt <= 'infinity'::timestamp without time zone)))
  • Heap Blocks: exact=17
  • Buffers: shared hit=16 read=7
4. 0.030 0.116 ↓ 0.0 0 1

BitmapOr (cost=9.00..9.00 rows=11 width=0) (actual time=0.116..0.116 rows=0 loops=1)

  • Buffers: shared hit=5 read=1
5. 0.065 0.065 ↓ 0.0 0 1

Bitmap Index Scan on cost_item_buh_idx_desc (cost=0.00..4.44 rows=1 width=0) (actual time=0.065..0.065 rows=0 loops=1)

  • Index Cond: (('2016-12-15 16:18:42'::timestamp without time zone = cib.dt) AND (cib.cib_id < 250))
  • Buffers: shared hit=2 read=1
6. 0.021 0.021 ↓ 1.5 17 1

Bitmap Index Scan on cost_item_buh_idx_desc (cost=0.00..4.54 rows=11 width=0) (actual time=0.021..0.021 rows=17 loops=1)

  • Index Cond: ((cib.dt >= '2019-01-27 19:59:59'::timestamp without time zone) AND (cib.dt <= 'infinity'::timestamp without time zone))
  • Buffers: shared hit=3