explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wRta : v2 veiculo api

Settings
# exclusive inclusive rows x rows loops node
1. 12.125 203.838 ↓ 2.0 2 1

Gather (cost=6,649.76..11,508.16 rows=1 width=47) (actual time=106.096..203.838 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 13.478 191.713 ↑ 1.0 1 2

Hash Left Join (cost=5,649.76..10,508.06 rows=1 width=47) (actual time=142.867..191.713 rows=1 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 = ANY ('{0060030EDD,00600284B4}'::text[])) OR ((m2.id_fornecedor)::text = ANY ('{0060030EDD,00600284B4}'::text[]))))
  • Rows Removed by Filter: 35637
3. 29.405 113.257 ↑ 1.2 35,638 2

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

  • Hash Cond: (v.sgr_id = m.id)
4. 20.929 20.929 ↑ 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.012..20.929 rows=35,638 loops=2)

5. 29.295 62.923 ↑ 1.1 67,330 2

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

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

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

7. 36.484 64.978 ↑ 1.1 67,330 2

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

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

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

Planning time : 0.355 ms
Execution time : 203.946 ms