explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UlvD

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

GroupAggregate (cost=676,820.02..1,136,736.86 rows=497,207 width=243) (actual rows= loops=)

  • Group Key: dt_sale, co_client, id_store, tmp_field
2. 0.000 0.000 ↓ 0.0

Sort (cost=676,820.02..689,250.21 rows=4,972,074 width=60) (actual rows= loops=)

  • Sort Key: dt_sale, co_client, id_store, tmp_field
3. 0.000 0.000 ↓ 0.0

Seq Scan on est_f_sup_cli_mon_sto_gse1590213345994_82_extendida (cost=0.00..123,790.74 rows=4,972,074 width=60) (actual rows= loops=)

  • Filter: (tmp_field IS NOT NULL)