explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0gFj

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.020 ↓ 0.0 0 1

Sort (cost=8.17..8.18 rows=1 width=690) (actual time=0.020..0.020 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
  • Buffers: shared hit=1
2. 0.009 0.009 ↓ 0.0 0 1

Index Scan using idx_t_cleanup_support_test on xhubsvil04.t_cleanup_support cleanupsup0_ (cost=0.14..8.16 rows=1 width=690) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: id, insert_time, last_update_time, path, status, side, target_fs, file_type
  • Index Cond: ((cleanupsup0_.status)::text = 'OK'::text)
  • Buffers: shared hit=1
Planning time : 1.117 ms
Execution time : 0.089 ms