explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3SWR : lr

Settings
# exclusive inclusive rows x rows loops node
1. 36,885.548 395,470.004 ↓ 17.1 56,173 1

Hash Join (cost=31.66..408,477.01 rows=3,280 width=111) (actual time=869.340..395,470.004 rows=56,173 loops=1)

  • Hash Cond: ((egauge_data.ee_site_id = points.ee_site_id) AND (egauge_data.regname = points.regname))
2. 358,584.288 358,584.288 ↓ 8.1 15,237,711 1

Index Scan using timestamp_idx on egauge_data (cost=0.58..351,634.83 rows=1,892,610 width=54) (actual time=31.678..358,584.288 rows=15,237,711 loops=1)

  • Index Cond: (("timestamp" >= '2020-07-08 08:00:00-07'::timestamp with time zone) AND ("timestamp" <= '2020-07-11 08:00:00-07'::timestamp with time zone))
3. 0.046 0.168 ↓ 1.3 13 1

Hash (cost=30.93..30.93 rows=10 width=71) (actual time=0.166..0.168 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
4. 0.058 0.122 ↓ 1.3 13 1

Bitmap Heap Scan on points (cost=4.36..30.93 rows=10 width=71) (actual time=0.072..0.122 rows=13 loops=1)

  • Recheck Cond: (circuit_label_type_desc = 'Solar'::text)
  • Heap Blocks: exact=12
5. 0.064 0.064 ↓ 1.3 13 1

Bitmap Index Scan on circuit_label_type_ind (cost=0.00..4.36 rows=10 width=0) (actual time=0.061..0.064 rows=13 loops=1)

  • Index Cond: (circuit_label_type_desc = 'Solar'::text)
Planning time : 75.856 ms
Execution time : 395,603.176 ms