explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jmt3 : Majid-

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 1.369 ↑ 1.3 3 1

Sort (cost=683.39..683.40 rows=4 width=317) (actual time=1.368..1.369 rows=3 loops=1)

  • Sort Key: talk_completion_due_date DESC
  • Sort Method: quicksort Memory: 25kB
2. 1.358 1.358 ↑ 1.3 3 1

Seq Scan on talks talk0_ (cost=0.00..683.35 rows=4 width=317) (actual time=0.023..1.358 rows=3 loops=1)

  • Filter: ((submitter_id = '9b2e84a0-50ea-4021-a5c1-4610cb9f4c79'::uuid) AND (start_date <= now()) AND (talk_completion_due_date >= now()))
  • Rows Removed by Filter: 10946
Planning time : 0.095 ms
Execution time : 1.392 ms