explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PjA : Optimization for: plan #c0X

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.46..127,804.36 rows=2 width=8) (actual rows= loops=)

  • Hash Cond: (tbl006_counter.t006_id_ficheiro = tbl004_parametersection.t004_id_ficheiro)
2. 0.000 0.000 ↓ 0.0

Seq Scan on tbl006_counter (cost=0.00..109,059.82 rows=4,996,282 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=8.45..8.45 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using tbl004_parametersection_idx1 on tbl004_parametersection (cost=0.43..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (((t004_starttime)::text >= '2019-02-07 00:00:00'::text) AND ((t004_starttime)::text <= '2019-02-08 00:00:00'::text))