explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5M5e

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 5.857 ↓ 0.0 0 1

Update on issues (cost=2.29..17.52 rows=1 width=1,356) (actual time=5.857..5.857 rows=0 loops=1)

  • Buffers: shared hit=7 read=2
  • I/O Timings: read=5.724
2. 0.001 5.855 ↓ 0.0 0 1

Nested Loop (cost=2.29..17.52 rows=1 width=1,356) (actual time=5.854..5.855 rows=0 loops=1)

  • Buffers: shared hit=7 read=2
  • I/O Timings: read=5.724
3. 0.001 5.854 ↓ 0.0 0 1

Subquery Scan on grouped_counts (cost=1.72..13.93 rows=1 width=96) (actual time=5.854..5.854 rows=0 loops=1)

  • Buffers: shared hit=7 read=2
  • I/O Timings: read=5.724
4. 0.002 5.853 ↓ 0.0 0 1

GroupAggregate (cost=1.72..13.92 rows=1 width=36) (actual time=5.853..5.853 rows=0 loops=1)

  • Group Key: "*SELECT* 1".blocking_issue_id
  • Filter: (sum("*SELECT* 1".blocked_count) > '0'::numeric)
  • Buffers: shared hit=7 read=2
  • I/O Timings: read=5.724
5. 0.001 5.851 ↓ 0.0 0 1

Merge Append (cost=1.72..13.87 rows=2 width=12) (actual time=5.851..5.851 rows=0 loops=1)

  • Sort Key: "*SELECT* 1".blocking_issue_id
  • Buffers: shared hit=7 read=2
  • I/O Timings: read=5.724
6. 0.000 0.019 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=0.85..6.92 rows=1 width=12) (actual time=0.019..0.019 rows=0 loops=1)

  • Buffers: shared hit=2
7. 0.000 0.019 ↓ 0.0 0 1

GroupAggregate (cost=0.85..6.91 rows=1 width=12) (actual time=0.019..0.019 rows=0 loops=1)

  • Group Key: issue_links.source_id
  • Filter: (count(*) > 0)
  • Buffers: shared hit=2
8. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=0.85..6.89 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Buffers: shared hit=2
9. 0.018 0.018 ↓ 0.0 0 1

Index Only Scan using tmp_idx_blocking_type_links on issue_links (cost=0.29..3.31 rows=1 width=4) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((source_id >= 1,220,746) AND (source_id <= 1,220,747))
  • Heap Fetches: 0
  • Buffers: shared hit=2
10. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tmp_idx_index_issues_with_outdate_blocking_count on issues issues_1 (cost=0.56..3.58 rows=1 width=4) (never executed)

  • Index Cond: (id = issue_links.source_id)
  • Heap Fetches: 0
11. 0.001 5.831 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.85..6.92 rows=1 width=12) (actual time=5.831..5.831 rows=0 loops=1)

  • Buffers: shared hit=5 read=2
  • I/O Timings: read=5.724
12. 0.001 5.830 ↓ 0.0 0 1

GroupAggregate (cost=0.85..6.91 rows=1 width=12) (actual time=5.830..5.830 rows=0 loops=1)

  • Group Key: issue_links_1.target_id
  • Filter: (count(*) > 0)
  • Buffers: shared hit=5 read=2
  • I/O Timings: read=5.724
13. 0.004 5.829 ↓ 0.0 0 1

Nested Loop (cost=0.85..6.89 rows=1 width=4) (actual time=5.829..5.829 rows=0 loops=1)

  • Buffers: shared hit=5 read=2
  • I/O Timings: read=5.724
14. 0.021 0.021 ↑ 1.0 1 1

Index Only Scan using tmp_idx_blocked_by_type_links on issue_links issue_links_1 (cost=0.29..3.31 rows=1 width=4) (actual time=0.019..0.021 rows=1 loops=1)

  • Index Cond: ((target_id >= 1,220,746) AND (target_id <= 1,220,747))
  • Heap Fetches: 0
  • Buffers: shared hit=3
15. 5.804 5.804 ↓ 0.0 0 1

Index Only Scan using tmp_idx_index_issues_with_outdate_blocking_count on issues issues_2 (cost=0.56..3.58 rows=1 width=4) (actual time=5.804..5.804 rows=0 loops=1)

  • Index Cond: (id = issue_links_1.target_id)
  • Heap Fetches: 0
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=5.724
16. 0.000 0.000 ↓ 0.0 0

Index Scan using issues_pkey on issues (cost=0.57..3.58 rows=1 width=1,264) (never executed)

  • Index Cond: (id = grouped_counts.blocking_issue_id)
Planning time : 131.616 ms
Execution time : 6.355 ms