explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dqtk

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 2.546 ↓ 4.0 4 1

Subquery Scan on _ (cost=4.62..81.88 rows=1 width=16) (actual time=2.067..2.546 rows=4 loops=1)

  • Filter: (_.row_number = 1)
  • Rows Removed by Filter: 24
2. 0.048 2.541 ↑ 1.1 28 1

WindowAgg (cost=4.62..81.48 rows=32 width=24) (actual time=2.066..2.541 rows=28 loops=1)

3. 0.005 2.493 ↑ 1.1 28 1

Result (cost=4.62..80.84 rows=32 width=16) (actual time=2.044..2.493 rows=28 loops=1)

4. 0.015 2.488 ↑ 1.1 28 1

Merge Append (cost=4.62..80.52 rows=32 width=16) (actual time=2.043..2.488 rows=28 loops=1)

  • Sort Key: _hyper_3_483_chunk.sc_song_id, _hyper_3_483_chunk.created_at DESC
5. 0.188 0.188 ↑ 1.0 4 1

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..10.08 rows=4 width=16) (actual time=0.156..0.188 rows=4 loops=1)

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

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..10.04 rows=4 width=16) (actual time=0.476..0.770 rows=4 loops=1)

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

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..10.01 rows=4 width=16) (actual time=0.142..0.182 rows=4 loops=1)

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

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..10.08 rows=4 width=16) (actual time=0.574..0.610 rows=4 loops=1)

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

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..9.96 rows=4 width=16) (actual time=0.262..0.272 rows=4 loops=1)

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

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..10.00 rows=4 width=16) (actual time=0.106..0.116 rows=4 loops=1)

  • Index Cond: (sc_song_id = ANY ('{1,2,3,4}'::integer[]))
11. 0.266 0.266 ↑ 1.0 4 1

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..10.06 rows=4 width=16) (actual time=0.255..0.266 rows=4 loops=1)

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

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..9.53 rows=4 width=16) (actual time=0.069..0.069 rows=0 loops=1)

  • Index Cond: (sc_song_id = ANY ('{1,2,3,4}'::integer[]))
Planning time : 16.313 ms
Execution time : 2.731 ms