explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Vop

Settings
# exclusive inclusive rows x rows loops node
1. 22.441 89.516 ↓ 2.0 13,931 1

Sort (cost=34,326.08..34,343.41 rows=6,932 width=72) (actual time=89.045..89.516 rows=13,931 loops=1)

  • Sort Key: ((((((COALESCE((SubPlan 1), '-1'::character varying))::text || '_'::text) || COALESCE((SubPlan 3), '-1'::text)) || '_'::text) || (COALESCE(z_manifesto.name, '-1'::character varying))::text))
  • Sort Method: quicksort Memory: 2151kB
2. 11.349 67.075 ↓ 2.0 13,931 1

Seq Scan on z_manifesto (cost=5.88..33,883.86 rows=6,932 width=72) (actual time=0.042..67.075 rows=13,931 loops=1)

  • Filter: ((ad_client_id = ANY ('{0,1000000}'::numeric[])) AND (ad_org_id = ANY ('{0,5000000}'::numeric[])) AND ((z_manifesto_id IS NULL) OR (NOT (hashed SubPlan 4))))
  • Rows Removed by Filter: 1
3.          

SubPlan (forSeq Scan)

4. 0.002 0.002 ↓ 0.0 0 1

Index Scan using ad_private_access_pkey on ad_private_access (cost=0.15..5.88 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (ad_table_id = '1500428'::numeric)
  • Filter: ((ad_user_id <> '5001092'::numeric) AND (isactive = 'Y'::bpchar))
5. 13.931 13.931 ↓ 0.0 0 13,931

Seq Scan on cof_contract (cost=0.00..1.10 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=13,931)

  • Filter: (z_manifesto.cof_contract_id = cof_contract_id)
  • Rows Removed by Filter: 9
6. 27.955 41.793 ↑ 1.0 1 13,931

Index Scan using cof_equipments_key on cof_equipments (cost=0.27..3.65 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=13,931)

  • Index Cond: (z_manifesto.cof_equipments_id = cof_equipments_id)
7.          

SubPlan (forIndex Scan)

8. 13.838 13.838 ↑ 1.0 1 13,838

Seq Scan on z_classificacaoequipamentos (cost=0.00..1.15 rows=1 width=32) (actual time=0.000..0.001 rows=1 loops=13,838)

  • Filter: (cof_equipments.z_classificacaoequipamentos_id = z_classificacaoequipamentos_id)
  • Rows Removed by Filter: 11