explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XR67

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 82.104 ↓ 17.0 17 1

Merge Join (cost=15,148,595.26..15,149,049.20 rows=1 width=70) (actual time=82.056..82.104 rows=17 loops=1)

  • Merge Cond: (tfd.file_id = tf.file_id)
  • Buffers: shared hit=103 read=63
  • Planning time: 12437224.879 ms
  • Execution time: 82.260 ms
2. 0.039 82.065 ↑ 885.0 17 1

GroupAggregate (cost=15,146,549.27..15,146,812.55 rows=15,045 width=16) (actual time=82.030..82.065 rows=17 loops=1)

  • Group Key: tfd.file_id
  • Buffers: shared hit=98 read=63
3. 0.122 82.026 ↑ 94.0 160 1

Sort (cost=15,146,549.27..15,146,586.88 rows=15,045 width=8) (actual time=82.011..82.026 rows=160 loops=1)

  • Sort Key: tfd.file_id
  • Sort Method: quicksort Memory: 32kB
  • Buffers: shared hit=98 read=63
4. 0.090 81.904 ↑ 94.0 160 1

Nested Loop (cost=1.14..15,145,505.37 rows=15,045 width=8) (actual time=13.841..81.904 rows=160 loops=1)

  • Buffers: shared hit=98 read=63
5. 6.574 6.574 ↑ 23.5 22 1

Index Scan using i_sel_ti_fn_tfiles on task_files tf_1 (cost=0.56..2,022.69 rows=517 width=8) (actual time=6.567..6.574 rows=22 loops=1)

  • Index Cond: (task_id = '13942130'::numeric)
  • Buffers: shared read=5
6. 75.240 75.240 ↑ 13,094.0 7 22

Index Only Scan using task_file_data_file_idx_s2 on task_file_data tfd (cost=0.58..28,374.49 rows=91,658 width=8) (actual time=1.106..3.420 rows=7 loops=22)

  • Index Cond: (file_id = tf_1.file_id)
  • Heap Fetches: 206
  • Buffers: shared hit=98 read=58
7. 0.018 0.027 ↑ 23.5 22 1

Sort (cost=2,045.99..2,047.28 rows=517 width=62) (actual time=0.023..0.027 rows=22 loops=1)

  • Sort Key: tf.file_id
  • Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=5
8. 0.009 0.009 ↑ 23.5 22 1

Index Scan using i_sel_ti_fn_tfiles on task_files tf (cost=0.56..2,022.69 rows=517 width=62) (actual time=0.007..0.009 rows=22 loops=1)

  • Index Cond: (task_id = '13942130'::numeric)
  • Buffers: shared hit=5