explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MhuQ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 39.157 215,016.786 ↑ 1.0 1 1

Aggregate (cost=125,463.50..125,463.51 rows=1 width=8) (actual time=215,016.786..215,016.786 rows=1 loops=1)

2. 10,799.253 214,977.629 ↓ 263,794.0 263,794 1

Nested Loop Semi Join (cost=0.56..125,463.50 rows=1 width=0) (actual time=78,006.620..214,977.629 rows=263,794 loops=1)

  • Join Filter: (bilhetes_01.biplaca = (veiculos.veplaca)::text)
  • Rows Removed by Join Filter: 75256120
3. 8,890.008 8,890.008 ↓ 1,319,516.0 1,319,516 1

Index Only Scan using bilhetes_01_bimodulo_idx on bilhetes_01 (cost=0.56..125,410.77 rows=1 width=9) (actual time=0.207..8,890.008 rows=1,319,516 loops=1)

  • Index Cond: ((bidataevento >= '2018-10-01 00:00:00'::timestamp without time zone) AND (bidataevento <= '2018-10-01 23:59:00'::timestamp without time zone))
  • Heap Fetches: 1319516
4. 195,288.368 195,288.368 ↑ 1.1 57 1,319,516

Seq Scan on veiculos (cost=0.00..51.94 rows=63 width=9) (actual time=0.001..0.148 rows=57 loops=1,319,516)

  • Filter: (veproprietario = 60)
  • Rows Removed by Filter: 1253