explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2jxf

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 10.376 ↑ 68.4 9 1

Sort (cost=2,337.87..2,339.41 rows=616 width=788) (actual time=10.375..10.376 rows=9 loops=1)

  • Sort Key: epic_issues.relative_position, epic_issues.id
  • Sort Method: quicksort Memory: 34kB
2. 0.004 10.342 ↑ 68.4 9 1

Nested Loop (cost=0.73..2,309.33 rows=616 width=788) (actual time=10.009..10.342 rows=9 loops=1)

3. 10.068 10.068 ↑ 68.4 9 1

Index Scan using index_epic_issues_on_epic_id on epic_issues (cost=0.29..177.89 rows=616 width=16) (actual time=9.934..10.068 rows=9 loops=1)

  • Index Cond: (epic_id = 14355)
  • Filter: (relative_position >= 1073737323)
  • Rows Removed by Filter: 882
4. 0.270 0.270 ↑ 1.0 1 9

Index Scan using issues_pkey on issues (cost=0.44..3.45 rows=1 width=776) (actual time=0.030..0.030 rows=1 loops=9)

  • Index Cond: (id = epic_issues.issue_id)
Planning time : 10.096 ms
Execution time : 10.490 ms