explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OEQT

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

Limit (cost=4.34..5.36 rows=1 width=494) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on pddb_detection (cost=4.34..5.36 rows=1 width=494) (actual rows= loops=)

  • Recheck Cond: (((created_timestamp >= 1,592,008,300) AND (created_timestamp <= 1,592,008,400)) OR ((updated_timestamp >= 1,592,008,300) AND (updated_timestamp <= 1,592,008,400)) OR ((expire_at IS NOT NULL) AND (expire_at <= 1,592,008,400)))
  • Filter: (datasource >= 0)
3. 0.000 0.000 ↓ 0.0

BitmapOr (cost=4.34..4.34 rows=1 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on detection_created_timestamp_lookup_idx (cost=0.00..1.45 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((created_timestamp >= 1,592,008,300) AND (created_timestamp <= 1,592,008,400))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on detection_updated_timestamp_lookup_idx (cost=0.00..1.45 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((updated_timestamp >= 1,592,008,300) AND (updated_timestamp <= 1,592,008,400))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on detection_expireat_lookup_idx (cost=0.00..1.45 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((expire_at IS NOT NULL) AND (expire_at <= 1,592,008,400))