explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OdD

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.034 ↓ 0.0 0 1

Limit (cost=1.36..1.36 rows=1 width=183) (actual time=0.034..0.034 rows=0 loops=1)

  • Buffers: shared hit=1
2. 0.018 0.033 ↓ 0.0 0 1

Sort (cost=1.36..1.36 rows=1 width=183) (actual time=0.033..0.033 rows=0 loops=1)

  • Sort Key: callhistor0_.call_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
3. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on call_history callhistor0_ (cost=0..1.35 rows=1 width=183) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (((callhistor0_.calling_number)::text ~~ '002'::text) AND (callhistor0_.call_time > '2019-03-26 00:00:00'::timestamp without time zone) AND (callhistor0_.call_time < '2019-10-26 00:00:00'::timestamp without time zone) AND ((callhistor0_.enterprise_bwks_id)::text = 'A603'::text) AND ((callhistor0_.call_status)::text = 'ORIGINATING'::text) AND ((callhistor0_.call_direction)::text = 'PLACED'::text))
  • Buffers: shared hit=1
Planning time : 0.224 ms
Execution time : 0.066 ms