explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EP7

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 140.873 ↑ 1.0 1 1

Aggregate (cost=30,551.12..30,551.13 rows=1 width=8) (actual time=140.872..140.873 rows=1 loops=1)

2. 1.250 140.841 ↑ 8.7 361 1

Bitmap Heap Scan on job_openings (cost=17,982.71..30,543.23 rows=3,153 width=0) (actual time=139.670..140.841 rows=361 loops=1)

  • Recheck Cond: ((expires_on >= '2019-04-15'::date) AND (country_id = 56))
  • Rows Removed by Index Recheck: 131
  • 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: 254
  • Heap Blocks: exact=599
3. 0.088 139.591 ↓ 0.0 0 1

BitmapAnd (cost=17,982.71..17,982.71 rows=3,169 width=0) (actual time=139.591..139.591 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. 139.407 139.407 ↓ 1.1 737,671 1

Bitmap Index Scan on index_job_openings_on_country_id (cost=0.00..12,331.38 rows=667,575 width=0) (actual time=139.407..139.407 rows=737,671 loops=1)

  • Index Cond: (country_id = 56)