explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aY67

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

Delete on contextops_hypertable (cost=0.00..7,564.25 rows=7,062 width=6) (actual rows= loops=)

  • Delete on contextops_hypertable
  • Delete on _hyper_3_220_chunk
  • Delete on _hyper_3_221_chunk
  • Delete on _hyper_3_222_chunk
  • Delete on _hyper_3_223_chunk
  • Delete on _hyper_3_224_chunk
  • Delete on _hyper_3_225_chunk
  • Delete on _hyper_3_226_chunk
2. 0.000 0.000 ↓ 0.0

Seq Scan on contextops_hypertable (cost=0.00..0.00 rows=1 width=6) (actual rows= loops=)

  • Filter: (agent_uri = 'yrieix.leprince/aspic/steve_smith_autoprot'::text)
3. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_3_220_chunk_agent_uri_time_idx on _hyper_3_220_chunk (cost=0.42..2.64 rows=1 width=6) (actual rows= loops=)

  • Index Cond: (agent_uri = 'yrieix.leprince/aspic/steve_smith_autoprot'::text)
4. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_3_221_chunk_agent_uri_time_idx on _hyper_3_221_chunk (cost=0.56..7,223.33 rows=6,759 width=6) (actual rows= loops=)

  • Index Cond: (agent_uri = 'yrieix.leprince/aspic/steve_smith_autoprot'::text)
5. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_3_222_chunk_agent_uri_time_idx on _hyper_3_222_chunk (cost=0.42..325.05 rows=294 width=6) (actual rows= loops=)

  • Index Cond: (agent_uri = 'yrieix.leprince/aspic/steve_smith_autoprot'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_3_223_chunk_agent_uri_time_idx on _hyper_3_223_chunk (cost=0.42..2.48 rows=1 width=6) (actual rows= loops=)

  • Index Cond: (agent_uri = 'yrieix.leprince/aspic/steve_smith_autoprot'::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_3_224_chunk_agent_uri_time_idx on _hyper_3_224_chunk (cost=0.42..2.64 rows=1 width=6) (actual rows= loops=)

  • Index Cond: (agent_uri = 'yrieix.leprince/aspic/steve_smith_autoprot'::text)
8. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_3_225_chunk_agent_uri_time_idx on _hyper_3_225_chunk (cost=0.42..2.64 rows=1 width=6) (actual rows= loops=)

  • Index Cond: (agent_uri = 'yrieix.leprince/aspic/steve_smith_autoprot'::text)
9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on _hyper_3_226_chunk (cost=1.28..5.48 rows=4 width=6) (actual rows= loops=)

  • Recheck Cond: (agent_uri = 'yrieix.leprince/aspic/steve_smith_autoprot'::text)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on _hyper_3_226_chunk_contextops_hypertable_agent_uri_time_idx (cost=0.00..1.28 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (agent_uri = 'yrieix.leprince/aspic/steve_smith_autoprot'::text)