explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ephp

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 59.533 ↑ 1.0 1 1

Limit (cost=4,128.54..4,128.54 rows=1 width=4) (actual time=59.532..59.533 rows=1 loops=1)

2. 0.672 59.486 ↑ 1.1 1,001 1

Sort (cost=4,126.04..4,128.70 rows=1,064 width=4) (actual time=59.363..59.486 rows=1,001 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 115kB
3. 19.407 58.814 ↓ 1.3 1,412 1

Bitmap Heap Scan on container_repositories (cost=1,715.84..4,072.54 rows=1,064 width=4) (actual time=40.405..58.814 rows=1,412 loops=1)

  • Recheck Cond: ((project_id = XXX) AND (id >= 1,284,146))
  • Heap Blocks: exact=961
4. 0.429 39.407 ↓ 0.0 0 1

BitmapAnd (cost=1,715.84..1,715.84 rows=1,064 width=0) (actual time=39.407..39.407 rows=0 loops=1)

5. 1.483 1.483 ↑ 1.0 9,412 1

Bitmap Index Scan on index_container_repositories_on_project_id (cost=0.00..144.27 rows=9,579 width=0) (actual time=1.483..1.483 rows=9,412 loops=1)

  • Index Cond: (project_id = XXX)
6. 37.495 37.495 ↓ 1.0 115,074 1

Bitmap Index Scan on container_repositories_pkey (cost=0.00..1,570.79 rows=114,982 width=0) (actual time=37.495..37.495 rows=115,074 loops=1)

  • Index Cond: (id >= 1,284,146)
Planning time : 0.129 ms
Execution time : 59.651 ms