explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bVYO

Settings
# exclusive inclusive rows x rows loops node
1. 4.179 85.684 ↑ 1.0 1 1

Gather (cost=6,649.76..11,508.16 rows=1 width=47) (actual time=85.480..85.684 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 7.744 81.505 ↓ 0.0 0 2

Hash Left Join (cost=5,649.76..10,508.06 rows=1 width=47) (actual time=81.423..81.505 rows=0 loops=2)

  • Hash Cond: (v.sgr_id2 = m2.id)
  • Filter: (((m.computador_bordo_id = 8) OR (m2.computador_bordo_id = 8)) AND (((m.id_fornecedor)::text = '0060030EDD'::text) OR ((m2.id_fornecedor)::text = '0060030EDD'::text)))
  • Rows Removed by Filter: 35638
3. 15.623 52.077 ↑ 1.2 35,638 2

Hash Left Join (cost=2,824.88..6,475.13 rows=41,921 width=38) (actual time=24.886..52.077 rows=35,638 loops=2)

  • Hash Cond: (v.sgr_id = m.id)
4. 12.030 12.030 ↑ 1.2 35,638 2

Parallel Seq Scan on veiculo v (cost=0.00..2,524.21 rows=41,921 width=31) (actual time=0.019..12.030 rows=35,638 loops=2)

5. 12.109 24.424 ↑ 1.1 67,329 2

Hash (cost=1,440.17..1,440.17 rows=75,417 width=23) (actual time=24.424..24.424 rows=67,329 loops=2)

  • Buckets: 65536 Batches: 2 Memory Usage: 1999kB
6. 12.315 12.315 ↑ 1.1 67,329 2

Seq Scan on modulo m (cost=0.00..1,440.17 rows=75,417 width=23) (actual time=0.014..12.315 rows=67,329 loops=2)

7. 11.639 21.684 ↑ 1.1 67,329 2

Hash (cost=1,440.17..1,440.17 rows=75,417 width=23) (actual time=21.684..21.684 rows=67,329 loops=2)

  • Buckets: 65536 Batches: 2 Memory Usage: 1999kB
8. 10.045 10.045 ↑ 1.1 67,329 2

Seq Scan on modulo m2 (cost=0.00..1,440.17 rows=75,417 width=23) (actual time=0.005..10.045 rows=67,329 loops=2)

Planning time : 0.381 ms
Execution time : 85.782 ms