explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aZxp

Settings
# exclusive inclusive rows x rows loops node
1. 2,491.658 2,908.228 ↓ 1.0 1,313,561 1

Bitmap Heap Scan on "table" (cost=17,177.64..1,859,780.07 rows=1,297,945 width=17) (actual time=763.831..2,908.228 rows=1,313,561 loops=1)

  • Recheck Cond: (country_id = 'DE'::text)
  • Heap Blocks: exact=942577
2. 416.570 416.570 ↓ 1.0 1,313,561 1

Bitmap Index Scan on "country_id_idx" (cost=0.00..16,853.15 rows=1,297,945 width=0) (actual time=416.570..416.570 rows=1,313,561 loops=1)

  • Index Cond: (country_id = 'DE'::text)