explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sWc

Settings
# exclusive inclusive rows x rows loops node
1. 643,490.284 657,912.970 ↓ 0.0 0 1

Update on tmp_phones (cost=0.43..1,081,653.70 rows=3,903,172 width=257) (actual time=657,912.970..657,912.970 rows=0 loops=1)

2. 5,642.155 14,422.686 ↑ 1.0 3,903,172 1

Nested Loop (cost=0.43..1,081,653.70 rows=3,903,172 width=257) (actual time=0.397..14,422.686 rows=3,903,172 loops=1)

3. 8,780.531 8,780.531 ↑ 1.0 1,951,586 1

Seq Scan on tmp_phones (cost=0.00..935,267.86 rows=1,951,586 width=218) (actual time=0.033..8,780.531 rows=1,951,586 loops=1)

4. 0.000 0.000 ↑ 1.0 2 1,951,586

Materialize (cost=0.43..16.90 rows=2 width=17) (actual time=0.000..0.000 rows=2 loops=1,951,586)

5. 0.398 0.398 ↑ 1.0 2 1

Index Scan using ix_tmp_phones_no on tmp_phones t (cost=0.43..16.89 rows=2 width=17) (actual time=0.350..0.398 rows=2 loops=1)

  • Index Cond: (rowid = ANY ('{1331869575,1331869581}'::numeric[]))
Planning time : 0.928 ms
Execution time : 657,917.906 ms