explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W5OT

Settings
# exclusive inclusive rows x rows loops node
1. 15,054.449 66,393.802 ↓ 0.0 0 1

Insert on test_performance_metrics_by_volume_rollup_one_day (cost=727.14..22,670.72 rows=7,302 width=168) (actual time=66,393.802..66,393.802 rows=0 loops=1)

2.          

Initplan (for Insert)

3. 0.279 1.832 ↑ 1.0 2,000 1

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

4. 1.553 1.553 ↑ 1.0 2,000 1

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

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

Foreign Scan on performance_metrics_by_volume_rollup_one_day (cost=402.14..22,345.72 rows=7,302 width=168) (actual time=519.242..51,337.521 rows=1,462,000 loops=1)

Planning time : 1.369 ms
Execution time : 66,394.615 ms