explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bceT

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 5.591 ↑ 1.0 1 1

Limit (cost=0.58..1.10 rows=1 width=8) (actual time=5.589..5.591 rows=1 loops=1)

2. 5.588 5.588 ↑ 229,789.0 1 1

Index Scan using detection_updated_timestamp_lookup_idx on pddb_detection (cost=0.58..119,033.89 rows=229,789 width=8) (actual time=5.588..5.588 rows=1 loops=1)

  • Index Cond: ((updated_timestamp >= 1,592,007,000) AND (updated_timestamp <= 1,592,008,400))
  • Filter: (datasource >= 0)
Planning time : 0.124 ms
Execution time : 5.615 ms