explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 13il

Settings
# exclusive inclusive rows x rows loops node
1. 0.080 0.465 ↓ 17.0 17 1

Nested Loop (cost=15,146,549.83..15,265,660.96 rows=1 width=70) (actual time=0.340..0.465 rows=17 loops=1)

  • Join Filter: (tf.file_id = tfd.file_id)
  • Rows Removed by Join Filter: 357
  • Buffers: shared hit=158
  • Planning time: 0.302 ms
  • Execution time: 0.608 ms
2. 0.041 0.351 ↑ 885.0 17 1

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

  • Group Key: tfd.file_id
  • Buffers: shared hit=153
3. 0.084 0.310 ↑ 94.0 160 1

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

  • Sort Key: tfd.file_id
  • Sort Method: quicksort Memory: 32kB
  • Buffers: shared hit=153
4. 0.029 0.226 ↑ 94.0 160 1

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

  • Buffers: shared hit=153
5. 0.021 0.021 ↑ 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=0.017..0.021 rows=22 loops=1)

  • Index Cond: (task_id = '13942130'::numeric)
  • Buffers: shared hit=5
6. 0.176 0.176 ↑ 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=0.005..0.008 rows=7 loops=22)

  • Index Cond: (file_id = tf_1.file_id)
  • Heap Fetches: 160
  • Buffers: shared hit=148
7. 0.024 0.034 ↑ 23.5 22 17

Materialize (cost=0.56..2,025.27 rows=517 width=62) (actual time=0.001..0.002 rows=22 loops=17)

  • Buffers: shared hit=5
8. 0.010 0.010 ↑ 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.010 rows=22 loops=1)

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