explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ExHg

Settings
# exclusive inclusive rows x rows loops node
1. 5,919.405 63,717.041 ↓ 5,477.5 3,702,781 1

Nested Loop (cost=2,016.36..12,690.78 rows=676 width=80) (actual time=310.251..63,717.041 rows=3,702,781 loops=1)

2. 0.016 0.016 ↑ 1.0 1 1

Seq Scan on pipeline_info dapalias (cost=0.00..1.25 rows=1 width=4) (actual time=0.013..0.016 rows=1 loops=1)

  • Filter: (pk = 26)
  • Rows Removed by Filter: 19
3. 3,023.202 57,797.620 ↓ 5,477.5 3,702,781 1

Gather (cost=2,016.36..12,676.01 rows=676 width=52) (actual time=310.221..57,797.620 rows=3,702,781 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 48,177.605 54,774.418 ↓ 4,651.7 1,851,390 2

Nested Loop (cost=2,016.36..12,676.01 rows=398 width=52) (actual time=290.568..54,774.418 rows=1,851,390 loops=2)

5. 23.407 6,580.069 ↓ 648.0 2,592 2

Nested Loop (cost=2,015.93..7,791.85 rows=4 width=40) (actual time=280.623..6,580.069 rows=2,592 loops=2)

6. 21.324 6,556.656 ↓ 648.0 2,592 2

Nested Loop (cost=2,015.93..7,786.81 rows=4 width=44) (actual time=280.603..6,556.656 rows=2,592 loops=2)

7. 1,006.628 6,535.327 ↓ 648.0 2,592 2

Nested Loop (cost=2,015.79..7,786.18 rows=4 width=44) (actual time=280.581..6,535.327 rows=2,592 loops=2)

8. 5,168.155 5,525.595 ↓ 64.8 324 2

Nested Loop (cost=2,015.50..7,771.87 rows=5 width=40) (actual time=280.553..5,525.595 rows=324 loops=2)

9. 12.530 353.722 ↑ 1.8 1,390 2

Hash Join (cost=2,015.21..3,494.63 rows=2,437 width=28) (actual time=271.059..353.722 rows=1,390 loops=2)

  • Hash Cond: (manga_target.pk = manga_target_to_nsa.manga_target_pk)
10. 7.763 125.551 ↑ 1.2 2,412 2

Merge Join (cost=862.54..2,306.95 rows=2,838 width=32) (actual time=49.612..125.551 rows=2,412 loops=2)

  • Merge Cond: (manga_target.pk = cube.manga_target_pk)
11. 75.735 75.735 ↑ 1.2 24,028 2

Parallel Index Only Scan using manga_target_pkey on manga_target (cost=0.29..1,322.25 rows=28,268 width=4) (actual time=9.835..75.735 rows=24,028 loops=2)

  • Heap Fetches: 23900
12. 5.537 42.053 ↑ 1.0 4,688 2

Sort (cost=862.11..874.17 rows=4,824 width=28) (actual time=39.570..42.053 rows=4,688 loops=2)

  • Sort Key: cube.manga_target_pk
  • Sort Method: quicksort Memory: 569kB
13. 35.171 36.516 ↑ 1.0 4,824 2

Bitmap Heap Scan on cube (cost=93.67..566.97 rows=4,824 width=28) (actual time=5.604..36.516 rows=4,824 loops=2)

  • Recheck Cond: (pipeline_info_pk = 25)
  • Heap Blocks: exact=368
14. 1.345 1.345 ↑ 1.0 4,824 2

Bitmap Index Scan on pipelineinfo_pk_idx (cost=0.00..92.47 rows=4,824 width=0) (actual time=1.345..1.345 rows=4,824 loops=2)

  • Index Cond: (pipeline_info_pk = 25)
15. 11.436 215.641 ↑ 1.0 41,274 2

Hash (cost=636.74..636.74 rows=41,274 width=8) (actual time=215.641..215.641 rows=41,274 loops=2)

  • Buckets: 65536 Batches: 1 Memory Usage: 2125kB
16. 204.205 204.205 ↑ 1.0 41,274 2

Seq Scan on manga_target_to_nsa (cost=0.00..636.74 rows=41,274 width=8) (actual time=0.352..204.205 rows=41,274 loops=2)

17. 3.718 3.718 ↓ 0.0 0 2,780

Index Scan using nsa_pkey on nsa (cost=0.29..1.76 rows=1 width=20) (actual time=3.718..3.718 rows=0 loops=2,780)

  • Index Cond: (pk = manga_target_to_nsa.nsa_pk)
  • Filter: ((sersic_n < '2'::double precision) AND (CASE WHEN (sersic_mass > '0'::double precision) THEN log(sersic_mass) WHEN (sersic_mass = '0'::double precision) THEN '0'::double precision ELSE NULL::double precision END >= '9.5'::double precision) AND (CASE WHEN (sersic_mass > '0'::double precision) THEN log(sersic_mass) WHEN (sersic_mass = '0'::double precision) THEN '0'::double precision ELSE NULL::double precision END < '11'::double precision))
  • Rows Removed by Filter: 1
18. 3.104 3.104 ↓ 4.0 8 649

Index Scan using cube_pk_idx on file (cost=0.29..2.84 rows=2 width=12) (actual time=1.077..3.104 rows=8 loops=649)

  • Index Cond: (cube_pk = cube.pk)
  • Filter: (pipeline_info_pk = 26)
19. 0.005 0.005 ↑ 1.0 1 5,184

Index Scan using ifudesign_pkey on ifudesign (cost=0.14..0.16 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=5,184)

  • Index Cond: (pk = cube.ifudesign_pk)
20. 0.006 0.006 ↑ 1.0 1 5,184

Seq Scan on pipeline_info drpalias (cost=0.00..1.25 rows=1 width=4) (actual time=0.004..0.006 rows=1 loops=5,184)

  • Filter: (pk = 25)
  • Rows Removed by Filter: 19
21. 16.744 16.744 ↑ 1.0 714 5,184

Index Scan using clean_file5_pk_idx on cleanspaxelprop5 (cost=0.43..1,213.67 rows=737 width=20) (actual time=4.027..16.744 rows=714 loops=5,184)

  • Index Cond: (file_pk = file.pk)
  • Filter: (emline_sew_ha_6564 > '6'::double precision)
  • Rows Removed by Filter: 146
Planning time : 1,173.050 ms
Execution time : 64,202.706 ms