explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fk4R

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

CTE Scan on cte_dual (cost=67.80..67.82 rows=1 width=110) (actual time=0.024..0.024 rows=0 loops=1)

2.          

CTE cte_dual

3. 0.000 0.023 ↓ 0.0 0 1

Nested Loop Anti Join (cost=4.75..67.80 rows=1 width=88) (actual time=0.023..0.023 rows=0 loops=1)

4. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=4.48..59.51 rows=1 width=28) (actual time=0.023..0.023 rows=0 loops=1)

5. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=4.19..51.20 rows=1 width=38) (actual time=0.023..0.023 rows=0 loops=1)

6. 0.004 0.023 ↓ 0.0 0 1

Hash Join (cost=3.92..7.56 rows=1 width=10) (actual time=0.023..0.023 rows=0 loops=1)

  • Hash Cond: (d_8.client_id = d_9.client_id)
7. 0.006 0.006 ↑ 17.0 1 1

Seq Scan on da_settings d_8 (cost=0.00..3.59 rows=17 width=5) (actual time=0.006..0.006 rows=1 loops=1)

  • Filter: ((property_name)::text = 'REPORT_BUILDER_QUERY_CLUSTER_ID'::text)
  • Rows Removed by Filter: 8
8. 0.001 0.013 ↓ 0.0 0 1

Hash (cost=3.91..3.91 rows=1 width=5) (actual time=0.012..0.013 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
9. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on da_settings d_9 (cost=0.00..3.91 rows=1 width=5) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (((property_name)::text = 'DDR_QUERY_PROCESSING_ENABLED'::text) AND ((property_value)::text = 'Y'::text))
  • Rows Removed by Filter: 127
10. 0.000 0.000 ↓ 0.0 0

Index Scan using rbdls_comp_idx on rpt_bldr_data_load_status a (cost=0.28..43.63 rows=1 width=28) (never executed)

  • Index Cond: ((client_id = d_8.client_id) AND ((input_source)::text = 'REGHIST'::text))
  • Filter: ((last_load_time IS NOT NULL) AND ((status)::text = 'C'::text) AND (((alternatives: SubPlan 1 or hashed SubPlan 2) AND (SubPlan 3) AND (alternatives: SubPlan 4 or hashed SubPlan 5)) OR ((NOT (alternatives: SubPlan 6 or hashed SubPlan 7)) AND (NOT (alternatives: SubPlan 8 or hashed SubPlan 9)))))
11.          

SubPlan (for Index Scan)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on da_settings d (cost=0.00..4.22 rows=1 width=0) (never executed)

  • Filter: ((a.client_id = client_id) AND ((property_name)::text = 'REGISTRATION_HISTORY_ORC_MIGRATION'::text) AND ((property_value)::text = 'C'::text))
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on da_settings d_1 (cost=0.00..3.91 rows=1 width=5) (never executed)

  • Filter: (((property_name)::text = 'REGISTRATION_HISTORY_ORC_MIGRATION'::text) AND ((property_value)::text = 'C'::text))
14. 0.000 0.000 ↓ 0.0 0

Index Scan using rbdls_comp_idx on rpt_bldr_data_load_status b (cost=0.28..16.93 rows=1 width=0) (never executed)

  • Index Cond: ((a.client_id = client_id) AND (end_date_id < a.start_date_id) AND ((input_source)::text = 'REGHISTM'::text))
  • Filter: ((status)::text = 'C'::text)
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on da_settings d_2 (cost=0.00..4.22 rows=1 width=0) (never executed)

  • Filter: ((a.client_id = client_id) AND ((property_name)::text = 'REGISTRATION_ACTIVITIES_DATA_ORC_MIGRATION'::text) AND ((property_value)::text = 'C'::text))
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on da_settings d_3 (cost=0.00..3.91 rows=1 width=5) (never executed)

  • Filter: (((property_name)::text = 'REGISTRATION_ACTIVITIES_DATA_ORC_MIGRATION'::text) AND ((property_value)::text = 'C'::text))
17. 0.000 0.000 ↓ 0.0 0

Seq Scan on da_settings d_4 (cost=0.00..3.91 rows=1 width=0) (never executed)

  • Filter: ((a.client_id = client_id) AND ((property_name)::text = 'REGISTRATION_HISTORY_ORC_MIGRATION'::text))
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on da_settings d_5 (cost=0.00..3.59 rows=1 width=5) (never executed)

  • Filter: ((property_name)::text = 'REGISTRATION_HISTORY_ORC_MIGRATION'::text)
19. 0.000 0.000 ↓ 0.0 0

Seq Scan on da_settings d_6 (cost=0.00..3.91 rows=1 width=0) (never executed)

  • Filter: ((a.client_id = client_id) AND ((property_name)::text = 'REGISTRATION_ACTIVITIES_DATA_ORC_MIGRATION'::text))
20. 0.000 0.000 ↓ 0.0 0

Seq Scan on da_settings d_7 (cost=0.00..3.59 rows=1 width=5) (never executed)

  • Filter: ((property_name)::text = 'REGISTRATION_ACTIVITIES_DATA_ORC_MIGRATION'::text)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using rpt_bldr_date_status_pk on rpt_bldr_date_status b_1 (cost=0.29..8.31 rows=1 width=13) (never executed)

  • Index Cond: ((client_id = a.client_id) AND (date_id = a.start_date_id))
  • Filter: ((load_time IS NOT NULL) AND ((status)::text = 'C'::text))
22. 0.000 0.000 ↓ 0.0 0

Index Scan using rbdls_comp_idx on rpt_bldr_data_load_status b_2 (cost=0.28..8.29 rows=1 width=21) (never executed)

  • Index Cond: ((a.client_id = client_id) AND (a.start_date_id = start_date_id) AND ((input_source)::text = 'REGSESSMAP'::text))
  • Filter: ((last_load_time IS NULL) OR (last_load_time > a.last_load_time))
Planning time : 1.806 ms
Execution time : 0.158 ms