explain.depesz.com

PostgreSQL's explain analyze made readable

Result: naSk

Settings
# exclusive inclusive rows x rows loops node
1. 75.826 10,167.900 ↑ 4.1 390,740 1

Unique (cost=1,306,561.35..1,314,527.64 rows=1,593,259 width=184) (actual time=10,075.758..10,167.900 rows=390,740 loops=1)

2. 221.979 10,092.074 ↑ 3.7 428,169 1

Sort (cost=1,306,561.35..1,310,544.50 rows=1,593,259 width=184) (actual time=10,075.755..10,092.074 rows=428,169 loops=1)

  • Sort Key: st.stem_key, mdt.value_item DESC NULLS LAST
  • Sort Method: quicksort Memory: 126021kB
3. 1,217.175 9,870.095 ↑ 3.7 428,169 1

Hash Right Join (cost=883,774.33..1,091,859.90 rows=1,593,259 width=184) (actual time=8,030.107..9,870.095 rows=428,169 loops=1)

  • Hash Cond: (lat.hjid = ct.latitude_coordinates_type_hj_0)
4. 626.869 626.869 ↑ 1.0 5,865,352 1

Seq Scan on latitude_type lat (cost=0.00..76,804.02 rows=5,865,352 width=18) (actual time=0.027..626.869 rows=5,865,352 loops=1)

5. 162.464 8,026.051 ↑ 3.7 428,169 1

Hash (cost=845,965.09..845,965.09 rows=1,593,259 width=157) (actual time=8,026.050..8,026.051 rows=428,169 loops=1)

  • Buckets: 1048576 Batches: 2 Memory Usage: 44701kB
6. 1,228.065 7,863.587 ↑ 3.7 428,169 1

Hash Right Join (cost=674,505.85..845,965.09 rows=1,593,259 width=157) (actual time=5,976.786..7,863.587 rows=428,169 loops=1)

  • Hash Cond: (lon.hjid = ct.longitude_coordinates_type_h_0)
7. 665.745 665.745 ↑ 1.0 5,865,352 1

Seq Scan on longitude_type lon (cost=0.00..76,804.02 rows=5,865,352 width=17) (actual time=0.024..665.745 rows=5,865,352 loops=1)

8. 151.673 5,969.777 ↑ 3.7 428,169 1

Hash (cost=637,474.61..637,474.61 rows=1,593,259 width=148) (actual time=5,969.777..5,969.777 rows=428,169 loops=1)

  • Buckets: 2097152 Batches: 2 Memory Usage: 49680kB
9. 1,206.421 5,818.104 ↑ 3.7 428,169 1

Hash Right Join (cost=435,321.40..637,474.61 rows=1,593,259 width=148) (actual time=3,671.881..5,818.104 rows=428,169 loops=1)

  • Hash Cond: (ct.stem_coordinates_stem_type_h_0 = st.hjid)
10. 946.742 946.742 ↑ 1.2 5,865,352 1

Seq Scan on coordinates_type ct (cost=0.00..109,006.68 rows=6,749,768 width=20) (actual time=0.011..946.742 rows=5,865,352 loops=1)

11. 156.501 3,664.941 ↑ 3.3 428,169 1

Hash (cost=403,459.03..403,459.03 rows=1,430,990 width=136) (actual time=3,664.941..3,664.941 rows=428,169 loops=1)

  • Buckets: 2097152 Batches: 2 Memory Usage: 47180kB
12. 788.836 3,508.440 ↑ 3.3 428,169 1

Hash Join (cost=276,596.16..403,459.03 rows=1,430,990 width=136) (actual time=2,242.489..3,508.440 rows=428,169 loops=1)

  • Hash Cond: (st.hjid = shp.hjid)
13. 483.769 483.769 ↑ 1.0 6,062,322 1

Seq Scan on stem_type st (cost=0.00..90,185.22 rows=6,062,322 width=66) (actual time=0.034..483.769 rows=6,062,322 loops=1)

14. 105.808 2,235.835 ↑ 3.3 428,169 1

Hash (cost=258,708.79..258,708.79 rows=1,430,990 width=74) (actual time=2,235.835..2,235.835 rows=428,169 loops=1)

  • Buckets: 2097152 Batches: 1 Memory Usage: 61434kB
15. 692.699 2,130.027 ↑ 3.3 428,169 1

Hash Join (cost=148,534.51..258,708.79 rows=1,430,990 width=74) (actual time=1,079.491..2,130.027 rows=428,169 loops=1)

  • Hash Cond: (stps.hjid = shp.single_tree_processed_stem_s_0)
16. 364.356 364.356 ↑ 1.0 6,014,653 1

Seq Scan on single_tree_processed_stem_t_0 stps (cost=0.00..73,785.03 rows=6,014,653 width=8) (actual time=0.025..364.356 rows=6,014,653 loops=1)

17. 102.317 1,072.972 ↑ 3.3 428,169 1

Hash (cost=130,647.13..130,647.13 rows=1,430,990 width=74) (actual time=1,072.972..1,072.972 rows=428,169 loops=1)

  • Buckets: 2097152 Batches: 1 Memory Usage: 61543kB
18. 564.437 970.655 ↑ 3.3 428,169 1

Hash Join (cost=8,066.13..130,647.13 rows=1,430,990 width=74) (actual time=95.040..970.655 rows=428,169 loops=1)

  • Hash Cond: (shp.stem_machine_harvested_produ_0 = mt.hjid)
19. 311.264 311.264 ↑ 1.0 6,062,322 1

Seq Scan on stem_harvested_production_ty_0 shp (cost=0.00..84,940.76 rows=6,221,426 width=12) (actual time=0.020..311.264 rows=6,062,322 loops=1)

20. 2.904 94.954 ↓ 1.4 7,689 1

Hash (cost=7,996.51..7,996.51 rows=5,569 width=74) (actual time=94.954..94.954 rows=7,689 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 905kB
21. 8.193 92.050 ↓ 1.4 7,689 1

Gather (cost=3,291.40..7,996.51 rows=5,569 width=74) (actual time=56.230..92.050 rows=7,689 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
22. 11.263 83.857 ↓ 1.2 3,844 2

Nested Loop Left Join (cost=2,291.40..6,439.61 rows=3,276 width=74) (actual time=55.626..83.857 rows=3,844 loops=2)

23. 12.803 72.592 ↓ 1.2 3,844 2

Nested Loop Left Join (cost=2,291.10..4,890.87 rows=3,276 width=77) (actual time=55.583..72.592 rows=3,844 loops=2)

24. 2.941 59.786 ↓ 1.2 3,844 2

Hash Join (cost=2,290.81..3,727.64 rows=3,276 width=73) (actual time=55.532..59.786 rows=3,844 loops=2)

  • Hash Cond: (xfl.hjid = hpt.hjid)
25. 9.718 9.718 ↑ 1.2 11,858 2

Parallel Seq Scan on xml_file_list xfl (cost=0.00..1,351.80 rows=13,939 width=41) (actual time=0.029..9.718 rows=11,858 loops=2)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_hpr.harvested_production_type'::text)
  • Rows Removed by Filter: 5838
26. 2.585 47.127 ↑ 1.1 7,689 2

Hash (cost=2,187.99..2,187.99 rows=8,226 width=40) (actual time=47.127..47.127 rows=7,689 loops=2)

  • Buckets: 16384 Batches: 1 Memory Usage: 669kB
27. 6.121 44.542 ↑ 1.1 7,689 2

Hash Right Join (cost=1,631.37..2,187.99 rows=8,226 width=40) (actual time=34.480..44.542 rows=7,689 loops=2)

  • Hash Cond: (mht.hjid = hpt.harvested_production_header__0)
28. 4.077 4.077 ↑ 1.0 23,657 2

Seq Scan on message_header_type mht (cost=0.00..383.42 rows=24,292 width=8) (actual time=0.021..4.077 rows=23,657 loops=2)

29. 2.708 34.344 ↑ 1.1 7,689 2

Hash (cost=1,528.55..1,528.55 rows=8,226 width=40) (actual time=34.344..34.344 rows=7,689 loops=2)

  • Buckets: 16384 Batches: 1 Memory Usage: 669kB
30. 6.552 31.636 ↑ 1.1 7,689 2

Hash Join (cost=976.90..1,528.55 rows=8,226 width=40) (actual time=20.937..31.636 rows=7,689 loops=2)

  • Hash Cond: (hpt.hjid = mhp.machine_harvested_production_0)
31. 4.309 4.309 ↑ 1.0 23,657 2

Seq Scan on harvested_production_type hpt (cost=0.00..379.89 rows=24,339 width=8) (actual time=0.028..4.309 rows=23,657 loops=2)

32. 2.690 20.775 ↑ 1.1 7,689 2

Hash (cost=874.08..874.08 rows=8,226 width=32) (actual time=20.775..20.775 rows=7,689 loops=2)

  • Buckets: 16384 Batches: 1 Memory Usage: 609kB
33. 6.658 18.085 ↑ 1.1 7,689 2

Hash Join (cost=487.48..874.08 rows=8,226 width=32) (actual time=7.689..18.085 rows=7,689 loops=2)

  • Hash Cond: (mhp.hjid = mt.hjid)
34. 3.839 3.839 ↑ 1.1 23,657 2

Seq Scan on machine_harvested_production_1 mhp (cost=0.00..321.28 rows=24,878 width=8) (actual time=0.028..3.839 rows=23,657 loops=2)

35. 2.507 7.588 ↑ 1.0 7,689 2

Hash (cost=387.41..387.41 rows=8,006 width=24) (actual time=7.588..7.588 rows=7,689 loops=2)

  • Buckets: 8192 Batches: 1 Memory Usage: 485kB
36. 3.913 5.081 ↑ 1.0 7,689 2

Bitmap Heap Scan on machine_type mt (cost=104.33..387.41 rows=8,006 width=24) (actual time=1.207..5.081 rows=7,689 loops=2)

  • Recheck Cond: ((machine_key)::text = 'FeltGIS_00031'::text)
  • Heap Blocks: exact=138
37. 1.168 1.168 ↑ 1.0 7,689 2

Bitmap Index Scan on machine_type_machine_key_idx (cost=0.00..102.33 rows=8,006 width=0) (actual time=1.168..1.168 rows=7,689 loops=2)

  • Index Cond: ((machine_key)::text = 'FeltGIS_00031'::text)
38. 0.003 0.003 ↑ 1.0 1 7,689

Index Scan using modification_date_type_pkey on modification_date_type mdt (cost=0.29..0.36 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=7,689)

  • Index Cond: (mht.modification_date_message_he_0 = hjid)
39. 0.002 0.002 ↑ 1.0 1 7,689

Index Scan using contact_information_type_pkey on contact_information_type cit (cost=0.29..0.47 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=7,689)

  • Index Cond: (hjid = mt.logging_contractor_machine_t_0)