explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nJaZ

Settings
# exclusive inclusive rows x rows loops node
1. 2,871.672 69,269.606 ↑ 302,819.9 3,702,781 1

Nested Loop (cost=6,381,407.67..23,160,571,200.30 rows=1,121,275,594,449 width=80) (actual time=63,387.928..69,269.606 rows=3,702,781 loops=1)

2. 0.026 0.026 ↑ 1.0 1 1

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

  • Filter: (pk = 26)
  • Rows Removed by Filter: 19
3. 783.552 66,397.908 ↑ 302,819.9 3,702,781 1

Gather (cost=6,381,407.67..735,059,310.07 rows=1,121,275,594,449 width=52) (actual time=63,387.889..66,397.908 rows=3,702,781 loops=1)

  • Workers Planned: 8
  • Workers Launched: 8
4. 1,556.433 65,614.356 ↑ 340,672.4 411,420 9

Nested Loop (cost=6,381,407.67..735,059,310.07 rows=140,159,449,306 width=52) (actual time=63,473.788..65,614.356 rows=411,420 loops=9)

  • Join Filter: (cube1.manga_target_pk = manga_target1.pk)
5. 214.803 64,057.920 ↑ 1,417.8 411,420 9

Merge Join (cost=6,381,407.39..15,290,102.65 rows=583,317,169 width=60) (actual time=63,473.725..64,057.920 rows=411,420 loops=9)

  • Merge Cond: (cube1.manga_target_pk = manga_target_to_nsa1.manga_target_pk)
6. 448.329 63,547.586 ↑ 8.1 888,116 9

Sort (cost=6,381,406.51..6,399,296.13 rows=7,155,848 width=40) (actual time=63,472.850..63,547.586 rows=888,116 loops=9)

  • Sort Key: cube1.manga_target_pk
  • Sort Method: quicksort Memory: 95919kB
7. 252.543 63,099.257 ↑ 8.0 889,147 9

Merge Join (cost=5,258,643.40..5,371,017.48 rows=7,155,848 width=40) (actual time=62,720.182..63,099.257 rows=889,147 loops=9)

  • Merge Cond: (cleanspaxelprop5.file_pk = file1.pk)
8. 898.542 62,713.237 ↑ 1.1 889,147 9

Sort (cost=5,239,214.07..5,241,732.28 rows=1,007,284 width=20) (actual time=62,633.212..62,713.237 rows=889,147 loops=9)

  • Sort Key: cleanspaxelprop5.file_pk
  • Sort Method: quicksort Memory: 95919kB
9. 61,814.695 61,814.695 ↑ 1.1 889,147 9

Parallel Seq Scan on cleanspaxelprop5 (cost=0.00..5,138,777.58 rows=1,007,284 width=20) (actual time=2.158..61,814.695 rows=889,147 loops=9)

  • Filter: (emline_sew_ha_6564 > '6'::double precision)
  • Rows Removed by Filter: 815787
10. 57.444 133.477 ↓ 11.6 904,711 9

Sort (cost=19,429.34..19,623.49 rows=77,662 width=28) (actual time=86.951..133.477 rows=904,711 loops=9)

  • Sort Key: file1.pk
  • Sort Method: quicksort Memory: 2504kB
11. 46.200 76.033 ↑ 3.5 22,220 9

Nested Loop (cost=1.01..13,121.27 rows=77,662 width=28) (actual time=0.326..76.033 rows=22,220 loops=9)

12. 2.614 29.824 ↓ 6.9 4,824 9

Nested Loop (cost=0.72..10,040.26 rows=699 width=24) (actual time=0.265..29.824 rows=4,824 loops=9)

13. 11.131 27.210 ↓ 6.9 4,824 9

Nested Loop (cost=0.72..10,030.27 rows=699 width=28) (actual time=0.208..27.210 rows=4,824 loops=9)

14. 0.871 16.078 ↑ 1.0 4,824 9

Merge Append (cost=0.58..9,270.98 rows=4,824 width=28) (actual time=0.155..16.078 rows=4,824 loops=9)

  • Sort Key: cube1.manga_target_pk
15. 5.457 5.457 ↑ 1.0 973 9

Index Scan using manga_target1_pk_idx on cube1 (cost=0.29..3,714.06 rows=973 width=28) (actual time=0.105..5.457 rows=973 loops=9)

  • Filter: (pipeline_info_pk = 25)
  • Rows Removed by Filter: 9059
16. 9.750 9.750 ↑ 1.0 3,851 9

Index Scan using manga_target_pk_idx2 on cube2 (cost=0.29..5,520.73 rows=3,851 width=28) (actual time=0.042..9.750 rows=3,851 loops=9)

  • Filter: (pipeline_info_pk = 25)
  • Rows Removed by Filter: 9714
17. 0.001 0.001 ↑ 1.0 1 43,416

Index Scan using ifudesign_pkey on ifudesign (cost=0.14..0.16 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=43,416)

  • Index Cond: (pk = cube1.ifudesign_pk)
18. 0.000 0.000 ↑ 1.0 1 43,416

Materialize (cost=0.00..1.25 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=43,416)

19. 0.044 0.044 ↑ 1.0 1 9

Seq Scan on pipeline_info drpalias (cost=0.00..1.25 rows=1 width=4) (actual time=0.042..0.044 rows=1 loops=9)

  • Filter: (pk = 25)
  • Rows Removed by Filter: 19
20. 0.001 0.009 ↑ 1.2 5 43,416

Append (cost=0.29..4.35 rows=6 width=12) (actual time=0.003..0.009 rows=5 loops=43,416)

21. 0.006 0.006 ↑ 1.0 5 43,416

Index Scan using cube_pk_idx1 on file1 (cost=0.29..2.50 rows=5 width=12) (actual time=0.003..0.006 rows=5 loops=43,416)

  • Index Cond: (cube_pk = cube1.pk)
  • Filter: (pipeline_info_pk = 26)
22. 0.002 0.002 ↓ 0.0 0 43,416

Index Scan using cube_pk_idx2 on file2 (cost=0.29..1.85 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=43,416)

  • Index Cond: (cube_pk = cube1.pk)
  • Filter: (pipeline_info_pk = 26)
23. 34.718 295.531 ↓ 25.7 419,399 9

Materialize (cost=0.87..123,323.41 rows=16,303 width=20) (actual time=0.546..295.531 rows=419,399 loops=9)

24. 221.529 260.813 ↑ 1.8 9,179 9

Nested Loop (cost=0.87..123,282.65 rows=16,303 width=20) (actual time=0.540..260.813 rows=9,179 loops=9)

25. 5.602 39.279 ↑ 1.0 41,274 9

Merge Append (cost=0.58..13,918.70 rows=41,274 width=8) (actual time=0.349..39.279 rows=41,274 loops=9)

  • Sort Key: manga_target_to_nsa1.manga_target_pk
26. 17.154 17.154 ↑ 1.0 20,637 9

Index Scan using manga_target_to_nsa_targetpk_idx1 on manga_target_to_nsa1 (cost=0.29..6,803.45 rows=20,637 width=8) (actual time=0.310..17.154 rows=20,637 loops=9)

27. 16.523 16.523 ↑ 1.0 20,637 9

Index Scan using manga_target_to_nsa_targetpk_idx2 on manga_target_to_nsa2 (cost=0.29..6,805.68 rows=20,637 width=8) (actual time=0.035..16.523 rows=20,637 loops=9)

28. 0.001 0.005 ↓ 0.0 0 371,466

Append (cost=0.29..2.63 rows=2 width=20) (actual time=0.005..0.005 rows=0 loops=371,466)

29. 0.002 0.002 ↓ 0.0 0 371,466

Index Scan using nsa1_pkey on nsa1 (cost=0.29..1.31 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=371,466)

  • Index Cond: (pk = manga_target_to_nsa1.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: 0
30. 0.002 0.002 ↓ 0.0 0 371,466

Index Scan using nsa2_pkey on nsa2 (cost=0.29..1.31 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=371,466)

  • Index Cond: (pk = manga_target_to_nsa1.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: 0
31. 0.001 0.003 ↑ 2.0 1 3,702,781

Append (cost=0.29..1.21 rows=2 width=4) (actual time=0.002..0.003 rows=1 loops=3,702,781)

32. 0.001 0.001 ↑ 1.0 1 3,702,781

Index Only Scan using manga_target1_pkey on manga_target1 (cost=0.29..0.60 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=3,702,781)

  • Index Cond: (pk = manga_target_to_nsa1.manga_target_pk)
  • Heap Fetches: 0
33. 0.001 0.001 ↓ 0.0 0 3,702,781

Index Only Scan using manga_target2_pkey on manga_target2 (cost=0.29..0.60 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=3,702,781)

  • Index Cond: (pk = manga_target_to_nsa1.manga_target_pk)
  • Heap Fetches: 0
Planning time : 10.952 ms
Execution time : 69,411.192 ms