explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s6Oy

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 3,327.869 ↑ 1.0 100 1

Limit (cost=73,430.47..73,448.57 rows=100 width=75) (actual time=3,231.998..3,327.869 rows=100 loops=1)

2. 95.334 3,327.854 ↑ 505.5 100 1

GroupAggregate (cost=73,430.47..82,577.38 rows=50,546 width=75) (actual time=3,231.996..3,327.854 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. 2,393.186 3,232.520 ↑ 143.3 2,601 1

Sort (cost=73,430.47..74,362.55 rows=372,832 width=73) (actual time=3,231.788..3,232.520 rows=2,601 loops=1)

  • Sort Key: init_point_id, point_from_id, point_to_id, tariff_type
  • Sort Method: external merge Disk: 36016kB
4. 839.334 839.334 ↓ 1.0 386,829 1

Seq Scan on organization_rate_directions rt (cost=0.00..22,359.29 rows=372,832 width=73) (actual time=23.771..839.334 rows=386,829 loops=1)

  • Filter: ((NOT is_deleted) AND (organization_id = 121))
  • Rows Removed by Filter: 118634
Planning time : 0.195 ms
Execution time : 3,335.748 ms