explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uUim

Settings
# exclusive inclusive rows x rows loops node
1. 910,217.191 1,335,060.757 ↓ 0.0 0 1

Update on tmp_device (cost=3,463.14..4,773,134.16 rows=381,063,594 width=503) (actual time=1,335,060.757..1,335,060.757 rows=0 loops=1)

2. 305,933.739 424,843.566 ↓ 5.5 2,108,389,920 1

Nested Loop (cost=3,463.14..4,773,134.16 rows=381,063,594 width=503) (actual time=16.510..424,843.566 rows=2,108,389,920 loops=1)

3. 82.547 82.547 ↓ 1.4 79,430 1

Seq Scan on tmp_device (cost=0.00..2,949.41 rows=57,441 width=483) (actual time=0.003..82.547 rows=79,430 loops=1)

4. 118,711.920 118,827.280 ↓ 4.0 26,544 79,430

Materialize (cost=3,463.14..6,906.41 rows=6,634 width=20) (actual time=0.000..1.496 rows=26,544 loops=79,430)

5. 16.270 115.360 ↓ 4.0 26,544 1

Hash Join (cost=3,463.14..6,873.24 rows=6,634 width=20) (actual time=16.504..115.360 rows=26,544 loops=1)

  • Hash Cond: (ds.n26_user_id = d.n26_user_id)
6. 83.130 83.130 ↑ 1.0 78,164 1

Seq Scan on device_3rd_sept_2019 ds (cost=0.00..3,050.64 rows=78,164 width=30) (actual time=0.527..83.130 rows=78,164 loops=1)

7. 4.055 15.960 ↓ 4.0 26,583 1

Hash (cost=3,380.22..3,380.22 rows=6,634 width=22) (actual time=15.960..15.960 rows=26,583 loops=1)

  • Buckets: 32768 (originally 8192) Batches: 1 (originally 1) Memory Usage: 1658kB
8. 11.905 11.905 ↓ 4.0 26,583 1

Seq Scan on tmp_device d (cost=0.00..3,380.22 rows=6,634 width=22) (actual time=0.005..11.905 rows=26,583 loops=1)

  • Filter: ((updated >= '2019-09-03 13:40:00+00'::timestamp with time zone) AND (updated <= '2019-09-03 13:40:59+00'::timestamp with time zone) AND (status = 'PAIRED'::pairing_status))
  • Rows Removed by Filter: 52847