explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kVFq

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 173.441 ↓ 10.0 10 1

Limit (cost=1,003.96..1,003.97 rows=1 width=140) (actual time=173.421..173.441 rows=10 loops=1)

  • Buffers: shared hit=61 read=481 dirtied=1
2. 0.250 173.422 ↓ 10.0 10 1

Sort (cost=1,003.96..1,003.97 rows=1 width=140) (actual time=173.416..173.422 rows=10 loops=1)

  • Sort Key: callhistor0_.call_time DESC
  • Sort Method: top-N heapsort Memory: 30kB
  • Buffers: shared hit=61 read=481 dirtied=1
3. 160.578 173.172 ↓ 68.0 68 1

Bitmap Heap Scan on call_history callhistor0_ (cost=983.84..1,003.95 rows=1 width=140) (actual time=62.379..173.172 rows=68 loops=1)

  • Filter: ((callhistor0_.call_time > '2019-05-29 11:20:00'::timestamp without time zone) AND (callhistor0_.call_time < '2019-09-29 11:20:00'::timestamp without time zone) AND (((callhistor0_.user_id)::text = 'E30770G1A4I'::text) OR ((callhistor0_.user_id)::text = 'e30770g1a4i@inside.mts.ru'::text)))
  • Heap Blocks: exact=511
  • Buffers: shared hit=58 read=481 dirtied=1
4. 0.004 12.594 ↓ 0.0 0 1

BitmapOr (cost=983.84..983.84 rows=5 width=0) (actual time=12.594..12.594 rows=0 loops=1)

  • Buffers: shared hit=18 read=10
5. 12.430 12.430 ↓ 256.2 1,025 1

Bitmap Index Scan on idx_enterprise_group_department_user_call_history (cost=0..4.61 rows=4 width=0) (actual time=12.429..12.43 rows=1,025 loops=1)

  • Index Cond: (((callhistor0_.enterprise_bwks_id)::text = 'E30770'::text) AND ((callhistor0_.group_bwks_id)::text = 'E30770G1'::text))
  • Buffers: shared hit=4 read=10
6. 0.160 0.160 ↓ 0.0 0 1

Bitmap Index Scan on idx_enterprise_group_department_user_call_history (cost=0..979.23 rows=1 width=0) (actual time=0.159..0.16 rows=0 loops=1)

  • Index Cond: (((callhistor0_.enterprise_bwks_id)::text = 'E30770'::text) AND ((callhistor0_.department_bwks_id)::text = 'E30770G1'::text))
  • Buffers: shared hit=14
Planning time : 246.368 ms
Execution time : 173.559 ms