explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FNq3

Settings
# exclusive inclusive rows x rows loops node
1. 193.775 1,004.710 ↑ 1.0 374,927 1

Gather (cost=18,142.95..84,948.38 rows=385,602 width=59) (actual time=721.325..1,004.710 rows=374,927 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 50.947 810.935 ↑ 1.3 124,976 3

Hash Join (cost=17,142.95..45,388.18 rows=160,668 width=59) (actual time=641.832..810.935 rows=124,976 loops=3)

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

Parallel Hash Join (cost=16,564.95..44,388.34 rows=160,668 width=51) (actual time=634.576..753.076 rows=124,976 loops=3)

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

Parallel Hash Join (cost=6,979.45..30,334.09 rows=160,668 width=42) (actual time=51.382..392.797 rows=124,976 loops=3)

  • Hash Cond: (res.fk_pagamento_estacionamento_id = pag.id)
5. 139.445 139.445 ↑ 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.422..139.445 rows=500,000 loops=3)

6. 18.191 50.147 ↑ 1.3 41,661 3

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

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

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

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

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

  • Buckets: 65536 Batches: 8 Memory Usage: 3968kB
9. 30.971 30.971 ↑ 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.015..30.971 rows=166,667 loops=3)

10. 3.741 6.912 ↑ 1.0 20,000 3

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

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

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