explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8QLE

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 19,523.922 ↑ 1.0 1 1

Aggregate (cost=100,540.18..100,540.19 rows=1 width=32) (actual time=19,523.921..19,523.922 rows=1 loops=1)

2. 0.000 19,523.916 ↓ 0.0 0 1

Nested Loop (cost=1.25..38,082.70 rows=4,996,399 width=63) (actual time=19,523.916..19,523.916 rows=0 loops=1)

3. 0.004 19,523.916 ↓ 0.0 0 1

Nested Loop (cost=0.55..37,305.06 rows=89 width=71) (actual time=19,523.915..19,523.916 rows=0 loops=1)

4. 4.009 4.009 ↑ 1.0 1 1

Seq Scan on ddn_variabilidade_evento113 dve (cost=0.00..306.49 rows=1 width=12) (actual time=4.006..4.009 rows=1 loops=1)

  • Filter: ((cd_cliente = 113) AND (cd_id_evento = 24,849,062))
  • Rows Removed by Filter: 11,860
5. 19,519.903 19,519.903 ↓ 0.0 0 1

Index Scan using ddn_mapa_cliente113_linha_idx on ddn_mapa_cliente113 dm (cost=0.55..36,997.68 rows=89 width=59) (actual time=19,519.903..19,519.903 rows=0 loops=1)

  • Index Cond: ((linha && '0103000020E610000001000000050000000761F1FF9F7448C0E82D1BCCA11535C00761F1FF9F7448C01EE4E89C202035C06664F1FFFF6E48C01EE4E89C202035C06664F1FFFF6E48C0E82D1BCCA11535C00761F1FF9F7448C0E82D1BCCA11535C0'::geometry) AND (linha && '0103000020E610000001000000050000000761F1FF9F7448C0E82D1BCCA11535C00761F1FF9F7448C01EE4E89C202035C06664F1FFFF6E48C01EE4E89C202035C06664F1FFFF6E48C0E82D1BCCA11535C00761F1FF9F7448C0E82D1BCCA11535C0'::geometry))
  • Filter: ((dt_hr_local_inicial >= '2020-06-19 00:00:00'::timestamp without time zone) AND (dt_hr_local_inicial <= '2020-06-24 23:59:59'::timestamp without time zone) AND (st_asmvtgeom(linha, 'BOX(-48.9111328056916 -21.1254976337988,-48.8671874931977 -21.0845000807148)'::box2d, 4096, 256, true) IS NOT NULL) AND (cd_cliente = 113) AND st_intersects(linha, '0103000020E610000001000000050000000761F1FF9F7448C0E82D1BCCA11535C00761F1FF9F7448C01EE4E89C202035C06664F1FFFF6E48C01EE4E89C202035C06664F1FFFF6E48C0E82D1BCCA11535C00761F1FF9F7448C0E82D1BCCA11535C0'::geometry))
  • Rows Removed by Filter: 394,164
6. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ddn_variabilidade_evento_kij_cd_cliente_cd_id_variabilida_key52 on ddn_variabilidade_evento_kijo113 dvek (cost=0.70..8.73 rows=1 width=28) (never executed)

  • Index Cond: ((cd_cliente = 113) AND (cd_id_variabilidade_evento = dve.cd_id) AND (cd_id_ddn_mapa = dm.cd_id))
  • Heap Fetches: 0
Planning time : 1.974 ms
Execution time : 19,523.987 ms