explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wB01

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 90.788 ↓ 17.0 17 1

Merge Join (cost=15,353,236.09..15,353,697.45 rows=1 width=70) (actual time=90.743..90.788 rows=17 loops=1)

  • Merge Cond: (tfd.file_id = tf.file_id)
  • Buffers: shared hit=104 read=62
2. 0.037 90.749 ↑ 899.5 17 1

GroupAggregate (cost=15,351,253.12..15,351,520.71 rows=15,291 width=16) (actual time=90.716..90.749 rows=17 loops=1)

  • Group Key: tfd.file_id
  • Buffers: shared hit=99 read=62
3. 0.131 90.712 ↑ 95.6 160 1

Sort (cost=15,351,253.12..15,351,291.35 rows=15,291 width=8) (actual time=90.698..90.712 rows=160 loops=1)

  • Sort Key: tfd.file_id
  • Sort Method: quicksort Memory: 32kB
  • Buffers: shared hit=99 read=62
4. 0.071 90.581 ↑ 95.6 160 1

Nested Loop (cost=1.14..15,350,190.37 rows=15,291 width=8) (actual time=11.335..90.581 rows=160 loops=1)

  • Buffers: shared hit=99 read=62
5. 5.920 5.920 ↑ 23.8 22 1

Index Scan using i_sel_ti_fn_tfiles on task_files tf_1 (cost=0.56..1,959.30 rows=524 width=8) (actual time=5.910..5.920 rows=22 loops=1)

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

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

  • Index Cond: (file_id = tf_1.file_id)
  • Heap Fetches: 206
  • Buffers: shared hit=99 read=57
7. 0.014 0.025 ↑ 23.8 22 1

Sort (cost=1,982.96..1,984.27 rows=524 width=62) (actual time=0.023..0.025 rows=22 loops=1)

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

Index Scan using i_sel_ti_fn_tfiles on task_files tf (cost=0.56..1,959.30 rows=524 width=62) (actual time=0.007..0.011 rows=22 loops=1)

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