explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jenw : Optimization for: Optimization for: Optimization for: plan #EfpZ; plan #1BwB; plan #X4wT

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 304.410 304.410 ↑ 90.6 100 1

Seq Scan on view_smartdata_faturamentos_materialized (cost=0.00..5,035.60 rows=9,062 width=1,018) (actual time=2.288..304.410 rows=100 loops=1)

  • Filter: (entidade_id = ANY ('{1074090111113686,107409011901539,107409011490170,107409011872188,107409011901678,107409011489327,107409011488820,107409011488804,107409011487946,107409011487536,107409011487524,107409011484165,107409011481353,107409011480680,107409011480676,107409011479550,107409011478814,107409011478071,107409011476987,107409011476983,107409011475563,107409011475559,107409011475149,107409011473645,107409011472342,107409011472338,107409011462938,107409011462894,107409011399488,107409011517987,107409011514770,107409011514732,107409011513898,107409011513062,107409011509552,107409011509548,107409011504868,107409011504860,107409011504675,107409011504595,107409011502275,107409011502237,107409011499797,107409011499498,107409011498668,107409011498664,107409011498457,107409011498371,107409011497998,107409011497994,107409011497990,107409011520613,107409011520094,107409011509724,107409011530914,107409011520851,107409011553276,107409011530717,107409011531138,107409011545521,107409011543946,107409011545453,107409011540386,107409011530329,107409011552170,107409011549751,107409011544039,107409011544512,107409011527613,107409011546105,107409011531225,107409011534480,107409011526483,107409011543905,107409011543929,107409011526668,107409011531678,107409011534484,107409011528846,107409011526487,107409011531674,107409011526744,107409011544792,107409011544788,107409011545427,107409011531591,107409011547866,107409011544094,107409011527609,1074090112833225,1074090112833253,1074090112833149,1074090112828923,1074090112829019,1074090112827457,1074090112829015,1074090112827014,1074090112833001,1074090112827010,1074090112826261}'::numeric[]))
  • Rows Removed by Filter: 58,870
Planning time : 0.242 ms
Execution time : 304.432 ms