explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GZnq

Settings
# exclusive inclusive rows x rows loops node
1. 11.348 2,062.827 ↓ 77.3 3,400 1

Sort (cost=9,137.77..9,137.88 rows=44 width=1,337) (actual time=2,062.641..2,062.827 rows=3,400 loops=1)

  • Sort Key: cr.combination_id, sr.slider_id
  • Sort Method: quicksort Memory: 1000kB
  • Buffers: shared hit=56981
2. 7.028 2,051.479 ↓ 77.3 3,400 1

Nested Loop Left Join (cost=36.03..9,136.57 rows=44 width=1,337) (actual time=41.008..2,051.479 rows=3,400 loops=1)

  • Join Filter: ((p.period_id = sr.period_id) AND ((sl.id)::numeric = cs.slider_id) AND ((sl.file_id)::numeric = cs.file_id))
  • Buffers: shared hit=56981
3. 2.037 2,041.051 ↓ 77.3 3,400 1

Nested Loop Left Join (cost=36.03..7,766.83 rows=44 width=1,249) (actual time=37.358..2,041.051 rows=3,400 loops=1)

  • Join Filter: ((dch.file_id = di.file_id) AND (dch.combination_id = (cr.combination_id)::numeric))
  • Buffers: shared hit=56645
4. 1,048.781 2,001.614 ↓ 77.3 3,400 1

Nested Loop Left Join (cost=36.03..2,840.55 rows=44 width=1,233) (actual time=0.730..2,001.614 rows=3,400 loops=1)

  • Join Filter: ((cs.combination_id = (cr.combination_id)::numeric) AND (cs.slider_id = (sr.slider_id)::numeric))
  • Rows Removed by Join Filter: 4035800
  • Buffers: shared hit=54434
5. 3.584 4.233 ↓ 77.3 3,400 1

Hash Right Join (cost=35.61..228.02 rows=44 width=1,215) (actual time=0.170..4.233 rows=3,400 loops=1)

  • Hash Cond: ((sr.analysis_id = a.id) AND (sr.combination_id = cr.combination_id))
  • Buffers: shared hit=34
6. 0.497 0.497 ↓ 1.1 680 1

Index Scan using idx_slider_result_a_id on slider_result sr (cost=0.42..176.67 rows=629 width=31) (actual time=0.009..0.497 rows=680 loops=1)

  • Index Cond: (analysis_id = 1349)
  • Buffers: shared hit=21
7. 0.008 0.152 ↓ 2.5 20 1

Hash (cost=35.07..35.07 rows=8 width=1,188) (actual time=0.152..0.152 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=13
8. 0.013 0.144 ↓ 2.5 20 1

Nested Loop Left Join (cost=15.04..35.07 rows=8 width=1,188) (actual time=0.118..0.144 rows=20 loops=1)

  • Join Filter: (a.id = cr.analysis_id)
  • Buffers: shared hit=13
9. 0.030 0.105 ↑ 1.0 1 1

Hash Right Join (cost=14.76..18.22 rows=1 width=642) (actual time=0.097..0.105 rows=1 loops=1)

  • Hash Cond: ((di.id)::numeric = d.label_id)
  • Buffers: shared hit=10
10. 0.012 0.012 ↑ 1.0 97 1

Seq Scan on dictionary_import di (cost=0.00..2.97 rows=97 width=23) (actual time=0.004..0.012 rows=97 loops=1)

  • Buffers: shared hit=2
11. 0.002 0.063 ↑ 1.0 1 1

Hash (cost=14.74..14.74 rows=1 width=623) (actual time=0.063..0.063 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=8
12. 0.019 0.061 ↑ 1.0 1 1

Hash Right Join (cost=8.30..14.74 rows=1 width=623) (actual time=0.056..0.061 rows=1 loops=1)

  • Hash Cond: (d.id = a.dataset_id)
  • Buffers: shared hit=8
13. 0.019 0.019 ↓ 1.0 109 1

Seq Scan on dictionary_dataset d (cost=0.00..6.04 rows=104 width=525) (actual time=0.005..0.019 rows=109 loops=1)

  • Buffers: shared hit=5
14. 0.004 0.023 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=102) (actual time=0.023..0.023 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
15. 0.019 0.019 ↑ 1.0 1 1

Index Scan using idx_analysis_id on analysis a (cost=0.28..8.29 rows=1 width=102) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (id = 1349)
  • Buffers: shared hit=3
16. 0.026 0.026 ↓ 2.5 20 1

Index Scan using idx_comb_result_a_id on combination_result cr (cost=0.29..16.75 rows=8 width=550) (actual time=0.019..0.026 rows=20 loops=1)

  • Index Cond: (analysis_id = 1349)
  • Buffers: shared hit=3
17. 948.600 948.600 ↓ 1.6 1,188 3,400

Index Scan using idx_dict_comb_slider_file_id on dictionary_combination_slider cs (cost=0.42..44.30 rows=754 width=24) (actual time=0.012..0.279 rows=1,188 loops=3,400)

  • Index Cond: (di.file_id = file_id)
  • Buffers: shared hit=54400
18. 0.782 37.400 ↓ 0.0 0 3,400

Materialize (cost=0.00..4,925.40 rows=1 width=26) (actual time=0.011..0.011 rows=0 loops=3,400)

  • Buffers: shared hit=2211
19. 36.618 36.618 ↓ 0.0 0 1

Seq Scan on dictionary_combination_headers dch (cost=0.00..4,925.40 rows=1 width=26) (actual time=36.618..36.618 rows=0 loops=1)

  • Filter: (language_id = 1)
  • Rows Removed by Filter: 217152
  • Buffers: shared hit=2211
20. 0.000 3.400 ↓ 0.0 0 3,400

Materialize (cost=0.00..1,368.31 rows=1 width=110) (actual time=0.001..0.001 rows=0 loops=3,400)

  • Buffers: shared hit=336
21. 0.000 3.610 ↓ 0.0 0 1

Nested Loop (cost=0.00..1,368.31 rows=1 width=110) (actual time=3.610..3.610 rows=0 loops=1)

  • Join Filter: ((sl.file_id = p.file_id) AND (sl.granulation_type_id = p.type_id))
  • Buffers: shared hit=336
22. 0.002 3.610 ↓ 0.0 0 1

Nested Loop (cost=0.00..572.20 rows=1 width=115) (actual time=3.610..3.610 rows=0 loops=1)

  • Join Filter: ((sl.file_id)::numeric = ff.file_id)
  • Buffers: shared hit=336
23. 3.608 3.608 ↓ 0.0 0 1

Seq Scan on dictionary_slider sl (cost=0.00..568.98 rows=1 width=115) (actual time=3.608..3.608 rows=0 loops=1)

  • Filter: (language_id = 1)
  • Rows Removed by Filter: 18619
  • Buffers: shared hit=336
24. 0.000 0.000 ↓ 0.0 0

Seq Scan on dictionary_import ff (cost=0.00..3.21 rows=1 width=5) (never executed)

  • Filter: (id = 123)
25. 0.000 0.000 ↓ 0.0 0

Seq Scan on dictionary_period p (cost=0.00..796.09 rows=1 width=17) (never executed)