explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fSi5

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 4,072.410 ↑ 1.0 100 1

Limit (cost=88,927.81..88,951.05 rows=100 width=75) (actual time=4,060.392..4,072.410 rows=100 loops=1)

2. 11.382 4,072.389 ↑ 505.5 100 1

GroupAggregate (cost=88,927.81..100,672.24 rows=50,546 width=75) (actual time=4,060.390..4,072.389 rows=100 loops=1)

  • Group Key: init_point_id, point_from_id, point_to_id, tariff_type, organization_id
  • Filter: (array_agg(transport_type_id) && '{1}'::bigint[])
3. 3,197.458 4,061.007 ↑ 341.9 1,428 1

Sort (cost=88,927.81..90,148.51 rows=488,277 width=73) (actual time=4,060.107..4,061.007 rows=1,428 loops=1)

  • Sort Key: init_point_id, point_from_id, point_to_id, tariff_type, organization_id
  • Sort Method: external merge Disk: 45472kB
4. 863.549 863.549 ↓ 1.0 488,419 1

Seq Scan on organization_rate_directions rt (cost=0.00..21,095.63 rows=488,277 width=73) (actual time=19.776..863.549 rows=488,419 loops=1)

  • Filter: (NOT is_deleted)
  • Rows Removed by Filter: 17044
Planning time : 0.224 ms
Execution time : 4,168.665 ms