explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4NxJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.917 6,048.907 ↓ 31.0 31 1

Nested Loop (cost=65.11..146.24 rows=1 width=157) (actual time=6,047.194..6,048.907 rows=31 loops=1)

  • Join Filter: (geo_area.id = ANY (gettrazo_zonas_id.zonas_id))
  • Rows Removed by Join Filter: 1493
  • Planning time: 0.386 ms
  • Execution time: 6049.879 ms
2. 0.253 6,047.228 ↓ 1.3 254 1

Sort (cost=64.82..65.32 rows=200 width=140) (actual time=6,047.129..6,047.228 rows=254 loops=1)

  • Sort Key: gettrazo_zonas_id.trama
  • Sort Method: quicksort Memory: 60kB
3.          

Initplan (forSort)

4. 0.003 0.017 ↑ 1.0 1 1

Limit (cost=0.41..8.43 rows=1 width=12) (actual time=0.015..0.017 rows=1 loops=1)

5. 0.014 0.014 ↑ 1.0 1 1

Index Scan using fki_cliente_avl_equipo_imei on cliente_avl_equipo (cost=0.41..8.43 rows=1 width=12) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (imei_equipo = '358539070632265'::bigint)
6. 39.427 6,046.958 ↓ 1.3 254 1

HashAggregate (cost=40.25..48.75 rows=200 width=140) (actual time=6,046.231..6,046.958 rows=254 loops=1)

  • Group Key: gettrazo_zonas_id.trama, gettrazo_zonas_id.zonas_id
  • Filter: ((date_part('epoch'::text, max(gettrazo_zonas_id.fecha)) - date_part('epoch'::text, min(gettrazo_zonas_id.fecha))) >= '0'::double precision)
7. 6,007.531 6,007.531 ↓ 45.1 45,137 1

Function Scan on gettrazo_zonas_id (cost=0.25..10.25 rows=1,000 width=52) (actual time=5,989.735..6,007.531 rows=45,137 loops=1)

8. 0.726 0.762 ↑ 1.0 6 254

Materialize (cost=0.29..48.88 rows=6 width=25) (actual time=0.000..0.003 rows=6 loops=254)

9. 0.036 0.036 ↑ 1.0 6 1

Index Scan using geo_area_id on geo_area (cost=0.29..48.85 rows=6 width=25) (actual time=0.020..0.036 rows=6 loops=1)

  • Index Cond: (id = ANY ('{42210,57309,57308,57322,57318,57312}'::integer[]))