explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eAMR

Settings
# exclusive inclusive rows x rows loops node
1. 2,988.902 3,728.806 ↓ 3.2 1,000,000 1

Bitmap Heap Scan on social_entity_ac (cost=4,194.85..339,967.74 rows=316,155 width=188) (actual time=777.443..3,728.806 rows=1,000,000 loops=1)

  • Recheck Cond: ((id_serial >= 61000000) AND (id_serial < 62000000))
  • Heap Blocks: exact=93505
2. 739.904 739.904 ↓ 3.2 1,000,000 1

Bitmap Index Scan on social_entity_id_serial_ac_idx (cost=0.00..4,115.81 rows=316,155 width=0) (actual time=739.904..739.904 rows=1,000,000 loops=1)

  • Index Cond: ((id_serial >= 61000000) AND (id_serial < 62000000))