explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0o8

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 2,496.974 ↑ 1.0 1 1

Aggregate (cost=758,260.61..758,260.62 rows=1 width=8) (actual time=2,496.974..2,496.974 rows=1 loops=1)

2. 0.678 2,496.964 ↑ 2,102.2 47 1

Bitmap Heap Scan on job_openings (cost=392,057.24..758,013.60 rows=98,804 width=0) (actual time=2,496.403..2,496.964 rows=47 loops=1)

  • Recheck Cond: ((expires_on >= '2019-04-15'::date) AND (country_id = 148))
  • Rows Removed by Index Recheck: 597
  • Filter: ((deleted_at IS NULL) AND (((creation_reason)::text <> 'send_offers'::text) OR (creation_reason IS NULL)) AND ((status)::text = 'published'::text))
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=600
3. 0.367 2,496.286 ↓ 0.0 0 1

BitmapAnd (cost=392,057.24..392,057.24 rows=99,320 width=0) (actual time=2,496.286..2,496.286 rows=0 loops=1)

4. 0.096 0.096 ↑ 337.1 907 1

Bitmap Index Scan on index_job_openings_on_expires_on (cost=0.00..5,649.50 rows=305,725 width=0) (actual time=0.096..0.096 rows=907 loops=1)

  • Index Cond: (expires_on >= '2019-04-15'::date)
5. 2,495.823 2,495.823 ↓ 1.0 20,947,336 1

Bitmap Index Scan on index_job_openings_on_country_id (cost=0.00..386,358.09 rows=20,920,203 width=0) (actual time=2,495.823..2,495.823 rows=20,947,336 loops=1)

  • Index Cond: (country_id = 148)
Planning time : 0.158 ms
Execution time : 2,497.009 ms