explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eIIZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 0.601 ↓ 0.0 0 1

Sort (cost=2,307.29..2,307.79 rows=200 width=27) (actual time=0.601..0.601 rows=0 loops=1)

  • Sort Key: _hyper_10_183_chunk."timestamp" DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.000 0.564 ↓ 0.0 0 1

Unique (cost=2,288.01..2,297.64 rows=200 width=27) (actual time=0.564..0.564 rows=0 loops=1)

3. 0.028 0.564 ↓ 0.0 0 1

Sort (cost=2,288.01..2,292.83 rows=1,926 width=27) (actual time=0.563..0.564 rows=0 loops=1)

  • Sort Key: _hyper_10_183_chunk.content_id, _hyper_10_183_chunk."timestamp" DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.002 0.536 ↓ 0.0 0 1

Append (cost=0.43..2,182.93 rows=1,926 width=27) (actual time=0.536..0.536 rows=0 loops=1)

5. 0.042 0.042 ↓ 0.0 0 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.042..0.042 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
6. 0.046 0.046 ↓ 0.0 0 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.046..0.046 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
7. 0.032 0.032 ↓ 0.0 0 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.032..0.032 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
8. 0.027 0.027 ↓ 0.0 0 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.027..0.027 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
9. 0.034 0.034 ↓ 0.0 0 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.034..0.034 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
10. 0.031 0.031 ↓ 0.0 0 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.031..0.031 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
11. 0.028 0.028 ↓ 0.0 0 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.028..0.028 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
12. 0.034 0.034 ↓ 0.0 0 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.034..0.034 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
13. 0.032 0.032 ↓ 0.0 0 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.032..0.032 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
14. 0.030 0.030 ↓ 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.030..0.030 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
15. 0.028 0.028 ↓ 0.0 0 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.028..0.028 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
16. 0.030 0.030 ↓ 0.0 0 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.030..0.030 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
17. 0.031 0.031 ↓ 0.0 0 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.031..0.031 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
18. 0.031 0.031 ↓ 0.0 0 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.031..0.031 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
19. 0.032 0.032 ↓ 0.0 0 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.032..0.032 rows=0 loops=1)

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

Index Scan using _hyper_10_227_chunk_archive_login_idx on _hyper_10_227_chunk (cost=0.42..51.73 rows=45 width=27) (actual time=0.046..0.046 rows=0 loops=1)

  • Index Cond: (login_code = 960,966)
Planning time : 4.805 ms
Execution time : 0.859 ms