explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5NZv

Settings
# exclusive inclusive rows x rows loops node
1. 4.176 36.509 ↓ 54.6 2,346 1

Sort (cost=2,736.53..2,736.64 rows=43 width=968) (actual time=36.409..36.509 rows=2,346 loops=1)

  • Sort Key: cr.combination_id, sr.slider_id
  • Sort Method: quicksort Memory: 738kB
  • Buffers: shared hit=10340 read=9
2. 2.376 32.333 ↓ 54.6 2,346 1

Nested Loop Left Join (cost=25.99..2,735.36 rows=43 width=968) (actual time=15.751..32.333 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=10337 read=9
3. 0.000 27.611 ↓ 54.6 2,346 1

Nested Loop Left Join (cost=25.99..2,112.90 rows=43 width=876) (actual time=13.125..27.611 rows=2,346 loops=1)

  • Join Filter: ((dch.file_id = di.file_id) AND (dch.combination_id = (cr.combination_id)::numeric))
  • Buffers: shared hit=10112 read=9
4. 2.717 13.792 ↓ 54.6 2,346 1

Nested Loop Left Join (cost=25.99..522.88 rows=43 width=860) (actual time=0.298..13.792 rows=2,346 loops=1)

  • Buffers: shared hit=9399 read=9
5. 1.244 1.691 ↓ 54.6 2,346 1

Hash Right Join (cost=25.57..159.21 rows=43 width=842) (actual time=0.239..1.691 rows=2,346 loops=1)

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

Index Scan using idx_slider_result_a_id on slider_result sr (cost=0.42..121.19 rows=332 width=30) (actual time=0.029..0.246 rows=391 loops=1)

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

Hash (cost=24.95..24.95 rows=13 width=816) (actual time=0.201..0.201 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=12
8. 0.010 0.177 ↓ 2.3 30 1

Nested Loop Left Join (cost=11.93..24.95 rows=13 width=816) (actual time=0.146..0.177 rows=30 loops=1)

  • Join Filter: (a.id = cr.analysis_id)
  • Buffers: shared hit=12
9. 0.043 0.138 ↑ 1.0 1 1

Hash Right Join (cost=11.64..13.69 rows=1 width=272) (actual time=0.122..0.138 rows=1 loops=1)

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

Seq Scan on dictionary_import di (cost=0.00..1.69 rows=69 width=26) (actual time=0.003..0.008 rows=69 loops=1)

  • Buffers: shared hit=1
11. 0.010 0.087 ↑ 1.0 1 1

Hash (cost=11.63..11.63 rows=1 width=250) (actual time=0.087..0.087 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=5
12. 0.021 0.077 ↑ 1.0 1 1

Hash Right Join (cost=8.30..11.63 rows=1 width=250) (actual time=0.057..0.077 rows=1 loops=1)

  • Hash Cond: (d.id = a.dataset_id)
  • Buffers: shared hit=5
13. 0.023 0.023 ↑ 1.0 96 1

Seq Scan on dictionary_dataset d (cost=0.00..2.96 rows=96 width=147) (actual time=0.010..0.023 rows=96 loops=1)

  • Buffers: shared hit=2
14. 0.008 0.033 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
15. 0.025 0.025 ↑ 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.024..0.025 rows=1 loops=1)

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

Index Scan using idx_comb_result_a_id on combination_result cr (cost=0.29..11.09 rows=13 width=548) (actual time=0.021..0.029 rows=30 loops=1)

  • Index Cond: (analysis_id = 1349)
  • Buffers: shared hit=3
17. 9.384 9.384 ↑ 1.0 1 2,346

Index Scan using pt_t2 on dictionary_combination_slider cs (cost=0.42..8.45 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=2,346)

  • Index Cond: ((combination_id = (cr.combination_id)::numeric) AND (slider_id = (sr.slider_id)::numeric) AND (di.file_id = file_id))
  • Buffers: shared hit=9375 read=9
18. 1.258 14.076 ↓ 0.0 0 2,346

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

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

Seq Scan on dictionary_combination_headers dch (cost=0.00..1,589.15 rows=1 width=26) (actual time=12.818..12.818 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.07 rows=1 width=114) (actual time=0.001..0.001 rows=0 loops=2,346)

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

Nested Loop (cost=0.00..621.07 rows=1 width=114) (actual time=2.599..2.599 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.598 ↓ 0.0 0 1

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

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

Seq Scan on dictionary_slider sl (cost=0.00..380.65 rows=1 width=119) (actual time=2.597..2.597 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.86 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..238.53 rows=1 width=17) (never executed)