explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8V7z

Settings
# exclusive inclusive rows x rows loops node
1. 1.881 244.466 ↓ 2.8 548 1

Sort (cost=811.30..811.78 rows=194 width=46) (actual time=244.405..244.466 rows=548 loops=1)

  • Sort Key: (CASE WHEN (issues.status_id = 62) THEN 1 WHEN (issues.status_id = 59) THEN 2 WHEN (issues.status_id = 58) THEN 3 WHEN (issues.status_id = 60) THEN 4 ELSE 99 END)
  • Sort Method: quicksort Memory: 307kB
2. 239.757 242.585 ↓ 2.8 548 1

Hash Join (cost=2.55..803.93 rows=194 width=46) (actual time=5.071..242.585 rows=548 loops=1)

  • Hash Cond: (issues.status_id = status.id)
3. 2.782 2.782 ↓ 2.8 548 1

Index Scan using index_issues_on_tracker_id on issues (cost=0.29..547.29 rows=194 width=46) (actual time=0.065..2.782 rows=548 loops=1)

  • Index Cond: (tracker_id = 62)
4. 0.026 0.046 ↑ 1.0 56 1

Hash (cost=1.56..1.56 rows=56 width=4) (actual time=0.046..0.046 rows=56 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
5. 0.020 0.020 ↑ 1.0 56 1

Seq Scan on issue_statuses status (cost=0.00..1.56 rows=56 width=4) (actual time=0.005..0.020 rows=56 loops=1)