explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nA7D

Settings
# exclusive inclusive rows x rows loops node
1. 65,245.968 78,125.475 ↓ 0.0 0 1

ModifyTable on public.issues (cost=5,478.62..5,534.62 rows=57 width=1,301) (actual time=78,125.475..78,125.475 rows=0 loops=1)

  • Buffers: shared hit=113,102 read=65,717 dirtied=30,182
  • I/O Timings: read=76,530.752
2. 2.569 12,879.507 ↓ 8.8 501 1

Nested Loop (cost=5,478.62..5,534.62 rows=57 width=1,301) (actual time=12,867.177..12,879.507 rows=501 loops=1)

  • Buffers: shared hit=4,602 read=9,221 dirtied=489
  • I/O Timings: read=12,629.982
3. 3.275 12,868.421 ↓ 8.8 501 1

HashAggregate (cost=5,478.05..5,478.62 rows=57 width=26) (actual time=12,867.140..12,868.421 rows=501 loops=1)

  • Group Key: issues_1.id
  • Buffers: shared hit=2,097 read=9,221 dirtied=489
  • I/O Timings: read=12,629.982
4. 24.702 12,865.146 ↓ 8.8 501 1

Nested Loop (cost=1.57..5,477.91 rows=57 width=26) (actual time=4,213.845..12,865.146 rows=501 loops=1)

  • Buffers: shared hit=2,097 read=9,221 dirtied=489
  • I/O Timings: read=12,629.982
5. 8.398 11,094.040 ↓ 36.6 8,356 1

Nested Loop (cost=1.00..5,321.58 rows=228 width=16) (actual time=17.032..11,094.040 rows=8,356 loops=1)

  • Buffers: shared hit=610 read=8,203 dirtied=478
  • I/O Timings: read=10,910.261
6. 303.885 303.885 ↓ 3.4 153 1

Index Scan using index_labels_on_title on public.labels (cost=0.43..70.21 rows=45 width=10) (actual time=12.477..303.885 rows=153 loops=1)

  • Index Cond: ((labels.title)::text = 'incident'::text)
  • Buffers: shared read=157 dirtied=8
  • I/O Timings: read=299.993
7. 10,781.757 10,781.757 ↑ 7.1 55 153

Index Scan using index_label_links_on_label_id on public.label_links (cost=0.57..112.82 rows=388 width=14) (actual time=4.497..70.469 rows=55 loops=153)

  • Index Cond: (label_links.label_id = labels.id)
  • Filter: ((label_links.target_type)::text = 'Issue'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=610 read=8,046 dirtied=470
  • I/O Timings: read=10,610.268
8. 1,746.404 1,746.404 ↓ 0.0 0 8,356

Index Scan using issues_pkey on public.issues issues_1 (cost=0.56..0.69 rows=1 width=10) (actual time=0.209..0.209 rows=0 loops=8,356)

  • Index Cond: ((issues_1.id = label_links.target_id) AND (issues_1.id >= 2,949,893) AND (issues_1.id <= 22,321,321))
  • Buffers: shared hit=1,487 read=1,018 dirtied=11
  • I/O Timings: read=1,719.721
9. 8.517 8.517 ↑ 1.0 1 501

Index Scan using issues_pkey on public.issues (cost=0.56..0.98 rows=1 width=1,253) (actual time=0.017..0.017 rows=1 loops=501)

  • Index Cond: (issues.id = label_links.target_id)
  • Buffers: shared hit=2,505