explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7K7C

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

Sort (cost=8,436.59..8,438.44 rows=739 width=16) (actual rows= loops=)

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

Nested Loop (cost=1,034.57..8,401.38 rows=739 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on t_qc_rinex rnx (cost=1,034.15..3,043.59 rows=739 width=14) (actual rows= loops=)

  • Recheck Cond: ((station_id = ANY ('{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16}'::integer[])) AND (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))
4. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=1,034.15..1,034.15 rows=739 width=0) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on t_qc_rinex_ref_time_station_id (cost=0.00..296.22 rows=12,994 width=0) (actual rows= loops=)

  • Index Cond: (station_id = ANY ('{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16}'::integer[]))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on t_qc_rinex_ref_time_type_id (cost=0.00..737.31 rows=26,311 width=0) (actual rows= loops=)

  • Index Cond: ((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))
7. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (qc_rinex_id = rnx.id)