explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W8Ru

Settings
# exclusive inclusive rows x rows loops node
1. 361.206 3,785.265 ↓ 19.8 3,901 1

Seq Scan on sm001000_pi7_plan_engagementbase (cost=0.00..944,256.74 rows=197 width=32) (actual time=135.655..3,785.265 rows=3,901 loops=1)

  • Filter: ((sm001000_pi_s_plan_engg = 30) AND (sm001000_pi_n_vers = (SubPlan 1)))
  • Rows Removed by Filter: 35563
2.          

SubPlan (for Seq Scan)

3. 39.357 3,424.059 ↑ 1.0 1 39,357

Aggregate (cost=23.82..23.83 rows=1 width=4) (actual time=0.087..0.087 rows=1 loops=39,357)

4. 3,187.917 3,384.702 ↑ 2.0 1 39,357

Bitmap Heap Scan on sm001000_pi7_plan_engagementbase sm001000_pi7_plan_engagementbase_1 (cost=4.33..23.82 rows=2 width=4) (actual time=0.051..0.086 rows=1 loops=39,357)

  • Recheck Cond: (sm001000_pi7_plan_engagementbase.sm001000_pi2_projet_infrastructureid = sm001000_pi2_projet_infrastructureid)
  • Filter: (sm001000_pi_d_vers < '2015-01-02 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=233946
5. 196.785 196.785 ↓ 1.2 6 39,357

Bitmap Index Scan on ndx_pi7_plan_engagementbase_pi2_projet_infrastructureid (cost=0.00..4.33 rows=5 width=0) (actual time=0.005..0.005 rows=6 loops=39,357)

  • Index Cond: (sm001000_pi7_plan_engagementbase.sm001000_pi2_projet_infrastructureid = sm001000_pi2_projet_infrastructureid)
Planning time : 205.756 ms