explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vcmwq

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 16,281.787 ↑ 1.0 100 1

Limit (cost=12,135.72..12,135.97 rows=100 width=1,184) (actual time=16,281.717..16,281.787 rows=100 loops=1)

  • Buffers: shared hit=6390 read=4368
2. 17.859 16,281.738 ↑ 102.7 100 1

Sort (cost=12,135.72..12,161.40 rows=10,272 width=1,184) (actual time=16,281.715..16,281.738 rows=100 loops=1)

  • Sort Key: _hyper_1_862_chunk.event_time DESC
  • Sort Method: top-N heapsort Memory: 101kB
  • Buffers: shared hit=6390 read=4368
3. 6.302 16,263.879 ↓ 1.0 10,343 1

Append (cost=0.42..11,743.13 rows=10,272 width=1,184) (actual time=9.988..16,263.879 rows=10,343 loops=1)

  • Buffers: shared hit=6390 read=4368
4. 257.131 257.131 ↑ 1.1 330 1

Index Scan using _hyper_1_862_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_862_chunk (cost=0.42..396.71 rows=349 width=1,183) (actual time=9.987..257.131 rows=330 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=271 read=72
5. 594.309 594.309 ↑ 1.0 314 1

Index Scan using _hyper_1_861_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_861_chunk (cost=0.42..372.11 rows=327 width=1,183) (actual time=9.348..594.309 rows=314 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=170 read=158
6. 423.122 423.122 ↑ 1.1 335 1

Index Scan using _hyper_1_860_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_860_chunk (cost=0.42..424.92 rows=374 width=1,183) (actual time=9.836..423.122 rows=335 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=240 read=108
7. 614.640 614.640 ↓ 1.0 340 1

Index Scan using _hyper_1_859_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_859_chunk (cost=0.42..376.68 rows=331 width=1,183) (actual time=9.356..614.640 rows=340 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=190 read=164
8. 692.030 692.030 ↑ 1.0 354 1

Index Scan using _hyper_1_858_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_858_chunk (cost=0.42..403.50 rows=355 width=1,184) (actual time=19.257..692.030 rows=354 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=177 read=191
9. 573.492 573.492 ↑ 1.1 313 1

Index Scan using _hyper_1_857_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_857_chunk (cost=0.42..381.06 rows=335 width=1,183) (actual time=12.747..573.492 rows=313 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=176 read=150
10. 334.910 334.910 ↑ 1.1 297 1

Index Scan using _hyper_1_856_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_856_chunk (cost=0.42..364.31 rows=319 width=1,184) (actual time=9.275..334.910 rows=297 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=222 read=87
11. 597.842 597.842 ↓ 1.1 342 1

Index Scan using _hyper_1_855_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_855_chunk (cost=0.42..364.14 rows=320 width=1,183) (actual time=7.437..597.842 rows=342 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=191 read=163
12. 355.963 355.963 ↑ 1.0 329 1

Index Scan using _hyper_1_854_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_854_chunk (cost=0.42..391.15 rows=344 width=1,183) (actual time=5.363..355.963 rows=329 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=245 read=96
13. 616.346 616.346 ↑ 1.0 320 1

Index Scan using _hyper_1_853_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_853_chunk (cost=0.42..374.27 rows=329 width=1,183) (actual time=13.791..616.346 rows=320 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=158 read=174
14. 377.424 377.424 ↓ 1.0 337 1

Index Scan using _hyper_1_852_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_852_chunk (cost=0.42..365.25 rows=321 width=1,184) (actual time=5.735..377.424 rows=337 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=246 read=103
15. 599.374 599.374 ↓ 1.1 344 1

Index Scan using _hyper_1_851_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_851_chunk (cost=0.42..349.65 rows=306 width=1,183) (actual time=9.695..599.374 rows=344 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=205 read=153
16. 632.320 632.320 ↓ 1.1 322 1

Index Scan using _hyper_1_850_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_850_chunk (cost=0.42..338.34 rows=296 width=1,183) (actual time=13.994..632.320 rows=322 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=169 read=167
17. 556.175 556.175 ↓ 1.0 339 1

Index Scan using _hyper_1_849_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_849_chunk (cost=0.42..372.08 rows=327 width=1,184) (actual time=12.347..556.175 rows=339 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=195 read=157
18. 609.371 609.371 ↑ 1.0 335 1

Index Scan using _hyper_1_848_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_848_chunk (cost=0.42..390.10 rows=343 width=1,184) (actual time=8.835..609.371 rows=335 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=185 read=163
19. 369.823 369.823 ↑ 1.0 333 1

Index Scan using _hyper_1_847_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_847_chunk (cost=0.42..383.18 rows=337 width=1,184) (actual time=7.675..369.823 rows=333 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=242 read=105
20. 663.988 663.988 ↓ 1.0 347 1

Index Scan using _hyper_1_846_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_846_chunk (cost=0.42..377.70 rows=332 width=1,183) (actual time=7.081..663.988 rows=347 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=181 read=180
21. 624.286 624.286 ↓ 1.1 344 1

Index Scan using _hyper_1_845_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_845_chunk (cost=0.42..364.34 rows=320 width=1,183) (actual time=14.338..624.286 rows=344 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=194 read=163
22. 305.277 305.277 ↑ 1.0 330 1

Index Scan using _hyper_1_844_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_844_chunk (cost=0.42..375.40 rows=330 width=1,184) (actual time=5.458..305.277 rows=330 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=256 read=88
23. 713.779 713.779 ↓ 1.1 359 1

Index Scan using _hyper_1_843_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_843_chunk (cost=0.42..376.49 rows=331 width=1,183) (actual time=10.918..713.779 rows=359 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=186 read=186
24. 599.923 599.923 ↑ 1.0 331 1

Index Scan using _hyper_1_842_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_842_chunk (cost=0.42..383.26 rows=337 width=1,184) (actual time=14.294..599.923 rows=331 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=177 read=168
25. 372.529 372.529 ↓ 1.0 340 1

Index Scan using _hyper_1_841_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_841_chunk (cost=0.42..374.38 rows=329 width=1,184) (actual time=5.745..372.529 rows=340 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=262 read=92
26. 608.576 608.576 ↑ 1.1 318 1

Index Scan using _hyper_1_840_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_840_chunk (cost=0.42..381.10 rows=335 width=1,183) (actual time=9.603..608.576 rows=318 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=162 read=170
27. 383.452 383.452 ↑ 1.0 336 1

Index Scan using _hyper_1_839_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_839_chunk (cost=0.42..390.13 rows=343 width=1,184) (actual time=6.077..383.452 rows=336 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=251 read=99
28. 617.326 617.326 ↓ 1.0 338 1

Index Scan using _hyper_1_838_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_838_chunk (cost=0.42..372.16 rows=327 width=1,183) (actual time=13.189..617.326 rows=338 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=186 read=165
29. 372.124 372.124 ↑ 1.0 327 1

Index Scan using _hyper_1_837_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_837_chunk (cost=0.42..381.00 rows=335 width=1,184) (actual time=8.158..372.124 rows=327 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=245 read=95
30. 644.297 644.297 ↑ 1.1 308 1

Index Scan using _hyper_1_836_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_836_chunk (cost=0.42..397.80 rows=350 width=1,184) (actual time=13.716..644.297 rows=308 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=153 read=169
31. 399.508 399.508 ↓ 1.2 353 1

Index Scan using _hyper_1_835_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_835_chunk (cost=0.42..344.06 rows=301 width=1,184) (actual time=6.927..399.508 rows=353 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=261 read=105
32. 644.059 644.059 ↓ 1.0 356 1

Index Scan using _hyper_1_834_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_834_chunk (cost=0.42..401.37 rows=353 width=1,184) (actual time=9.520..644.059 rows=356 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=187 read=184
33. 644.028 644.028 ↓ 1.0 338 1

Index Scan using _hyper_1_833_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_833_chunk (cost=0.42..370.93 rows=326 width=1,184) (actual time=11.405..644.028 rows=338 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=173 read=179
34. 460.153 460.153 ↓ 1.1 334 1

Index Scan using _hyper_1_832_chunk_facteventflow_app_type_target_id_event_time_ on _hyper_1_832_chunk (cost=0.42..354.19 rows=310 width=1,184) (actual time=7.338..460.153 rows=334 loops=1)

  • Index Cond: ((app_type = ANY ('{3,2}'::integer[])) AND (target_id = ANY ('{1,2}'::integer[])) AND (event_time > '2018-07-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-08-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=234 read=114