explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U7EO : Optimization for: plan #znmt

Settings

Optimization path:

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

Sort (cost=13,203.72..13,203.84 rows=46 width=14) (actual rows= loops=)

  • Sort Key: rnx.ref_time
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.73..13,202.45 rows=46 width=14) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.30..13,142.06 rows=46 width=12) (actual rows= loops=)

  • Hash Cond: (rnx.station_id = site.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on t_qc_rinex rnx (cost=0.00..13,034.62 rows=26,311 width=14) (actual rows= loops=)

  • Filter: ((ref_time >= '2004-01-05 00:00:00'::timestamp without time zone) AND (ref_time <= '2005-01-05 23:59:59'::timestamp without time zone) AND (rinex_type_id = 5::smallint))
5. 0.000 0.000 ↓ 0.0

Hash (cost=8.29..8.29 rows=1 width=2) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using t_station_marker_key on t_station site (cost=0.28..8.29 rows=1 width=2) (actual rows= loops=)

  • Index Cond: ((name)::text = 'GOPE'::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using t_qc_total_qc_rinex_id on t_qc_total tot (cost=0.42..1.29 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (qc_rinex_id = rnx.id)