explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QJ1

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 40.976 ↑ 1.0 100 1

Limit (cost=0.42..9.15 rows=100 width=1,184) (actual time=23.688..40.976 rows=100 loops=1)

  • Buffers: shared hit=1 read=12
2. 0.034 40.940 ↑ 8,219.2 100 1

Append (cost=0.42..71,679.13 rows=821,919 width=1,184) (actual time=23.686..40.940 rows=100 loops=1)

  • Buffers: shared hit=1 read=12
3. 14.703 14.703 ↓ 0.0 0 1

Index Scan using _hyper_1_897_chunk_facteventflow_event_time_idx on _hyper_1_897_chunk (cost=0.42..2.64 rows=1 width=1,184) (actual time=14.702..14.703 rows=0 loops=1)

  • Index Cond: ((event_time >= '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time <= '2018-09-18 00:00:00+00'::timestamp with time zone))
  • Buffers: shared read=3
4. 26.203 26.203 ↑ 8,219.2 100 1

Index Scan using _hyper_1_896_chunk_facteventflow_event_time_idx on _hyper_1_896_chunk (cost=0.42..71,676.49 rows=821,918 width=1,183) (actual time=8.980..26.203 rows=100 loops=1)

  • Index Cond: ((event_time >= '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time <= '2018-09-18 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=1 read=9
5. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_895_chunk_facteventflow_event_time_idx on _hyper_1_895_chunk (cost=0.42..71,678.47 rows=821,917 width=1,184) (never executed)

  • Index Cond: ((event_time >= '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time <= '2018-09-18 00:00:00+00'::timestamp with time zone))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_894_chunk_facteventflow_event_time_idx on _hyper_1_894_chunk (cost=0.42..71,675.49 rows=821,918 width=1,184) (never executed)

  • Index Cond: ((event_time >= '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time <= '2018-09-18 00:00:00+00'::timestamp with time zone))