explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i3EM

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 2,304.895 ↑ 1.0 1 1

Aggregate (cost=759,235.58..759,235.59 rows=1 width=8) (actual time=2,304.895..2,304.895 rows=1 loops=1)

2. 0.829 2,304.886 ↑ 2,201.7 45 1

Bitmap Heap Scan on job_openings (cost=392,066.77..758,987.89 rows=99,078 width=0) (actual time=2,304.190..2,304.886 rows=45 loops=1)

  • Recheck Cond: ((expires_on >= '2019-04-09'::date) AND (country_id = 148))
  • Rows Removed by Index Recheck: 667
  • 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=663
3. 0.350 2,304.057 ↓ 0.0 0 1

BitmapAnd (cost=392,066.77..392,066.77 rows=99,595 width=0) (actual time=2,304.057..2,304.057 rows=0 loops=1)

4. 0.124 0.124 ↑ 339.1 904 1

Bitmap Index Scan on index_job_openings_on_expires_on (cost=0.00..5,663.86 rows=306,573 width=0) (actual time=0.124..0.124 rows=904 loops=1)

  • Index Cond: (expires_on >= '2019-04-09'::date)
5. 2,303.583 2,303.583 ↓ 1.0 20,947,326 1

Bitmap Index Scan on index_job_openings_on_country_id (cost=0.00..386,353.12 rows=20,920,074 width=0) (actual time=2,303.583..2,303.583 rows=20,947,326 loops=1)

  • Index Cond: (country_id = 148)