explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KZIT : select t.npoint, t.mid, to_date(t.ndt,'yyyymmdd'), ed.zn1 edm, ed.zn2 aedm, ed.zn3 bedm, ed.zn4 cedm, er.zn1 erm, er.zn2 aerm, er.zn3 berm, er.zn4 cerm, q1.zn1 q1m, q1.zn2 aq1m, q1.zn3 bq1m, q1.zn4 cq1m, q4.zn1 q4m, q4.zn2 aq4m, q4.zn3 bq4m, q4.zn4 cq4m from ( select distinct t.sortnum npoint, vd.idfiders mid, vd.ndt ndt from t_conftree t, vd_autoread vd where t.sortnum= 304258223 and t.typedenom='FIDER' and t.objref=vd.idfiders and ndt between '20191101' and '20191130' and dr between 10201 and 10204 )t, vd_autoread ed, vd_autoread er, vd_autoread q1, vd_autoread q4 where 1=1 and ed.idfiders = t.mid and ed.ndt = t.ndt and ed.dr = 10201 and er.idfiders = t.mid and er.ndt = t.ndt and er.dr = 10202 and q1.idfiders = t.mid and q1.ndt= t.ndt and q1.dr = 10203 and q4.idfiders = t.mid and q4.ndt= t.ndt and q4.dr = 10204 order by t.ndt desc

Settings
# exclusive inclusive rows x rows loops node
1. 0.158 55.012 ↑ 11.4 71 1

Sort (cost=146.63..148.65 rows=808 width=138) (actual time=55.009..55.012 rows=71 loops=1)

  • Sort Key: n.nspname, p.proname, (pg_get_function_arguments(p.oid))
  • Sort Method: quicksort Memory: 43kB
2. 1.378 54.854 ↑ 11.4 71 1

Hash Join (cost=1.14..107.61 rows=808 width=138) (actual time=42.495..54.854 rows=71 loops=1)

  • Hash Cond: (p.pronamespace = n.oid)
3. 53.465 53.465 ↓ 3.0 2,402 1

Seq Scan on pg_proc p (cost=0.00..89.30 rows=808 width=78) (actual time=0.052..53.465 rows=2,402 loops=1)

  • Filter: pg_function_is_visible(oid)
4. 0.004 0.011 ↑ 1.0 4 1

Hash (cost=1.09..1.09 rows=4 width=68) (actual time=0.011..0.011 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
5. 0.007 0.007 ↑ 1.0 4 1

Seq Scan on pg_namespace n (cost=0.00..1.09 rows=4 width=68) (actual time=0.005..0.007 rows=4 loops=1)

  • Filter: ((nspname <> 'pg_catalog'::name) AND (nspname <> 'information_schema'::name))