explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tNpf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=379,027.99..379,046.91 rows=1 width=42) (actual rows= loops=)

2.          

CTE temp

3. 0.000 0.000 ↓ 0.0

Subquery Scan on __unnamed_subquery_0 (cost=379,022.96..379,025.73 rows=22 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=379,022.96..379,025.51 rows=22 width=16) (actual rows= loops=)

  • Group Key: r.rqs_id
  • Filter: (count(f.fct_id) >= 122)
5. 0.000 0.000 ↓ 0.0

Gather Merge (cost=379,022.96..379,025.20 rows=18 width=16) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=378,022.94..378,023.10 rows=9 width=16) (actual rows= loops=)

  • Group Key: r.rqs_id
7. 0.000 0.000 ↓ 0.0

Sort (cost=378,022.94..378,022.96 rows=9 width=19) (actual rows= loops=)

  • Sort Key: r.rqs_id
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..378,022.80 rows=9 width=19) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dfc_fct_slct f (cost=0.00..180,932.88 rows=24,855 width=19) (actual rows= loops=)

  • Filter: ((fct_id)::text = 'AFWOD_DOL'::text)
10. 0.000 0.000 ↓ 0.0

Index Scan using pk_dfc_dot_data_rqs on dfc_dot_data_rqs r (cost=0.56..7.93 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (rqs_id = f.rqs_id)
  • Filter: (((db_cd)::text = 'RTLMS0PI'::text) AND ((sts_cd)::text = 'STALE'::text) AND (is_dot = 'Y'::bpchar) AND (file_sys = 'Y'::bpchar))
11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.69..19.54 rows=1 width=50) (actual rows= loops=)

  • Join Filter: (drm.rqs_id = temp.rqs_id)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.69..18.82 rows=1 width=59) (actual rows= loops=)

  • Join Filter: (ddr.rqs_id = drm.dot_rqs_id)
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..17.18 rows=1 width=42) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using dfc_dot_data_sts_cd1 on dfc_dot_data_rqs ddr (cost=0.56..8.59 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((hash_cd = '-501708195'::numeric) AND ((db_cd)::text = 'RTLMS0PI'::text))
  • Filter: ((file_sys = 'Y'::bpchar) AND (is_dot = 'N'::bpchar) AND ((sts_cd)::text = 'STALE'::text))
15. 0.000 0.000 ↓ 0.0

Index Scan using pk_dfc_rqs_xml on dfc_rqs_xml drx (cost=0.56..8.58 rows=1 width=26) (actual rows= loops=)

  • Index Cond: (rqs_id = ddr.rqs_id)
16. 0.000 0.000 ↓ 0.0

Index Scan using dfc_rqs_map_idx on dfc_rqs_map drm (cost=0.56..1.63 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (dot_rqs_id = drx.rqs_id)
17. 0.000 0.000 ↓ 0.0

CTE Scan on temp (cost=0.00..0.44 rows=22 width=16) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Index Scan using pk_dfc_rsp_xml on dfc_rsp_xml drsp (cost=0.56..1.65 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (rqs_id = drm.dot_rqs_id)