explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DLCN

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

Sort (cost=22,056.67..22,168.86 rows=44,874 width=58) (actual rows= loops=)

  • Sort Key: b."time
2.          

Initplan (for Sort)

3. 0.000 0.000 ↓ 0.0

Seq Scan on rtcrm_well a (cost=0.00..1.85 rows=1 width=9) (actual rows= loops=)

  • Filter: ((well_name)::text = 'FURRH CARTER HV UNIT 2H'::text)
4. 0.000 0.000 ↓ 0.0

Result (cost=58.75..18,587.50 rows=44,874 width=58) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Append (cost=58.75..17,914.39 rows=44,874 width=35) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_6_8_chunk b (cost=58.75..5,181.74 rows=1,790 width=96) (actual rows= loops=)

  • Recheck Cond: ((well_unique_id)::text = ($0)::text)
  • Filter: ("time" >= '2000-01-01'::date)
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on _hyper_6_8_chunk_rtcrm_edr_enhanced_part_wellid_idx (cost=0.00..58.30 rows=5,370 width=0) (actual rows= loops=)

  • Index Cond: ((well_unique_id)::text = ($0)::text)
8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_6_10_chunk b_1 (cost=68.47..6,131.40 rows=2,121 width=96) (actual rows= loops=)

  • Recheck Cond: ((well_unique_id)::text = ($0)::text)
  • Filter: ("time" >= '2000-01-01'::date)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on _hyper_6_10_chunk_rtcrm_edr_enhanced_part_wellid_idx (cost=0.00..67.94 rows=6,362 width=0) (actual rows= loops=)

  • Index Cond: ((well_unique_id)::text = ($0)::text)
10. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_6_9_chunk b_2 (cost=41.17..3,640.82 rows=1,259 width=96) (actual rows= loops=)

  • Recheck Cond: ((well_unique_id)::text = ($0)::text)
  • Filter: ("time" >= '2000-01-01'::date)
11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on _hyper_6_9_chunk_rtcrm_edr_enhanced_part_wellid_idx (cost=0.00..40.85 rows=3,777 width=0) (actual rows= loops=)

  • Index Cond: ((well_unique_id)::text = ($0)::text)
12. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_6_7_chunk_rtcrm_edr_enhanced_part_wellid_idx on _hyper_6_7_chunk b_3 (cost=0.42..2,736.05 rows=39,704 width=27) (actual rows= loops=)

  • Index Cond: ((well_unique_id)::text = ($0)::text)
  • Filter: ("time" >= '2000-01-01'::date)