explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yJZp

Settings
# exclusive inclusive rows x rows loops node
1. 5.771 363.617 ↓ 53.3 2,346 1

Sort (cost=5,450.47..5,450.58 rows=44 width=960) (actual time=363.402..363.617 rows=2,346 loops=1)

  • Sort Key: cr.combination_id, sr.slider_id
  • Sort Method: quicksort Memory: 738kB
  • Buffers: shared hit=15047
2. 3.266 357.846 ↓ 53.3 2,346 1

Nested Loop Left Join (cost=26.84..5,449.27 rows=44 width=960) (actual time=14.698..357.846 rows=2,346 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=15044
3. 1.030 352.234 ↓ 53.3 2,346 1

Nested Loop Left Join (cost=26.84..4,826.21 rows=44 width=868) (actual time=11.947..352.234 rows=2,346 loops=1)

  • Join Filter: ((dch.file_id = di.file_id) AND (dch.combination_id = (cr.combination_id)::numeric))
  • Buffers: shared hit=14819
4. 175.087 339.474 ↓ 53.3 2,346 1

Nested Loop Left Join (cost=26.84..3,236.18 rows=44 width=852) (actual time=0.510..339.474 rows=2,346 loops=1)

  • Join Filter: ((cs.combination_id = (cr.combination_id)::numeric) AND (cs.slider_id = (sr.slider_id)::numeric))
  • Rows Removed by Join Filter: 699108
  • Buffers: shared hit=14106
5. 1.717 2.513 ↓ 53.3 2,346 1

Hash Right Join (cost=26.42..171.02 rows=44 width=834) (actual time=0.396..2.513 rows=2,346 loops=1)

  • Hash Cond: ((sr.analysis_id = a.id) AND (sr.combination_id = cr.combination_id))
  • Buffers: shared hit=30
6. 0.506 0.506 ↓ 1.2 391 1

Index Scan using idx_slider_result_a_id on slider_result sr (cost=0.42..132.13 rows=332 width=29) (actual time=0.091..0.506 rows=391 loops=1)

  • Index Cond: (analysis_id = 1349)
  • Buffers: shared hit=17
7. 0.024 0.290 ↓ 2.3 30 1

Hash (cost=25.80..25.80 rows=13 width=809) (actual time=0.290..0.290 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=13
8. 0.014 0.266 ↓ 2.3 30 1

Nested Loop Left Join (cost=12.90..25.80 rows=13 width=809) (actual time=0.234..0.266 rows=30 loops=1)

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

Hash Right Join (cost=12.62..14.63 rows=1 width=266) (actual time=0.202..0.218 rows=1 loops=1)

  • Hash Cond: ((di.id)::numeric = d.label_id)
  • Buffers: shared hit=10
10. 0.005 0.005 ↓ 1.0 69 1

Seq Scan on dictionary_import di (cost=0.00..1.67 rows=67 width=26) (actual time=0.004..0.005 rows=69 loops=1)

  • Buffers: shared hit=1
11. 0.007 0.163 ↑ 1.0 1 1

Hash (cost=12.61..12.61 rows=1 width=244) (actual time=0.163..0.163 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=6
12. 0.024 0.156 ↑ 1.0 1 1

Hash Right Join (cost=8.30..12.61 rows=1 width=244) (actual time=0.098..0.156 rows=1 loops=1)

  • Hash Cond: (d.id = a.dataset_id)
  • Buffers: shared hit=6
13. 0.062 0.062 ↓ 1.0 96 1

Seq Scan on dictionary_dataset d (cost=0.00..3.94 rows=94 width=141) (actual time=0.011..0.062 rows=96 loops=1)

  • Buffers: shared hit=3
14. 0.012 0.070 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=107) (actual time=0.070..0.070 rows=1 loops=1)

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

Index Scan using idx_analysis_id on analysis a (cost=0.27..8.29 rows=1 width=107) (actual time=0.057..0.058 rows=1 loops=1)

  • Index Cond: (id = 1349)
  • Buffers: shared hit=3
16. 0.034 0.034 ↓ 2.3 30 1

Index Scan using idx_comb_result_a_id on combination_result cr (cost=0.29..11.01 rows=13 width=547) (actual time=0.030..0.034 rows=30 loops=1)

  • Index Cond: (analysis_id = 1349)
  • Buffers: shared hit=3
17. 161.874 161.874 ↑ 3.1 299 2,346

Index Scan using idx_dict_comb_slider_file_id on dictionary_combination_slider cs (cost=0.42..50.88 rows=939 width=24) (actual time=0.021..0.069 rows=299 loops=2,346)

  • Index Cond: (di.file_id = file_id)
  • Buffers: shared hit=14076
18. 0.300 11.730 ↓ 0.0 0 2,346

Materialize (cost=0.00..1,589.16 rows=1 width=26) (actual time=0.005..0.005 rows=0 loops=2,346)

  • Buffers: shared hit=713
19. 11.430 11.430 ↓ 0.0 0 1

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

  • Filter: (language_id = 1)
  • Rows Removed by Filter: 70092
  • Buffers: shared hit=713
20. 0.000 2.346 ↓ 0.0 0 2,346

Materialize (cost=0.00..621.63 rows=1 width=114) (actual time=0.001..0.001 rows=0 loops=2,346)

  • Buffers: shared hit=225
21. 0.001 2.683 ↓ 0.0 0 1

Nested Loop (cost=0.00..621.63 rows=1 width=114) (actual time=2.683..2.683 rows=0 loops=1)

  • Join Filter: ((sl.file_id = p.file_id) AND (sl.granulation_type_id = p.type_id))
  • Buffers: shared hit=225
22. 0.001 2.682 ↓ 0.0 0 1

Nested Loop (cost=0.00..382.45 rows=1 width=119) (actual time=2.682..2.682 rows=0 loops=1)

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

Seq Scan on dictionary_slider sl (cost=0.00..380.60 rows=1 width=119) (actual time=2.681..2.681 rows=0 loops=1)

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

Seq Scan on dictionary_import ff (cost=0.00..1.84 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..239.16 rows=1 width=17) (never executed)

  • Filter: (language_id = 1)