explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WkSg

Settings
# exclusive inclusive rows x rows loops node
1. 77.553 3,560.185 ↓ 0.0 0 1

Insert on tmp_src_data (cost=193,434.23..201,304.90 rows=35,075 width=24) (actual time=3,560.185..3,560.185 rows=0 loops=1)

2. 108.519 3,482.632 ↓ 2.5 89,186 1

Merge Join (cost=193,434.23..201,304.90 rows=35,075 width=24) (actual time=3,389.916..3,482.632 rows=89,186 loops=1)

  • Merge Cond: ((vdc.type_id = tk.type_id) AND (vdc.nr = tk.nr))
3. 1,217.930 3,367.953 ↑ 2.7 356,742 1

Sort (cost=193,333.59..195,752.54 rows=967,581 width=32) (actual time=3,180.424..3,367.953 rows=356,742 loops=1)

  • Sort Key: vdc.type_id, vdc.nr
  • Sort Method: external merge Disk: 41368kB
4. 856.591 2,150.023 ↑ 1.1 919,890 1

Hash Join (cost=45,553.12..73,984.08 rows=967,581 width=32) (actual time=1,312.703..2,150.023 rows=919,890 loops=1)

  • Hash Cond: (d.device_id = vdc.device_id)
5. 0.892 0.892 ↑ 1.1 3,110 1

Seq Scan on tmp_device_list d (cost=0.00..49.70 rows=3,570 width=4) (actual time=0.062..0.892 rows=3,110 loops=1)

6. 734.863 1,292.540 ↓ 1.0 1,180,313 1

Hash (cost=22,865.94..22,865.94 rows=1,173,294 width=32) (actual time=1,292.540..1,292.540 rows=1,180,313 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2875kB
7. 557.677 557.677 ↓ 1.0 1,180,313 1

Seq Scan on device_data_cache_1 vdc (cost=0.00..22,865.94 rows=1,173,294 width=32) (actual time=0.502..557.677 rows=1,180,313 loops=1)

8. 6.120 6.160 ↑ 1,450.0 1 1

Sort (cost=100.64..104.26 rows=1,450 width=8) (actual time=0.074..6.160 rows=1 loops=1)

  • Sort Key: tk.type_id, tk.nr
  • Sort Method: quicksort Memory: 25kB
9. 0.040 0.040 ↑ 1,450.0 1 1

Seq Scan on tmp_task_row tk (cost=0.00..24.50 rows=1,450 width=8) (actual time=0.039..0.040 rows=1 loops=1)

Planning time : 2.096 ms
Execution time : 3,576.099 ms