explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CVgU

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.436 ↑ 38,927.2 4 1

Nested Loop (cost=5.18..746.20 rows=155,709 width=543) (actual time=0.322..0.436 rows=4 loops=1)

2. 0.011 0.300 ↑ 8.0 4 1

GroupAggregate (cost=4.62..81.00 rows=32 width=12) (actual time=0.254..0.300 rows=4 loops=1)

  • Group Key: _hyper_3_483_chunk_1.sc_song_id
3. 0.008 0.289 ↑ 1.1 28 1

Merge Append (cost=4.62..80.52 rows=32 width=12) (actual time=0.224..0.289 rows=28 loops=1)

  • Sort Key: _hyper_3_483_chunk_1.sc_song_id
4. 0.060 0.060 ↑ 1.0 4 1

Index Only Scan using _hyper_3_483_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_483_chunk _hyper_3_483_chunk_1 (cost=0.56..10.08 rows=4 width=12) (actual time=0.050..0.060 rows=4 loops=1)

  • Index Cond: (sc_song_id = ANY ('{1,2,3,4}'::integer[]))
  • Heap Fetches: 4
5. 0.036 0.036 ↑ 1.0 4 1

Index Only Scan using _hyper_3_493_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_493_chunk _hyper_3_493_chunk_1 (cost=0.56..10.04 rows=4 width=12) (actual time=0.027..0.036 rows=4 loops=1)

  • Index Cond: (sc_song_id = ANY ('{1,2,3,4}'::integer[]))
  • Heap Fetches: 4
6. 0.033 0.033 ↑ 1.0 4 1

Index Only Scan using _hyper_3_494_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_494_chunk _hyper_3_494_chunk_1 (cost=0.56..10.01 rows=4 width=12) (actual time=0.023..0.033 rows=4 loops=1)

  • Index Cond: (sc_song_id = ANY ('{1,2,3,4}'::integer[]))
  • Heap Fetches: 4
7. 0.036 0.036 ↑ 1.0 4 1

Index Only Scan using _hyper_3_495_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_495_chunk _hyper_3_495_chunk_1 (cost=0.56..10.08 rows=4 width=12) (actual time=0.027..0.036 rows=4 loops=1)

  • Index Cond: (sc_song_id = ANY ('{1,2,3,4}'::integer[]))
  • Heap Fetches: 4
8. 0.033 0.033 ↑ 1.0 4 1

Index Only Scan using _hyper_3_496_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_496_chunk _hyper_3_496_chunk_1 (cost=0.56..9.96 rows=4 width=12) (actual time=0.026..0.033 rows=4 loops=1)

  • Index Cond: (sc_song_id = ANY ('{1,2,3,4}'::integer[]))
  • Heap Fetches: 4
9. 0.032 0.032 ↑ 1.0 4 1

Index Only Scan using _hyper_3_497_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_497_chunk _hyper_3_497_chunk_1 (cost=0.56..10.00 rows=4 width=12) (actual time=0.025..0.032 rows=4 loops=1)

  • Index Cond: (sc_song_id = ANY ('{1,2,3,4}'::integer[]))
  • Heap Fetches: 4
10. 0.030 0.030 ↑ 1.0 4 1

Index Only Scan using _hyper_3_498_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_498_chunk _hyper_3_498_chunk_1 (cost=0.56..10.06 rows=4 width=12) (actual time=0.023..0.030 rows=4 loops=1)

  • Index Cond: (sc_song_id = ANY ('{1,2,3,4}'::integer[]))
  • Heap Fetches: 4
11. 0.021 0.021 ↓ 0.0 0 1

Index Only Scan using _hyper_3_499_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_499_chunk _hyper_3_499_chunk_1 (cost=0.56..9.53 rows=4 width=12) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (sc_song_id = ANY ('{1,2,3,4}'::integer[]))
  • Heap Fetches: 0
12. 0.012 0.128 ↑ 8.0 1 4

Append (cost=0.56..20.70 rows=8 width=531) (actual time=0.027..0.032 rows=1 loops=4)

13. 0.016 0.016 ↓ 0.0 0 4

Index Scan using _hyper_3_483_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_483_chunk (cost=0.56..2.58 rows=1 width=529) (actual time=0.004..0.004 rows=0 loops=4)

  • Index Cond: ((sc_song_id = _hyper_3_483_chunk_1.sc_song_id) AND (created_at = (max(_hyper_3_483_chunk_1.created_at))))
14. 0.012 0.012 ↓ 0.0 0 4

Index Scan using _hyper_3_493_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_493_chunk (cost=0.56..2.58 rows=1 width=531) (actual time=0.003..0.003 rows=0 loops=4)

  • Index Cond: ((sc_song_id = _hyper_3_483_chunk_1.sc_song_id) AND (created_at = (max(_hyper_3_483_chunk_1.created_at))))
15. 0.016 0.016 ↓ 0.0 0 4

Index Scan using _hyper_3_494_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_494_chunk (cost=0.56..2.58 rows=1 width=531) (actual time=0.004..0.004 rows=0 loops=4)

  • Index Cond: ((sc_song_id = _hyper_3_483_chunk_1.sc_song_id) AND (created_at = (max(_hyper_3_483_chunk_1.created_at))))
16. 0.012 0.012 ↓ 0.0 0 4

Index Scan using _hyper_3_495_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_495_chunk (cost=0.56..2.58 rows=1 width=533) (actual time=0.003..0.003 rows=0 loops=4)

  • Index Cond: ((sc_song_id = _hyper_3_483_chunk_1.sc_song_id) AND (created_at = (max(_hyper_3_483_chunk_1.created_at))))
17. 0.016 0.016 ↓ 0.0 0 4

Index Scan using _hyper_3_496_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_496_chunk (cost=0.56..2.58 rows=1 width=529) (actual time=0.004..0.004 rows=0 loops=4)

  • Index Cond: ((sc_song_id = _hyper_3_483_chunk_1.sc_song_id) AND (created_at = (max(_hyper_3_483_chunk_1.created_at))))
18. 0.012 0.012 ↓ 0.0 0 4

Index Scan using _hyper_3_497_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_497_chunk (cost=0.56..2.58 rows=1 width=530) (actual time=0.003..0.003 rows=0 loops=4)

  • Index Cond: ((sc_song_id = _hyper_3_483_chunk_1.sc_song_id) AND (created_at = (max(_hyper_3_483_chunk_1.created_at))))
19. 0.016 0.016 ↑ 1.0 1 4

Index Scan using _hyper_3_498_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_498_chunk (cost=0.56..2.58 rows=1 width=532) (actual time=0.004..0.004 rows=1 loops=4)

  • Index Cond: ((sc_song_id = _hyper_3_483_chunk_1.sc_song_id) AND (created_at = (max(_hyper_3_483_chunk_1.created_at))))
20. 0.016 0.016 ↓ 0.0 0 4

Index Scan using _hyper_3_499_chunk_index_sc_song_growth_metrics_on_sc_song_id_c on _hyper_3_499_chunk (cost=0.56..2.58 rows=1 width=528) (actual time=0.004..0.004 rows=0 loops=4)

  • Index Cond: ((sc_song_id = _hyper_3_483_chunk_1.sc_song_id) AND (created_at = (max(_hyper_3_483_chunk_1.created_at))))
Planning time : 11.725 ms
Execution time : 0.736 ms