explain.depesz.com

A tool for finding a real cause for slow queries.

Result: XYh

options
# exclusive inclusive rows x rows loops node
1. 31.733 122.689 ↑ 1.6 2116 1
→

Sort (cost=340158.91..340167.33 rows=3368 width=93) (actual time=122.217..122.689 rows=2116 loops=1)

  • Sort Key: cp_expression_htemp.primekey, cp_dbstudy.dbstudy_name, cp_sample.dbsdesc
2. 4.635 90.956 ↑ 1.6 2116 1
→

Hash Join (cost=1900.63..339961.58 rows=3368 width=93) (actual time=62.850..90.956 rows=2116 loops=1)

  • Hash Cond: ("outer".cp_hyb_id = "inner".id)
3. 23.905 25.971 ↑ 14.5 7248 1
→

Bitmap Heap Scan on cp_expression_htemp (cost=660.44..338161.42 rows=105255 width=16) (actual time=2.464..25.971 rows=7248 loops=1)

  • Recheck Cond: ((primekey = 430890) OR (primekey = 460099))
4. 0.002 2.066 ↓ 0.0 0 1
→

BitmapOr (cost=660.44..660.44 rows=105268 width=0) (actual time=2.066..2.066 rows=0 loops=1)

5. 0.867 0.867 ↑ 14.5 3624 1
→

Bitmap Index Scan on cp_expression_htemp_pk_idx (cost=0.00..330.22 rows=52634 width=0) (actual time=0.867..0.867 rows=3624 loops=1)

  • Index Cond: (primekey = 430890)
6. 1.197 1.197 ↑ 14.5 3624 1
→

Bitmap Index Scan on cp_expression_htemp_pk_idx (cost=0.00..330.22 rows=52634 width=0) (actual time=1.197..1.197 rows=3624 loops=1)

  • Index Cond: (primekey = 460099)
7. 1.920 60.350 ↓ 3.0 1569 1
→

Hash (cost=1238.90..1238.90 rows=515 width=85) (actual time=60.350..60.350 rows=1569 loops=1)

8. 6.644 58.430 ↓ 3.0 1569 1
→

Hash Join (cost=775.13..1238.90 rows=515 width=85) (actual time=38.292..58.430 rows=1569 loops=1)

  • Hash Cond: ("outer".cp_sample_id = "inner".id)
9. 13.570 13.570 ↓ 1.0 15328 1
→

Seq Scan on cp_hyb (cost=0.00..382.06 rows=15313 width=8) (actual time=0.038..13.570 rows=15328 loops=1)

  • Filter: ((include_hyb)::text = 'Y'::text)
10. 2.253 38.216 ↓ 3.6 2260 1
→

Hash (cost=773.57..773.57 rows=622 width=85) (actual time=38.216..38.216 rows=2260 loops=1)

11. 22.645 35.963 ↓ 3.6 2260 1
→

Hash Join (cost=28.75..773.57 rows=622 width=85) (actual time=0.719..35.963 rows=2260 loops=1)

  • Hash Cond: ("outer".cp_dbstudy_id = "inner".id)
12. 12.655 12.655 ↑ 1.0 18507 1
→

Seq Scan on cp_sample (cost=0.00..646.07 rows=18507 width=32) (actual time=0.025..12.655 rows=18507 loops=1)

13. 0.016 0.663 ↓ 1.1 15 1
→

Hash (cost=28.71..28.71 rows=14 width=61) (actual time=0.663..0.663 rows=15 loops=1)

14. 0.647 0.647 ↓ 1.1 15 1
→

Seq Scan on cp_dbstudy (cost=0.00..28.71 rows=14 width=61) (actual time=0.034..0.647 rows=15 loops=1)

  • Filter: ((((dbstudy_name)::text = 'Breast cancer'::text) OR ((dbstudy_name)::text = 'Cervical cancer'::text) OR ((dbstudy_name)::text = 'ColonCA'::text) OR ((dbstudy_name)::text = 'ColonCA-Met'::text) OR ((dbstudy_name)::text = 'Esophageal cancer'::text) OR ((dbstudy_name)::text = 'Glioblastoma'::text) OR ((dbstudy_name)::text = 'Leukemia'::text) OR ((dbstudy_name)::text = 'Lung cancer'::text) OR ((dbstudy_name)::text = 'Melanoma'::text) OR ((dbstudy_name)::text = 'OVCA-Garvan'::text) OR ((dbstudy_name)::text = 'Pancreatic cancer'::text) OR ((dbstudy_name)::text = 'Renal cancer'::text) OR ((dbstudy_name)::text = 'Sarcoma'::text) OR ((dbstudy_name)::text = 'Stomach cancer'::text) OR ((dbstudy_name)::text = 'z Human Body Atlas'::text)) AND display)