explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jFa3

Settings
# exclusive inclusive rows x rows loops node
1. 80.752 2,218.952 ↓ 200.0 1,000,000 1

Append (cost=67.08..5,386.35 rows=5,000 width=188) (actual time=227.876..2,218.952 rows=1,000,000 loops=1)

2. 1,931.807 2,138.200 ↓ 200.0 1,000,000 1

Bitmap Heap Scan on tmp_social_entity_ac_61 (cost=67.08..5,386.35 rows=5,000 width=188) (actual time=227.875..2,138.200 rows=1,000,000 loops=1)

  • Recheck Cond: ((id_serial >= 61000000) AND (id_serial < 62000000))
  • Heap Blocks: exact=92634
3. 206.393 206.393 ↓ 200.0 1,000,000 1

Bitmap Index Scan on tmp_social_entity_ac_61_id_serial_idx (cost=0.00..65.83 rows=5,000 width=0) (actual time=206.392..206.393 rows=1,000,000 loops=1)

  • Index Cond: ((id_serial >= 61000000) AND (id_serial < 62000000))
Planning time : 382.081 ms
Execution time : 2,265.597 ms