explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wqxb

Settings
# exclusive inclusive rows x rows loops node
1. 1.698 1,550.927 ↑ 5.7 7,541 1

Hash Join (cost=134,058.91..175,751.26 rows=43,008 width=140) (actual time=1,535.823..1,550.927 rows=7,541 loops=1)

  • Hash Cond: ((hl.machine_key)::text = b.machine_key)
2. 2.597 1,549.153 ↑ 37.5 8,500 1

Hash Left Join (cost=134,055.78..171,708.37 rows=318,577 width=276) (actual time=1,535.733..1,549.153 rows=8,500 loops=1)

  • Hash Cond: (((hl.machine_key)::text = (s.machine_key)::text) AND (hl.species_group_key = s.species_group_key))
3. 2.176 1,546.433 ↑ 37.5 8,500 1

Hash Left Join (cost=134,042.55..162,914.36 rows=318,577 width=129) (actual time=1,535.599..1,546.433 rows=8,500 loops=1)

  • Hash Cond: (((hl.machine_key)::text = (p.machine_key)::text) AND (hl.product_key = p.product_key))
4. 2.673 1,543.794 ↑ 37.5 8,500 1

Hash Left Join (cost=133,999.60..153,293.50 rows=318,577 width=118) (actual time=1,535.123..1,543.794 rows=8,500 loops=1)

  • Hash Cond: (((hl.machine_key)::text = (o.machine_key)::text) AND (hl.object_key = o.object_key) AND (hl.sub_object_key = o.sub_object_key))
5. 2.484 1,540.913 ↑ 37.5 8,500 1

Hash Left Join (cost=133,979.19..142,521.03 rows=318,577 width=76) (actual time=1,534.900..1,540.913 rows=8,500 loops=1)

  • Hash Cond: ((hl.machine_key)::text = (mi.machine_key)::text)
  • Join Filter: (((hl.contractor_id)::text = (mi.contractor_id)::text) OR ((hl.contractor_id IS NULL) AND (mi.contractor_id IS NULL)))
6. 1,348.406 1,538.391 ↑ 37.5 8,500 1

HashAggregate (cost=133,977.59..137,163.36 rows=318,577 width=90) (actual time=1,534.826..1,538.391 rows=8,500 loops=1)

  • Group Key: hl.machine_key, hl.contractor_id, hl.operator_key, hl.object_key, hl.sub_object_key, hl.harvest_date, hl.species_group_key, hl.product_key
7. 189.985 189.985 ↑ 1.0 3,185,772 1

Seq Scan on harvester_logs hl (cost=0.00..62,297.72 rows=3,185,772 width=66) (actual time=0.006..189.985 rows=3,185,772 loops=1)

8. 0.016 0.038 ↑ 1.0 49 1

Hash (cost=0.99..0.99 rows=49 width=60) (actual time=0.038..0.038 rows=49 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
9. 0.022 0.022 ↑ 1.0 49 1

Seq Scan on machine_info mi (cost=0.00..0.99 rows=49 width=60) (actual time=0.014..0.022 rows=49 loops=1)

10. 0.099 0.208 ↑ 1.1 492 1

Hash (cost=11.24..11.24 rows=524 width=68) (actual time=0.208..0.208 rows=492 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
11. 0.109 0.109 ↑ 1.0 524 1

Seq Scan on objects o (cost=0.00..11.24 rows=524 width=68) (actual time=0.005..0.109 rows=524 loops=1)

12. 0.223 0.463 ↑ 1.0 1,218 1

Hash (cost=24.68..24.68 rows=1,218 width=47) (actual time=0.463..0.463 rows=1,218 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 111kB
13. 0.240 0.240 ↑ 1.0 1,218 1

Seq Scan on products p (cost=0.00..24.68 rows=1,218 width=47) (actual time=0.005..0.240 rows=1,218 loops=1)

14. 0.065 0.123 ↑ 1.0 389 1

Hash (cost=7.39..7.39 rows=389 width=39) (actual time=0.123..0.123 rows=389 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
15. 0.058 0.058 ↑ 1.0 389 1

Seq Scan on species s (cost=0.00..7.39 rows=389 width=39) (actual time=0.006..0.058 rows=389 loops=1)

16. 0.016 0.076 ↑ 1.0 27 1

Hash (cost=2.80..2.80 rows=27 width=23) (actual time=0.076..0.076 rows=27 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
17. 0.060 0.060 ↑ 1.0 27 1

Seq Scan on contractor_access b (cost=0.00..2.80 rows=27 width=23) (actual time=0.044..0.060 rows=27 loops=1)

  • Filter: ((active <> 0) AND (t4e_contractor_id = 'thomas.solvin@nibio.no'::text))
  • Rows Removed by Filter: 93