explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f54l

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.033 ↑ 1.1 9 1

Limit (cost=1.55..1.58 rows=10 width=183) (actual time=0.031..0.033 rows=9 loops=1)

  • Buffers: shared hit=1
2. 0.019 0.031 ↑ 1.1 9 1

Sort (cost=1.55..1.58 rows=10 width=183) (actual time=0.031..0.031 rows=9 loops=1)

  • Sort Key: callhistor0_.call_time DESC
  • Sort Method: quicksort Memory: 27kB
  • Buffers: shared hit=1
3. 0.012 0.012 ↑ 1.1 9 1

Seq Scan on call_history callhistor0_ (cost=0..1.39 rows=10 width=183) (actual time=0.008..0.012 rows=9 loops=1)

  • Filter: ((callhistor0_.call_time > '2019-03-26 00:00:00'::timestamp without time zone) AND (callhistor0_.call_time < '2019-09-26 00:00:00'::timestamp without time zone) AND ((callhistor0_.enterprise_bwks_id)::text = 'A603'::text) AND (((callhistor0_.user_id)::text = 'X203G1A3I@nvg.ru'::text) OR ((callhistor0_.user_id)::text = 'X203G1A2I@nvg.ru'::text)) AND (((callhistor0_.group_bwks_id)::text = 'A603G1'::text) OR ((callhistor0_.department_bwks_id)::text = 'A603G1'::text)))
  • Buffers: shared hit=1
Planning time : 0.191 ms
Execution time : 0.071 ms