explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 99pK : report histories

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

Nested Loop (cost=0.84..12.41 rows=1 width=1,472) (actual time=1.074..1.074 rows=0 loops=1)

  • Join Filter: (rh.id = curh.report_history_id)
2. 1.073 1.073 ↓ 0.0 0 1

Index Scan using pk_report_histories on report_histories rh (cost=0.42..6.20 rows=1 width=1,468) (actual time=1.073..1.073 rows=0 loops=1)

  • Index Cond: (cid = 2,683)
  • Filter: ((report_new_instance_id IS NULL) AND (NOT (details ? 'is_from_library'::text)) AND (report_schedule_type_id = 1) AND (COALESCE((download_options ->> 'self_destruct'::text), 'false'::text))::boolean)
3. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_company_user_report_histories on company_user_report_histories curh (cost=0.42..6.19 rows=1 width=12) (never executed)

  • Index Cond: (cid = 2,683)
  • Filter: (is_temporary AND (company_user_id = 2,133))
Planning time : 4.223 ms