explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rs4l

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

HashAggregate (cost=19.38..21.04 rows=83 width=509) (actual time=0.003..0.003 rows=0 loops=1)

  • Group Key: stg_continuity_actionitemvisitdetail_sas_cont.item_visit_id, stg_continuity_actionitemvisitdetail_sas_cont.visit_id, (stg_continuity_actionitemvisitdetail_sas_cont.status)::boolean, stg_continuity_actionitemvisitdetail_sas_cont.is_grouped_response, stg_continuity_actionitemvisitdetail_sas_cont.is_reporting_completed, stg_continuity_actionitemvisitdetail_sas_cont.due_date, stg_continuity_actionitemvisitdetail_sas_cont.item_group_id, stg_continuity_actionitemvisitdetail_sas_cont.loaded_type, stg_continuity_actionitemvisitdetail_sas_cont.completed_items, stg_continuity_actionitemvisitdetail_sas_cont.total_items, stg_continuity_actionitemvisitdetail_sas_cont.score, stg_continuity_actionitemvisitdetail_sas_cont.status_color, stg_continuity_actionitemvisitdetail_sas_cont.itemvisitresponse_id, stg_continuity_actionitemvisitdetail_sas_cont.captured_fields, stg_continuity_actionitemvisitdetail_sas_cont.response_status, stg_continuity_actionitemvisitdetail_sas_cont.item_status_color, stg_continuity_actionitemvisitdetail_sas_cont.itemresponse_is_reporting_completed, stg_continuity_actionitemvisitdetail_sas_cont.workflag_priority, stg_continuity_actionitemvisitdetail_sas_cont.source, stg_continuity_actionitemvisitdetail_sas_cont.actionitem_id, stg_continuity_actionitemvisitdetail_sas_cont.action_config_id, stg_continuity_actionitemvisitdetail_sas_cont.action_type_id, stg_continuity_actionitemvisitdetail_sas_cont.item_id, stg_continuity_actionitemvisitdetail_sas_cont.last_reporting_status, stg_continuity_actionitemvisitdetail_sas_cont.last_reporting_visit_id, stg_continuity_actionitemvisitdetail_sas_cont.project_cycle_id, stg_continuity_actionitemvisitdetail_sas_cont.max_qty_placed, stg_continuity_actionitemvisitdetail_sas_cont.store_id, stg_continuity_actionitemvisitdetail_sas_cont.project_id, stg_continuity_actionitemvisitdetail_sas_cont.response_time_modified, (stg_continuity_actionitemvisitdetail_sas_cont.captured_fields_json)::text, stg_continuity_actionitemvisitdetail_sas_cont.response_unregistered_timestamp
2. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on stg_continuity_actionitemvisitdetail_sas_cont stg_continuity_actionitemvisitdetail_sas_cont (cost=0..12.74 rows=83 width=509) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (stg_continuity_actionitemvisitdetail_sas_cont.action_type_id = ANY ('{1,8,9,10,14,15,16,19,20}'::integer[]))
Planning time : 38.39 ms
Execution time : 0.182 ms