explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I6o3

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 211.933 ↑ 1.0 15 1

Limit (cost=267.69..61,119.69 rows=15 width=1,683) (actual time=16.903..211.933 rows=15 loops=1)

2. 0.060 211.924 ↑ 71.9 15 1

Result (cost=267.69..4,373,498.09 rows=1,078 width=1,683) (actual time=16.902..211.924 rows=15 loops=1)

3. 0.347 1.099 ↑ 71.9 15 1

Sort (cost=267.69..270.39 rows=1,078 width=1,675) (actual time=1.091..1.099 rows=15 loops=1)

  • Sort Key: pv_catalogo_item.ins_dthr DESC
  • Sort Method: top-N heapsort Memory: 81kB
4. 0.752 0.752 ↑ 1.0 1,065 1

Seq Scan on pv_catalogo_item (cost=0.00..241.25 rows=1,078 width=1,675) (actual time=0.006..0.752 rows=1,065 loops=1)

  • Filter: ((dthr_fim < '2020-02-10 09:00:29.303'::timestamp without time zone) AND (ativo = 1))
  • Rows Removed by Filter: 7
5.          

SubPlan (for Result)

6. 0.135 210.765 ↑ 1.0 1 15

Aggregate (cost=4,056.78..4,056.79 rows=1 width=8) (actual time=14.051..14.051 rows=1 loops=15)

7. 210.630 210.630 ↑ 1.2 90 15

Seq Scan on pv_catalogo_resgate (cost=0.00..4,056.51 rows=106 width=0) (actual time=13.933..14.042 rows=90 loops=15)

  • Filter: ((pv_catalogo_item.iditem)::text = (iditem)::text)
  • Rows Removed by Filter: 94684