explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NQER

Settings
# exclusive inclusive rows x rows loops node
1. 50,059.430 50,306.145 ↑ 10.0 1 1

GroupAggregate (cost=263.72..264.97 rows=10 width=56) (actual time=50,306.145..50,306.145 rows=1 loops=1)

  • Group Key: geoilceler_20200911.objectid, geoilceler_20200911.ilce_alan
2. 0.259 246.715 ↓ 5.8 58 1

Sort (cost=263.72..263.75 rows=10 width=21,411) (actual time=246.673..246.715 rows=58 loops=1)

  • Sort Key: geoilceler_20200911.objectid, geoilceler_20200911.ilce_alan
  • Sort Method: quicksort Memory: 126kB
3. 0.291 246.456 ↓ 5.8 58 1

Hash Join (cost=11.46..263.56 rows=10 width=21,411) (actual time=14.655..246.456 rows=58 loops=1)

  • Hash Cond: (geoplan_sinir_1000_20200910.ilce_id = geoilceler_20200911.objectid)
4. 246.139 246.139 ↓ 2.9 58 1

Seq Scan on geoplan_sinir_1000_20200910 (cost=0.00..251.92 rows=20 width=21,399) (actual time=14.595..246.139 rows=58 loops=1)

  • Filter: (geo_durum AND st_isvalid(poly))
  • Rows Removed by Filter: 34
5. 0.006 0.026 ↑ 4.1 11 1

Hash (cost=10.90..10.90 rows=45 width=16) (actual time=0.026..0.026 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.020 0.020 ↑ 4.1 11 1

Seq Scan on geoilceler_20200911 (cost=0.00..10.90 rows=45 width=16) (actual time=0.014..0.020 rows=11 loops=1)

  • Filter: geo_durum
Planning time : 0.297 ms
Execution time : 50,306.297 ms