explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lRPo

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

Limit (cost=0.00..5,180.62 rows=500 width=1,116) (actual time=530.932..530.932 rows=0 loops=1)

2. 530.932 530.932 ↓ 0.0 0 1

Seq Scan on content (cost=0.00..69,036.94 rows=6,663 width=1,116) (actual time=530.931..530.932 rows=0 loops=1)

  • Filter: ((in_draft_bin IS NOT TRUE) AND (schedule <= 1567703716) AND (status = 'future'::text))
  • Rows Removed by Filter: 1438787
Planning time : 0.816 ms
Execution time : 530.959 ms