explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DKmP : Now

Settings
# exclusive inclusive rows x rows loops node
1. 16.750 223.847 ↑ 2.0 2 1

Gather (cost=6,649.76..11,509.15 rows=4 width=47) (actual time=150.269..223.847 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 13.966 207.097 ↑ 2.0 1 2

Hash Left Join (cost=5,649.76..10,508.75 rows=2 width=47) (actual time=172.412..207.097 rows=1 loops=2)

  • Hash Cond: (v.sgr_id2 = m2.id)
  • Filter: (((m.id_fornecedor)::text = ANY ('{0060030EDD,00600284B4}'::text[])) OR ((m2.id_fornecedor)::text = ANY ('{0060030EDD,00600284B4}'::text[])))
  • Rows Removed by Filter: 35678
3. 27.444 118.778 ↑ 1.2 35,679 2

Hash Left Join (cost=2,824.88..6,475.70 rows=41,966 width=34) (actual time=73.668..118.778 rows=35,679 loops=2)

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

Parallel Seq Scan on veiculo v (cost=0.00..2,524.66 rows=41,966 width=31) (actual time=0.012..18.047 rows=35,679 loops=2)

5. 46.367 73.287 ↑ 1.1 67,398 2

Hash (cost=1,440.17..1,440.17 rows=75,417 width=19) (actual time=73.287..73.287 rows=67,398 loops=2)

  • Buckets: 65536 Batches: 2 Memory Usage: 1871kB
6. 26.920 26.920 ↑ 1.1 67,398 2

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

7. 37.954 74.353 ↑ 1.1 67,398 2

Hash (cost=1,440.17..1,440.17 rows=75,417 width=19) (actual time=74.353..74.353 rows=67,398 loops=2)

  • Buckets: 65536 Batches: 2 Memory Usage: 1871kB
8. 36.399 36.399 ↑ 1.1 67,398 2

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

Planning time : 0.356 ms
Execution time : 224.038 ms