explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5NON

Settings
# exclusive inclusive rows x rows loops node
1. 533.861 712.020 ↓ 134.6 3,364 1

Bitmap Heap Scan on keywords (cost=23,018.41..1,471,319.01 rows=25 width=74) (actual time=219.603..712.020 rows=3,364 loops=1)

  • Recheck Cond: ((profile_id = '2754579007354875'::bigint) AND ((state)::text = 'enabled'::text))
  • Filter: (campaign_id = '41849207491728'::bigint)
  • Rows Removed by Filter: 1299479
  • Heap Blocks: exact=197416
2. 178.159 178.159 ↓ 1.2 1,344,315 1

Bitmap Index Scan on keywords_profile_id_state_index (cost=0.00..23,018.40 rows=1,131,145 width=0) (actual time=178.159..178.159 rows=1,344,315 loops=1)

  • Index Cond: ((profile_id = '2754579007354875'::bigint) AND ((state)::text = 'enabled'::text))
Planning time : 0.694 ms
Execution time : 712.208 ms