explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YxWH

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 2.057 ↓ 1.5 9 1

Sort (cost=69,608.93..69,608.94 rows=6 width=21) (actual time=2.057..2.057 rows=9 loops=1)

  • Sort Key: c.nume
  • Sort Method: quicksort Memory: 25kB
2. 0.243 2.043 ↓ 1.5 9 1

Seq Scan on companie c (cost=0.00..69,608.85 rows=6 width=21) (actual time=0.397..2.043 rows=9 loops=1)

  • Filter: ((creat_de_companie = 2390) AND ((SubPlan 1) > 0))
  • Rows Removed by Filter: 2368
3.          

SubPlan (for Seq Scan)

4. 0.090 1.800 ↑ 1.0 1 18

Aggregate (cost=29.24..29.25 rows=1 width=8) (actual time=0.100..0.100 rows=1 loops=18)

5. 1.710 1.710 ↑ 1.0 1 18

Seq Scan on contract ctr (cost=0.00..29.24 rows=1 width=0) (actual time=0.079..0.095 rows=1 loops=18)

  • Filter: ((data_incepere < '2020-01-01 00:00:00'::timestamp without time zone) AND ((data_reziliere IS NULL) OR (data_reziliere > '2019-01-01 00:00:00'::timestamp without time zone)) AND (id_beneficiar = c.id) AND (id_prestator = 2390))
  • Rows Removed by Filter: 861
Planning time : 0.108 ms
Execution time : 2.080 ms