explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZWv7

Settings
# exclusive inclusive rows x rows loops node
1. 213.743 1,075.028 ↑ 1.0 374,927 1

Gather (cost=18,143.20..84,963.34 rows=385,746 width=59) (actual time=772.262..1,075.028 rows=374,927 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 54.585 861.285 ↑ 1.3 124,976 3

Hash Join (cost=17,143.20..45,388.74 rows=160,728 width=59) (actual time=677.919..861.285 rows=124,976 loops=3)

  • Hash Cond: (veic.fk_motorista_id = mot.id)
3. 239.853 799.757 ↑ 1.3 124,976 3

Parallel Hash Join (cost=16,565.20..44,388.74 rows=160,728 width=51) (actual time=670.590..799.757 rows=124,976 loops=3)

  • Hash Cond: (res.fk_veiculo_id = veic.id)
4. 206.689 396.005 ↑ 1.3 124,976 3

Parallel Hash Join (cost=6,979.70..30,334.34 rows=160,728 width=42) (actual time=45.660..396.005 rows=124,976 loops=3)

  • Hash Cond: (res.fk_pagamento_estacionamento_id = pag.id)
5. 144.658 144.658 ↑ 1.2 500,000 3

Parallel Seq Scan on reserva res (cost=0.00..21,714.00 rows=625,000 width=36) (actual time=0.177..144.658 rows=500,000 loops=3)

6. 14.886 44.658 ↑ 1.3 41,661 3

Parallel Hash (cost=6,310.00..6,310.00 rows=53,576 width=14) (actual time=44.658..44.658 rows=41,661 loops=3)

  • Buckets: 131072 Batches: 1 Memory Usage: 6912kB
7. 29.772 29.772 ↑ 1.3 41,661 3

Parallel Seq Scan on pagamento_estacionamento pag (cost=0.00..6,310.00 rows=53,576 width=14) (actual time=0.026..29.772 rows=41,661 loops=3)

  • Filter: ((data > '1980-01-01'::date) AND (data < '2000-01-01'::date))
  • Rows Removed by Filter: 125006
8. 121.412 163.899 ↑ 1.2 166,667 3

Parallel Hash (cost=5,760.33..5,760.33 rows=208,333 width=17) (actual time=163.899..163.899 rows=166,667 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 4000kB
9. 42.487 42.487 ↑ 1.2 166,667 3

Parallel Seq Scan on veiculo veic (cost=0.00..5,760.33 rows=208,333 width=17) (actual time=0.022..42.487 rows=166,667 loops=3)

10. 3.760 6.943 ↑ 1.0 20,000 3

Hash (cost=328.00..328.00 rows=20,000 width=16) (actual time=6.943..6.943 rows=20,000 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1194kB
11. 3.183 3.183 ↑ 1.0 20,000 3

Seq Scan on motorista mot (cost=0.00..328.00 rows=20,000 width=16) (actual time=0.086..3.183 rows=20,000 loops=3)