explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fuSu

Settings
# exclusive inclusive rows x rows loops node
1. 0.045 4.869 ↑ 6.1 33 1

Sort (cost=2,308.47..2,308.97 rows=200 width=27) (actual time=4.868..4.869 rows=33 loops=1)

  • Sort Key: _hyper_10_183_chunk."timestamp" DESC
  • Sort Method: quicksort Memory: 27kB
2. 0.056 4.824 ↑ 6.1 33 1

Unique (cost=2,289.19..2,298.83 rows=200 width=27) (actual time=4.753..4.824 rows=33 loops=1)

3. 0.497 4.768 ↑ 4.6 421 1

Sort (cost=2,289.19..2,294.01 rows=1,927 width=27) (actual time=4.753..4.768 rows=421 loops=1)

  • Sort Key: _hyper_10_183_chunk.content_id, _hyper_10_183_chunk."timestamp" DESC
  • Sort Method: quicksort Memory: 57kB
4. 0.053 4.271 ↑ 4.6 421 1

Append (cost=0.43..2,184.06 rows=1,927 width=27) (actual time=0.052..4.271 rows=421 loops=1)

5. 0.180 0.180 ↑ 7.9 16 1

Index Scan using _hyper_10_183_chunk_archive_login_idx on _hyper_10_183_chunk (cost=0.43..141.98 rows=126 width=27) (actual time=0.051..0.180 rows=16 loops=1)

  • Index Cond: (login_code = 960,996)
6. 0.266 0.266 ↑ 5.5 22 1

Index Scan using _hyper_10_185_chunk_archive_login_idx on _hyper_10_185_chunk (cost=0.43..137.66 rows=122 width=27) (actual time=0.050..0.266 rows=22 loops=1)

  • Index Cond: (login_code = 960,996)
7. 0.143 0.143 ↑ 12.1 10 1

Index Scan using _hyper_10_190_chunk_archive_login_idx on _hyper_10_190_chunk (cost=0.43..136.45 rows=121 width=27) (actual time=0.047..0.143 rows=10 loops=1)

  • Index Cond: (login_code = 960,996)
8. 0.181 0.181 ↑ 6.0 20 1

Index Scan using _hyper_10_191_chunk_archive_login_idx on _hyper_10_191_chunk (cost=0.43..135.41 rows=120 width=27) (actual time=0.042..0.181 rows=20 loops=1)

  • Index Cond: (login_code = 960,996)
9. 0.381 0.381 ↑ 3.7 33 1

Index Scan using _hyper_10_196_chunk_archive_login_idx on _hyper_10_196_chunk (cost=0.43..137.50 rows=122 width=27) (actual time=0.052..0.381 rows=33 loops=1)

  • Index Cond: (login_code = 960,996)
10. 0.665 0.665 ↑ 1.8 70 1

Index Scan using _hyper_10_197_chunk_archive_login_idx on _hyper_10_197_chunk (cost=0.43..145.56 rows=129 width=27) (actual time=0.037..0.665 rows=70 loops=1)

  • Index Cond: (login_code = 960,996)
11. 0.415 0.415 ↑ 2.8 51 1

Index Scan using _hyper_10_200_chunk_archive_login_idx on _hyper_10_200_chunk (cost=0.43..159.99 rows=142 width=27) (actual time=0.055..0.415 rows=51 loops=1)

  • Index Cond: (login_code = 960,996)
12. 0.099 0.099 ↑ 13.9 9 1

Index Scan using _hyper_10_203_chunk_archive_login_idx on _hyper_10_203_chunk (cost=0.43..141.05 rows=125 width=27) (actual time=0.043..0.099 rows=9 loops=1)

  • Index Cond: (login_code = 960,996)
13. 0.121 0.121 ↑ 9.7 13 1

Index Scan using _hyper_10_207_chunk_archive_login_idx on _hyper_10_207_chunk (cost=0.43..142.16 rows=126 width=27) (actual time=0.038..0.121 rows=13 loops=1)

  • Index Cond: (login_code = 960,996)
14. 0.029 0.029 ↓ 0.0 0 1

Index Scan using _hyper_10_209_chunk_archive_login_idx on _hyper_10_209_chunk (cost=0.43..139.85 rows=124 width=27) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: (login_code = 960,996)
15. 0.169 0.169 ↑ 6.2 19 1

Index Scan using _hyper_10_212_chunk_archive_login_idx on _hyper_10_212_chunk (cost=0.43..133.21 rows=118 width=27) (actual time=0.047..0.169 rows=19 loops=1)

  • Index Cond: (login_code = 960,996)
16. 0.497 0.497 ↑ 2.4 51 1

Index Scan using _hyper_10_215_chunk_archive_login_idx on _hyper_10_215_chunk (cost=0.43..136.49 rows=121 width=27) (actual time=0.036..0.497 rows=51 loops=1)

  • Index Cond: (login_code = 960,996)
17. 0.679 0.679 ↑ 1.8 71 1

Index Scan using _hyper_10_219_chunk_archive_login_idx on _hyper_10_219_chunk (cost=0.43..141.00 rows=125 width=27) (actual time=0.052..0.679 rows=71 loops=1)

  • Index Cond: (login_code = 960,996)
18. 0.218 0.218 ↑ 5.8 24 1

Index Scan using _hyper_10_221_chunk_archive_login_idx on _hyper_10_221_chunk (cost=0.43..156.72 rows=139 width=27) (actual time=0.049..0.218 rows=24 loops=1)

  • Index Cond: (login_code = 960,996)
19. 0.134 0.134 ↑ 10.1 12 1

Index Scan using _hyper_10_226_chunk_archive_login_idx on _hyper_10_226_chunk (cost=0.43..136.53 rows=121 width=27) (actual time=0.038..0.134 rows=12 loops=1)

  • Index Cond: (login_code = 960,996)
20. 0.041 0.041 ↓ 0.0 0 1

Index Scan using _hyper_10_227_chunk_archive_login_idx on _hyper_10_227_chunk (cost=0.42..52.85 rows=46 width=27) (actual time=0.041..0.041 rows=0 loops=1)

  • Index Cond: (login_code = 960,996)
Planning time : 5.364 ms
Execution time : 5.153 ms