explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zwiL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 12.805 ↑ 1.0 1 1

Aggregate (cost=2,005.47..2,005.48 rows=1 width=0) (actual time=12.804..12.805 rows=1 loops=1)

2. 12.800 12.800 ↓ 0.0 0 1

Append (cost=0.00..1,983.88 rows=8,634 width=0) (actual time=12.800..12.800 rows=0 loops=1)

3. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on t_battery_change (cost=0.00..0.00 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)

4. 4.376 4.376 ↓ 0.0 0 1

Index Only Scan using t_battery_change_201905_user_guid_unlock_date_idx on t_battery_change_201905 (cost=0.56..787.71 rows=3,697 width=0) (actual time=4.376..4.376 rows=0 loops=1)

5. 8.362 8.362 ↓ 0.0 0 1

Index Only Scan using t_battery_change_201906_user_guid_unlock_date_idx on t_battery_change_201906 (cost=0.56..938.85 rows=4,013 width=0) (actual time=8.362..8.362 rows=0 loops=1)

6. 0.058 0.058 ↓ 0.0 0 1

Index Only Scan using t_battery_change_201907_user_guid_unlock_date_idx on t_battery_change_201907 (cost=0.56..257.32 rows=923 width=0) (actual time=0.058..0.058 rows=0 loops=1)

Planning time : 34.713 ms
Execution time : 12.939 ms