explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ETin

Settings
# exclusive inclusive rows x rows loops node
1. 0.828 719.629 ↑ 1.0 3 1

Subquery Scan on q (cost=4,587.47..4,598.77 rows=3 width=72) (actual time=718.986..719.629 rows=3 loops=1)

2. 0.006 718.801 ↑ 1.0 3 1

Limit (cost=4,587.47..4,587.48 rows=3 width=44) (actual time=718.797..718.801 rows=3 loops=1)

3. 0.067 718.795 ↑ 66.7 3 1

Sort (cost=4,587.47..4,587.97 rows=200 width=44) (actual time=718.795..718.795 rows=3 loops=1)

  • Sort Key: (count(q_1.cluster_id)) DESC
  • Sort Method: top-N heapsort Memory: 47kB
4. 120.076 718.728 ↑ 6.7 30 1

HashAggregate (cost=4,582.39..4,584.89 rows=200 width=44) (actual time=600.847..718.728 rows=30 loops=1)

  • Group Key: q_1.cluster_id
5. 0.175 598.652 ↑ 1.6 607 1

Subquery Scan on q_1 (cost=4,026.65..4,574.92 rows=995 width=36) (actual time=597.896..598.652 rows=607 loops=1)

  • Filter: (q_1.cluster_id IS NOT NULL)
  • Rows Removed by Filter: 29
6. 131.042 598.477 ↑ 1.6 636 1

WindowAgg (cost=4,026.65..4,564.92 rows=1,000 width=36) (actual time=597.894..598.477 rows=636 loops=1)

7. 0.134 467.435 ↑ 1.6 636 1

Subquery Scan on q_2 (cost=4,026.65..4,552.42 rows=1,000 width=64) (actual time=455.963..467.435 rows=636 loops=1)

8. 0.229 467.301 ↑ 1.6 636 1

Result (cost=4,026.65..4,542.42 rows=1,000 width=64) (actual time=455.962..467.301 rows=636 loops=1)

9. 11.746 467.072 ↑ 1.6 636 1

ProjectSet (cost=4,026.65..4,032.42 rows=1,000 width=64) (actual time=455.958..467.072 rows=636 loops=1)

10. 453.139 455.326 ↑ 1.0 1 1

Aggregate (cost=4,026.65..4,026.91 rows=1 width=64) (actual time=455.325..455.326 rows=1 loops=1)

11. 2.187 2.187 ↑ 3.1 636 1

Index Scan using history_place_stops_history_place_id_idx on history_place_stops hps (cost=0.42..4,007.07 rows=1,957 width=1,664) (actual time=0.023..2.187 rows=636 loops=1)

  • Index Cond: (history_place_id = 172,026)
  • Filter: (ellipse_95 IS NOT NULL)
  • Rows Removed by Filter: 2,687
Planning time : 0.223 ms
Execution time : 719.740 ms