explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4zy1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.44..2.84 rows=2 width=13) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Custom Scan (ChunkAppend) on history_uint (cost=0.44..349.44 rows=290 width=13) (actual rows= loops=)

  • Order: history_uint.clock DESC
3. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_2_1657_chunk_history_uint_clock_idx on _hyper_2_1657_chunk (cost=0.44..22.34 rows=1 width=13) (actual rows= loops=)

  • Index Cond: ((clock <= 1,600,041,602) AND (clock > 1599436802))
  • Filter: (itemid = 258,012)
4. 0.000 0.000 ↓ 0.0

Index Scan Backward using _hyper_2_1647_chunk_history_uint_1 on _hyper_2_1647_chunk (cost=0.56..327.10 rows=289 width=13) (actual rows= loops=)

  • Index Cond: ((itemid = 258,012) AND (clock <= 1,600,041,602) AND (clock > 1599436802))
5. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_2_1635_chunk_history_uint_clock_idx on _hyper_2_1635_chunk (cost=0.44..590,828.95 rows=267 width=13) (actual rows= loops=)

  • Index Cond: ((clock <= 1,600,041,602) AND (clock > 1599436802))
  • Filter: (itemid = 258,012)
6. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_2_1625_chunk_history_uint_clock_idx on _hyper_2_1625_chunk (cost=0.44..589,962.51 rows=264 width=13) (actual rows= loops=)

  • Index Cond: ((clock <= 1,600,041,602) AND (clock > 1599436802))
  • Filter: (itemid = 258,012)
7. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_2_1615_chunk_history_uint_clock_idx on _hyper_2_1615_chunk (cost=0.44..598,870.94 rows=270 width=13) (actual rows= loops=)

  • Index Cond: ((clock <= 1,600,041,602) AND (clock > 1599436802))
  • Filter: (itemid = 258,012)
8. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_2_1605_chunk_history_uint_clock_idx on _hyper_2_1605_chunk (cost=0.44..602,087.33 rows=272 width=13) (actual rows= loops=)

  • Index Cond: ((clock <= 1,600,041,602) AND (clock > 1599436802))
  • Filter: (itemid = 258,012)
9. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_2_1595_chunk_history_uint_clock_idx on _hyper_2_1595_chunk (cost=0.44..601,580.72 rows=273 width=13) (actual rows= loops=)

  • Index Cond: ((clock <= 1,600,041,602) AND (clock > 1599436802))
  • Filter: (itemid = 258,012)
10. 0.000 0.000 ↓ 0.0

Index Scan Backward using _hyper_2_1585_chunk_history_uint_1 on _hyper_2_1585_chunk (cost=0.56..324.75 rows=287 width=13) (actual rows= loops=)

  • Index Cond: ((itemid = 258,012) AND (clock <= 1,600,041,602) AND (clock > 1599436802))