explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q8rq

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 141.337 ↑ 1.0 21 1

Limit (cost=47,581.78..47,581.83 rows=21 width=736) (actual time=141.333..141.337 rows=21 loops=1)

2. 32.711 141.334 ↑ 1,708.2 21 1

Sort (cost=47,581.78..47,671.46 rows=35,873 width=736) (actual time=141.332..141.334 rows=21 loops=1)

  • Sort Key: created_at DESC, id DESC
  • Sort Method: top-N heapsort Memory: 78kB
3. 108.623 108.623 ↓ 1.1 37,814 1

Index Scan using index_merge_requests_on_target_project_id_and_iid on merge_requests (cost=0.56..46,614.58 rows=35,873 width=736) (actual time=0.029..108.623 rows=37,814 loops=1)

  • Index Cond: (target_project_id = 278,964)
Planning time : 0.274 ms
Execution time : 141.380 ms