explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eyf1

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 571.052 ↑ 1.0 20 1

Limit (cost=0.98..11,867.72 rows=20 width=1,265) (actual time=97.137..571.052 rows=20 loops=1)

  • Buffers: shared hit=435 read=235 dirtied=66
  • I/O Timings: read=502.837
2. 0.800 571.031 ↑ 6.7 20 1

Nested Loop (cost=0.98..79,508.14 rows=134 width=1,265) (actual time=97.135..571.031 rows=20 loops=1)

  • Buffers: shared hit=435 read=235 dirtied=66
  • I/O Timings: read=502.837
3. 525.336 525.336 ↑ 375.1 123 1

Index Scan using idx_issues_on_project_id_and_created_at_and_id_and_state_id on public.issues (cost=0.56..56,519.86 rows=46,137 width=1,265) (actual time=23.299..525.336 rows=123 loops=1)

  • Index Cond: ((issues.project_id = 278,964) AND (issues.state_id = 1))
  • Filter: (issues.issue_type = ANY ('{0,1}'::integer[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=71 read=210 dirtied=62
  • I/O Timings: read=463.502
4. 44.895 44.895 ↓ 0.0 0 123

Index Scan using index_epic_issues_on_issue_id on public.epic_issues (cost=0.42..0.50 rows=1 width=4) (actual time=0.365..0.365 rows=0 loops=123)

  • Index Cond: (epic_issues.issue_id = issues.id)
  • Filter: (epic_issues.epic_id <> 331)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=364 read=25 dirtied=4
  • I/O Timings: read=39.335