explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dOnS

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.049 ↑ 1.0 10 1

Limit (cost=1.45..1.47 rows=10 width=183) (actual time=0.047..0.049 rows=10 loops=1)

  • Buffers: shared hit=1
2. 0.029 0.047 ↑ 1.0 10 1

Sort (cost=1.45..1.47 rows=10 width=183) (actual time=0.046..0.047 rows=10 loops=1)

  • Sort Key: callhistor0_.call_time DESC
  • Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=1
3. 0.018 0.018 ↓ 1.3 13 1

Seq Scan on call_history callhistor0_ (cost=0..1.28 rows=10 width=183) (actual time=0.011..0.018 rows=13 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_.user_id)::text = 'X203G1A3I@nvg.ru'::text) OR ((callhistor0_.user_id)::text = 'X203G1A2I@nvg.ru'::text)))
  • Buffers: shared hit=1
Planning time : 0.179 ms
Execution time : 0.075 ms