explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WlKT

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 1,970.800 ↓ 0.0 0 1

Update on portal.device_port_info dpi (cost=2.79..152,679.62 rows=100 width=111) (actual time=1,970.800..1,970.800 rows=0 loops=1)

  • Buffers: shared hit=106 read=75120
2. 510.991 1,970.730 ↑ 25.0 4 1

Hash Join (cost=2.79..152,679.62 rows=100 width=111) (actual time=14.394..1,970.730 rows=4 loops=1)

  • Output: dpi.customer_id, dpi.id, dpi.device_info_id, dpi.port, dpi.server_port, dpi.proto_service_name, dpi.proto_version, dpi.transport, data_table.last_updated_time, dpi.create_time, dpi.soft_delete, dpi.external_ip, data_table.metadata_id, data_table.record_id, dpi.ctid, data_table.*
  • Hash Cond: (dpi.id = data_table.id)
  • Buffers: shared hit=98 read=75120
3. 1,459.721 1,459.721 ↑ 1.0 5,585,954 1

Seq Scan on portal.device_port_info dpi (cost=0.00..131,550.97 rows=5,633,297 width=51) (actual time=0.073..1,459.721 rows=5,585,954 loops=1)

  • Output: dpi.customer_id, dpi.id, dpi.device_info_id, dpi.port, dpi.server_port, dpi.proto_service_name, dpi.proto_version, dpi.transport, dpi.create_time, dpi.soft_delete, dpi.external_ip, dpi.ctid
  • Buffers: shared hit=98 read=75120
4. 0.004 0.018 ↑ 25.0 4 1

Hash (cost=1.54..1.54 rows=100 width=64) (actual time=0.017..0.018 rows=4 loops=1)

  • Output: data_table.last_updated_time, data_table.metadata_id, data_table.record_id, data_table.*, data_table.id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.007 0.014 ↑ 25.0 4 1

Subquery Scan on data_table (cost=0.00..1.54 rows=100 width=64) (actual time=0.010..0.014 rows=4 loops=1)

  • Output: data_table.last_updated_time, data_table.metadata_id, data_table.record_id, data_table.*, data_table.id
6. 0.007 0.007 ↑ 25.0 4 1

ProjectSet (cost=0.00..0.54 rows=100 width=20) (actual time=0.005..0.007 rows=4 loops=1)

  • Output: unnest('{186667,186668,186670,186669}'::integer[]), unnest(ARRAY[now(), now(), now(), now()]), unnest('{32,32,32,32}'::integer[]), unnest('{13,13,10,12}'::integer[])
7. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=1)

Planning time : 0.199 ms
Execution time : 1,970.865 ms