explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wajd

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.044 242.709 ↑ 11.4 57 1

Sort (cost=49,147.41..49,149.03 rows=648 width=54) (actual time=242.707..242.709 rows=57 loops=1)

  • Sort Key: (count(*)) DESC, egauge
  • Sort Method: quicksort Memory: 29kB
2. 4.572 242.665 ↑ 11.4 57 1

HashAggregate (cost=49,089.61..49,117.15 rows=648 width=54) (actual time=242.636..242.665 rows=57 loops=1)

  • Group Key: egauge, egtype1m1s
  • Filter: (count(*) > 4)
  • Rows Removed by Filter: 4
3. 238.093 238.093 ↑ 3.7 6,874 1

Index Scan using urls2_processing_started_successful_idx on urls (cost=0.56..48,769.21 rows=25,632 width=14) (actual time=0.029..238.093 rows=6,874 loops=1)

  • Index Cond: (processing_started IS NULL)
Planning time : 0.218 ms
Execution time : 242.793 ms