explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G90U

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.030 ↓ 0.0 0 1

Sort (cost=11.39..11.39 rows=1 width=690) (actual time=0.030..0.030 rows=0 loops=1)

  • Output: id, insert_time, last_update_time, path, status, side, target_fs, file_type
  • Sort Key: cleanupsup0_.id
  • Sort Method: quicksort Memory: 25kB
2. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on xhubsvil04.t_cleanup_support cleanupsup0_ (cost=0.00..11.38 rows=1 width=690) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: id, insert_time, last_update_time, path, status, side, target_fs, file_type
  • Filter: ((cleanupsup0_.status)::text = 'OK'::text)
Planning time : 0.588 ms
Execution time : 0.090 ms