explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3GL7

Settings
# exclusive inclusive rows x rows loops node
1. 87.585 644.879 ↓ 0.0 0 1

Insert on test_performance_metrics_by_volume (cost=122.78..41,929.75 rows=1,256,122 width=120) (actual time=644.879..644.879 rows=0 loops=1)

2. 12.893 557.294 ↑ 139.6 9,000 1

Nested Loop (cost=122.78..41,929.75 rows=1,256,122 width=120) (actual time=11.116..557.294 rows=9,000 loops=1)

3. 0.106 0.751 ↑ 1.0 50 1

HashAggregate (cost=8.75..9.25 rows=50 width=37) (actual time=0.673..0.751 rows=50 loops=1)

  • Group Key: internal_volume.id
4. 0.009 0.645 ↑ 1.0 50 1

Limit (cost=0.00..8.12 rows=50 width=37) (actual time=0.582..0.645 rows=50 loops=1)

5. 0.636 0.636 ↑ 40.0 50 1

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

  • Filter: (appliance_id = 'A2'::text)
  • Rows Removed by Filter: 1,974
6. 543.650 543.650 ↑ 1.1 180 50

Foreign Scan on performance_metrics_by_volume (cost=114.03..836.52 rows=189 width=96) (actual time=10.851..10.873 rows=180 loops=50)

Planning time : 11.420 ms
Execution time : 645.253 ms