explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uych : Optimization for: plan #MhuQ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 568.251 ↑ 1.0 1 1

Finalize Aggregate (cost=153,778.35..153,778.36 rows=1 width=8) (actual time=568.251..568.251 rows=1 loops=1)

2. 27.740 568.247 ↓ 1.5 3 1

Gather (cost=153,778.13..153,778.34 rows=2 width=8) (actual time=568.242..568.247 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 5.046 540.507 ↑ 1.0 1 3

Partial Aggregate (cost=152,778.13..152,778.14 rows=1 width=8) (actual time=540.507..540.507 rows=1 loops=3)

4. 113.623 535.461 ↓ 4.7 94,162 3

Hash Semi Join (cost=52.73..152,728.31 rows=19,929 width=0) (actual time=110.007..535.461 rows=94,162 loops=3)

  • Hash Cond: (bilhetes_01.biplaca = (veiculos.veplaca)::text)
5. 421.475 421.475 ↓ 1.7 462,572 3

Parallel Seq Scan on bilhetes_01 (cost=0.00..151,748.88 rows=268,569 width=9) (actual time=109.059..421.475 rows=462,572 loops=3)

  • Filter: ((bidataevento >= '2018-11-01 00:00:00'::timestamp without time zone) AND (bidataevento <= '2018-11-01 23:59:00'::timestamp without time zone))
  • Rows Removed by Filter: 756568
6. 0.021 0.363 ↑ 1.0 63 3

Hash (cost=51.94..51.94 rows=63 width=9) (actual time=0.363..0.363 rows=63 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
7. 0.342 0.342 ↑ 1.0 63 3

Seq Scan on veiculos (cost=0.00..51.94 rows=63 width=9) (actual time=0.055..0.342 rows=63 loops=3)

  • Filter: (veproprietario = 60)
  • Rows Removed by Filter: 1292
Planning time : 0.594 ms
Execution time : 584.474 ms