explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6j5X

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.046 ↑ 1.0 1 1

Limit (cost=0.43..20.74 rows=1 width=338) (actual time=0.045..0.046 rows=1 loops=1)

2. 0.045 0.045 ↑ 47,097.0 1 1

Index Scan Backward using repository_fork_count_idx on repository (cost=0.43..956,402.31 rows=47,097 width=338) (actual time=0.045..0.045 rows=1 loops=1)

  • Filter: (((grabbed_for_processing_until < '2020-07-02 18:26:54.824443+00'::timestamp with time zone) OR (grabbed_for_processing_until IS NULL)) AND ((scrape_status -> 'contributors'::text) IS NULL))
  • Rows Removed by Filter: 28
Planning time : 0.146 ms
Execution time : 0.066 ms