explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AwF1

Settings
# exclusive inclusive rows x rows loops node
1. 16,545.634 210,161.621 ↓ 0.0 0 1

Insert on test_performance_metrics_by_volume_rollup_one_day (cost=425.01..160,574.59 rows=7,302 width=168) (actual time=210,161.621..210,161.621 rows=0 loops=1)

2.          

Initplan (for Insert)

3. 0.275 2.426 ↑ 1.0 2,000 1

Limit (cost=0.00..325.00 rows=2,000 width=37) (actual time=0.834..2.426 rows=2,000 loops=1)

4. 2.151 2.151 ↑ 1.0 2,000 1

Seq Scan on internal_volume (cost=0.00..325.00 rows=2,000 width=37) (actual time=0.833..2.151 rows=2,000 loops=1)

  • Filter: (appliance_id = 'A2'::text)
  • Rows Removed by Filter: 2,436
5. 193,613.561 193,613.561 ↓ 200.2 1,462,000 1

Foreign Scan on performance_metrics_by_volume_rollup_one_day (cost=100.01..160,249.59 rows=7,302 width=168) (actual time=870.801..193,613.561 rows=1,462,000 loops=1)

Planning time : 1.494 ms
Execution time : 210,162.243 ms