explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wTCp

Settings
# exclusive inclusive rows x rows loops node
1. 129.536 4,116.228 ↓ 0.0 0 1

Insert on test_performance_metrics_by_volume_rollup_one_day (cost=104.07..160,253.65 rows=7,302 width=168) (actual time=4,116.228..4,116.228 rows=0 loops=1)

2.          

Initplan (for Insert)

3. 0.006 0.895 ↑ 1.0 25 1

Limit (cost=0.00..4.06 rows=25 width=37) (actual time=0.845..0.895 rows=25 loops=1)

4. 0.889 0.889 ↑ 80.0 25 1

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

  • Filter: (appliance_id = 'A2'::text)
  • Rows Removed by Filter: 1,943
5. 3,985.797 3,985.797 ↓ 2.5 18,275 1

Foreign Scan on performance_metrics_by_volume_rollup_one_day (cost=100.01..160,249.59 rows=7,302 width=168) (actual time=3,197.124..3,985.797 rows=18,275 loops=1)

Planning time : 1.544 ms
Execution time : 4,118.421 ms