explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TfvF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

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

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.25..38,082.70 rows=4,996,399 width=63) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.55..37,305.06 rows=89 width=71) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

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

  • Filter: ((cd_cliente = 113) AND (cd_id_evento = 24,849,062))
5. 0.000 0.000 ↓ 0.0

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

  • 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))
6. 0.000 0.000 ↓ 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) (actual rows= loops=)

  • Index Cond: ((cd_cliente = 113) AND (cd_id_variabilidade_evento = dve.cd_id) AND (cd_id_ddn_mapa = dm.cd_id))