explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P8Ia

Settings
# exclusive inclusive rows x rows loops node
1. 211.753 1,883.019 ↑ 2.0 2 1

GroupAggregate (cost=0.11..8,956.97 rows=4 width=24) (actual time=1,866.765..1,883.019 rows=2 loops=1)

  • Group Key: status
2. 1,671.266 1,671.266 ↓ 27.8 238,355 1

Index Scan using imported_data_rows_dataid_status_idx on imported_data_rows (cost=0.11..8,944.09 rows=8,579 width=12) (actual time=0.115..1,671.266 rows=238,355 loops=1)

  • Index Cond: (imported_data_id = 9,632)
Planning time : 0.167 ms
Execution time : 1,883.082 ms