explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DbLx

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.013 ↓ 0.0 0 1

Limit (cost=0.06..4.06 rows=1 width=704) (actual time=0.013..0.013 rows=0 loops=1)

2. 0.012 0.012 ↓ 0.0 0 1

Index Scan using content_index_status_in_draft_bin on content (cost=0.06..4.06 rows=1 width=704) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (status = 'future'::text)
  • Filter: ((in_draft_bin IS NOT TRUE) AND (schedule <= 1567703716))
Planning time : 0.153 ms
Execution time : 0.047 ms