explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5cIO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 13.295 ↓ 1.3 118 1

"QUERY PLAN": "HashAggregate (cost=170.55..171.69 rows=91 width=574) (actual time=11.490..13.295 rows=118 loops=1)

  • },
  • "QUERY PLAN": " Group Key: _hyper_14_151_chunk.\"timestamp\", _hyper_14_151_chunk.tsp, _hyper_14_151_chunk.affpubid
  • },
  • "QUERY PLAN": " Buffers: shared hit=331
  • },
  • },
  • "QUERY PLAN": " Buffers: shared hit=331
  • },
  • },
  • "QUERY PLAN": " Buffers: shared hit=4
  • },
  • },
  • "QUERY PLAN": " Index Cond: ((\"timestamp\" >= '2020-07-01 00:00:00+00'::timestamp with time zone) AND (\"timestamp\" <= '2020-07-27 15:23:33.130006+00'::timestamp with time zone))
  • },
  • "QUERY PLAN": " Buffers: shared hit=2
  • },
  • },
  • "QUERY PLAN": " Filter: ((\"timestamp\" >= '2020-07-01 00:00:00+00'::timestamp with time zone) AND (\"timestamp\" <= '2020-07-27 15:23:33.130006+00'::timestamp with time zone))
  • },
  • "QUERY PLAN": " Buffers: shared hit=2
  • },
  • },
  • "QUERY PLAN": " Index Cond: ((rate_date = (_hyper_14_151_chunk.\"timestamp\")::date) AND ((\"from\")::text = 'EUR'::text) AND ((\"to\")::text = 'USD'::text) AND ((source)::text = 'ecb'::text))
  • },
  • "QUERY PLAN": " Buffers: shared hit=327
  • },
  • "QUERY PLAN": "Planning Time: 21.205 ms
  • },
  • "QUERY PLAN": "Execution Time: 16.434 ms
  • }]
2. 8.851 8.851 ↓ 1.3 118 1

"QUERY PLAN": " -> Nested Loop Left Join (cost=0.43..138.02 rows=91 width=76) (actual time=0.186..8.851 rows=118 loops=1)

3. 3.787 3.787 ↓ 1.3 118 1

"QUERY PLAN": " -> Append (cost=0.15..6.17 rows=91 width=70) (actual time=0.046..3.787 rows=118 loops=1)

4. 0.435 0.435 ↓ 28.0 28 1

"QUERY PLAN": " -> Index Scan using _hyper_14_151_chunk_new_aggregates_hourly_timestamp_idx1 on _hyper_14_151_chunk (cost=0.15..2.37 rows=1 width=96) (actual time=0.028..0.435 rows=28 loops=1)

5. 1.481 1.481 ↑ 1.0 90 1

"QUERY PLAN": " -> Seq Scan on _hyper_14_152_chunk (cost=0.00..3.35 rows=90 width=70) (actual time=0.691..1.481 rows=90 loops=1)

6. 1.770 1.770 ↑ 1.0 1 118

"QUERY PLAN": " -> Index Scan using currency_rates_rate_date_from_to_source_idx on currency_rates cr (cost=0.29..1.45 rows=1 width=10) (actual time=0.014..0.015 rows=1 loops=118)