explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TqGb

Settings
# exclusive inclusive rows x rows loops node
1. 59.707 842.078 ↑ 1.0 1,000,000 1

Append (cost=0.00..106,398.00 rows=1,000,000 width=874) (actual time=0.006..842.078 rows=1,000,000 loops=1)

2. 782.371 782.371 ↑ 1.0 1,000,000 1

Seq Scan on tmp_social_entity_ac_60 (cost=0.00..106,398.00 rows=1,000,000 width=874) (actual time=0.006..782.371 rows=1,000,000 loops=1)

  • Filter: ((id_serial >= 60000000) AND (id_serial < 61000000))
Planning time : 318.531 ms
Execution time : 876.851 ms