explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S5OW

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 469.821 ↓ 6.2 50 1

Limit (cost=74.55..533.87 rows=8 width=522) (actual time=468.104..469.821 rows=50 loops=1)

  • Output: reports.receive_time, reports.corrective_change, reports.code_id, reports.noop, reports.certname, reports.puppet_version, (encode(reports.hash, 'hex'::text)), reports.cached_catalog_status, ((reports.transaction_uuid)::text), reports.configuration_version, report_statuses.status, reports.job_id, producers.name, ((reports.catalog_uuid)::text), ((SubPlan 2)), reports.noop_pending, reports.end_time, reports.report_type, environments.environment, reports.start_time, ((SubPlan 3)), ((SubPlan 4)), reports.producer_timestamp, reports.report_format, ((SubPlan 5))
2.          

CTE not_active_nodes

3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on public.certnames certnames_1 (cost=0.00..1.03 rows=1 width=34) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: certnames_1.certname
  • Filter: ((certnames_1.deactivated IS NOT NULL) OR (certnames_1.expired IS NOT NULL))
  • Rows Removed by Filter: 3
4. 0.251 469.795 ↓ 6.2 50 1

Result (cost=73.52..532.84 rows=8 width=522) (actual time=468.102..469.795 rows=50 loops=1)

  • Output: reports.receive_time, reports.corrective_change, reports.code_id, reports.noop, reports.certname, reports.puppet_version, (encode(reports.hash, 'hex'::text)), reports.cached_catalog_status, ((reports.transaction_uuid)::text), reports.configuration_version, report_statuses.status, reports.job_id, producers.name, ((reports.catalog_uuid)::text), ((SubPlan 2)), reports.noop_pending, reports.end_time, reports.report_type, environments.environment, reports.start_time, (SubPlan 3), ((SubPlan 4)), reports.producer_timestamp, reports.report_format, ((SubPlan 5))
5. 9.218 468.044 ↓ 6.2 50 1

Sort (cost=73.52..73.54 rows=8 width=521) (actual time=468.008..468.044 rows=50 loops=1)

  • Output: reports.receive_time, reports.corrective_change, reports.code_id, reports.noop, reports.certname, reports.puppet_version, (encode(reports.hash, 'hex'::text)), reports.cached_catalog_status, ((reports.transaction_uuid)::text), reports.configuration_version, report_statuses.status, reports.job_id, producers.name, ((reports.catalog_uuid)::text), ((SubPlan 2)), reports.noop_pending, reports.end_time, reports.report_type, environments.environment, reports.start_time, ((SubPlan 4)), reports.producer_timestamp, reports.report_format, ((SubPlan 5)), reports.hash, reports.id
  • Sort Key: reports.end_time
  • Sort Method: top-N heapsort Memory: 1,114kB
6. 14.192 458.826 ↓ 41.2 330 1

Nested Loop Left Join (cost=3.21..73.40 rows=8 width=521) (actual time=1.378..458.826 rows=330 loops=1)

  • Output: reports.receive_time, reports.corrective_change, reports.code_id, reports.noop, reports.certname, reports.puppet_version, encode(reports.hash, 'hex'::text), reports.cached_catalog_status, (reports.transaction_uuid)::text, reports.configuration_version, report_statuses.status, reports.job_id, producers.name, (reports.catalog_uuid)::text, (SubPlan 2), reports.noop_pending, reports.end_time, reports.report_type, environments.environment, reports.start_time, (SubPlan 4), reports.producer_timestamp, reports.report_format, (SubPlan 5), reports.hash, reports.id
  • Inner Unique: true
  • Join Filter: (reports.status_id = report_statuses.id)
  • Rows Removed by Join Filter: 319
7. 0.281 4.744 ↓ 41.2 330 1

Nested Loop Left Join (cost=3.21..71.47 rows=8 width=1,351) (actual time=1.099..4.744 rows=330 loops=1)

  • Output: reports.receive_time, reports.corrective_change, reports.code_id, reports.noop, reports.certname, reports.puppet_version, reports.hash, reports.cached_catalog_status, reports.transaction_uuid, reports.configuration_version, reports.job_id, reports.catalog_uuid, reports.logs, reports.logs_json, reports.noop_pending, reports.end_time, reports.report_type, reports.start_time, reports.id, reports.metrics, reports.metrics_json, reports.producer_timestamp, reports.report_format, reports.resources, reports.status_id, environments.environment, producers.name
  • Inner Unique: true
  • Join Filter: (producers.id = reports.producer_id)
  • Rows Removed by Join Filter: 2
8. 0.458 4.463 ↓ 41.2 330 1

Nested Loop Left Join (cost=3.21..70.33 rows=8 width=1,325) (actual time=1.094..4.463 rows=330 loops=1)

  • Output: reports.receive_time, reports.corrective_change, reports.code_id, reports.noop, reports.certname, reports.puppet_version, reports.hash, reports.cached_catalog_status, reports.transaction_uuid, reports.configuration_version, reports.job_id, reports.catalog_uuid, reports.logs, reports.logs_json, reports.noop_pending, reports.end_time, reports.report_type, reports.start_time, reports.id, reports.metrics, reports.metrics_json, reports.producer_timestamp, reports.report_format, reports.resources, reports.producer_id, reports.status_id, environments.environment
  • Inner Unique: true
  • Join Filter: (environments.id = reports.environment_id)
9. 0.287 4.005 ↓ 41.2 330 1

Nested Loop (cost=3.21..69.11 rows=8 width=1,319) (actual time=1.088..4.005 rows=330 loops=1)

  • Output: reports.receive_time, reports.corrective_change, reports.code_id, reports.noop, reports.certname, reports.puppet_version, reports.hash, reports.cached_catalog_status, reports.transaction_uuid, reports.configuration_version, reports.job_id, reports.catalog_uuid, reports.logs, reports.logs_json, reports.noop_pending, reports.end_time, reports.report_type, reports.start_time, reports.id, reports.metrics, reports.metrics_json, reports.producer_timestamp, reports.report_format, reports.resources, reports.environment_id, reports.producer_id, reports.status_id
  • Join Filter: (reports.certname = fs.certname)
10. 0.014 1.033 ↓ 3.0 3 1

HashAggregate (cost=3.19..3.20 rows=1 width=68) (actual time=1.026..1.033 rows=3 loops=1)

  • Output: fs.certname, certnames.certname
  • Group Key: certnames.certname
11. 0.011 1.019 ↓ 3.0 3 1

Nested Loop (cost=0.00..3.19 rows=1 width=68) (actual time=0.390..1.019 rows=3 loops=1)

  • Output: fs.certname, certnames.certname
  • Inner Unique: true
  • Join Filter: (fs.certname = certnames.certname)
  • Rows Removed by Join Filter: 3
12. 1.002 1.002 ↓ 3.0 3 1

Seq Scan on public.factsets fs (cost=0.00..2.12 rows=1 width=42) (actual time=0.384..1.002 rows=3 loops=1)

  • Output: fs.id, fs.certname, fs."timestamp", fs.environment_id, fs.hash, fs.producer_timestamp, fs.producer_id, fs.paths_hash, fs.stable, fs.stable_hash, fs.volatile
  • Filter: (((fs.stable || fs.volatile) @> '{"operatingsystem": "CentOS"}'::jsonb) AND ((fs.stable || fs.volatile) @> '{"operatingsystemmajrelease": "7"}'::jsonb))
13. 0.006 0.006 ↑ 1.5 2 3

Seq Scan on public.certnames (cost=0.00..1.03 rows=3 width=34) (actual time=0.002..0.002 rows=2 loops=3)

  • Output: certnames.id, certnames.certname, certnames.latest_report_id, certnames.deactivated, certnames.expired, certnames.package_hash, certnames.latest_report_timestamp, certnames.catalog_inputs_timestamp, certnames.catalog_inputs_uuid
14. 0.243 2.685 ↓ 3.9 110 3

Append (cost=0.02..65.56 rows=28 width=1,319) (actual time=0.043..0.895 rows=110 loops=3)

15. 0.000 0.003 ↓ 0.0 0 3

Seq Scan on public.reports (cost=0.02..0.02 rows=1 width=517) (actual time=0.001..0.001 rows=0 loops=3)

  • Output: reports.receive_time, reports.corrective_change, reports.code_id, reports.noop, reports.certname, reports.puppet_version, reports.hash, reports.cached_catalog_status, reports.transaction_uuid, reports.configuration_version, reports.job_id, reports.catalog_uuid, reports.logs, reports.logs_json, reports.noop_pending, reports.end_time, reports.report_type, reports.start_time, reports.id, reports.metrics, reports.metrics_json, reports.producer_timestamp, reports.report_format, reports.resources, reports.environment_id, reports.producer_id, reports.status_id
  • Filter: ((NOT (hashed SubPlan 6)) AND (reports.report_type = 'agent'::text) AND (certnames.certname = reports.certname))
16.          

SubPlan (for Seq Scan)

17. 0.009 0.009 ↓ 0.0 0 9

CTE Scan on not_active_nodes (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=9)

  • Output: not_active_nodes.certname
18. 0.318 0.378 ↓ 1.3 25 3

Bitmap Heap Scan on public.reports_20200721z (cost=3.12..16.76 rows=19 width=1,509) (actual time=0.035..0.126 rows=25 loops=3)

  • Output: reports_20200721z.receive_time, reports_20200721z.corrective_change, reports_20200721z.code_id, reports_20200721z.noop, reports_20200721z.certname, reports_20200721z.puppet_version, reports_20200721z.hash, reports_20200721z.cached_catalog_status, reports_20200721z.transaction_uuid, reports_20200721z.configuration_version, reports_20200721z.job_id, reports_20200721z.catalog_uuid, reports_20200721z.logs, reports_20200721z.logs_json, reports_20200721z.noop_pending, reports_20200721z.end_time, reports_20200721z.report_type, reports_20200721z.start_time, reports_20200721z.id, reports_20200721z.metrics, reports_20200721z.metrics_json, reports_20200721z.producer_timestamp, reports_20200721z.report_format, reports_20200721z.resources, reports_20200721z.environment_id, reports_20200721z.producer_id, reports_20200721z.status_id
  • Recheck Cond: (reports_20200721z.certname = certnames.certname)
  • Filter: ((NOT (hashed SubPlan 6)) AND (reports_20200721z.report_type = 'agent'::text))
  • Heap Blocks: exact=31
19. 0.060 0.060 ↑ 1.5 25 3

Bitmap Index Scan on reports_certname_idx_20200721z (cost=0.00..3.09 rows=38 width=0) (actual time=0.020..0.020 rows=25 loops=3)

  • Index Cond: (reports_20200721z.certname = certnames.certname)
20. 0.129 0.129 ↓ 5.0 5 3

Seq Scan on public.reports_20200724z (cost=0.02..4.30 rows=1 width=517) (actual time=0.022..0.043 rows=5 loops=3)

  • Output: reports_20200724z.receive_time, reports_20200724z.corrective_change, reports_20200724z.code_id, reports_20200724z.noop, reports_20200724z.certname, reports_20200724z.puppet_version, reports_20200724z.hash, reports_20200724z.cached_catalog_status, reports_20200724z.transaction_uuid, reports_20200724z.configuration_version, reports_20200724z.job_id, reports_20200724z.catalog_uuid, reports_20200724z.logs, reports_20200724z.logs_json, reports_20200724z.noop_pending, reports_20200724z.end_time, reports_20200724z.report_type, reports_20200724z.start_time, reports_20200724z.id, reports_20200724z.metrics, reports_20200724z.metrics_json, reports_20200724z.producer_timestamp, reports_20200724z.report_format, reports_20200724z.resources, reports_20200724z.environment_id, reports_20200724z.producer_id, reports_20200724z.status_id
  • Filter: ((NOT (hashed SubPlan 6)) AND (reports_20200724z.report_type = 'agent'::text) AND (certnames.certname = reports_20200724z.certname))
  • Rows Removed by Filter: 11
21. 0.228 0.228 ↓ 16.0 16 3

Index Scan using reports_certname_idx_20200725z on public.reports_20200725z (cost=0.16..6.85 rows=1 width=517) (actual time=0.020..0.076 rows=16 loops=3)

  • Output: reports_20200725z.receive_time, reports_20200725z.corrective_change, reports_20200725z.code_id, reports_20200725z.noop, reports_20200725z.certname, reports_20200725z.puppet_version, reports_20200725z.hash, reports_20200725z.cached_catalog_status, reports_20200725z.transaction_uuid, reports_20200725z.configuration_version, reports_20200725z.job_id, reports_20200725z.catalog_uuid, reports_20200725z.logs, reports_20200725z.logs_json, reports_20200725z.noop_pending, reports_20200725z.end_time, reports_20200725z.report_type, reports_20200725z.start_time, reports_20200725z.id, reports_20200725z.metrics, reports_20200725z.metrics_json, reports_20200725z.producer_timestamp, reports_20200725z.report_format, reports_20200725z.resources, reports_20200725z.environment_id, reports_20200725z.producer_id, reports_20200725z.status_id
  • Index Cond: (reports_20200725z.certname = certnames.certname)
  • Filter: ((NOT (hashed SubPlan 6)) AND (reports_20200725z.report_type = 'agent'::text))
22. 0.225 0.225 ↓ 16.0 16 3

Index Scan using reports_certname_idx_20200726z on public.reports_20200726z (cost=0.16..6.85 rows=1 width=517) (actual time=0.019..0.075 rows=16 loops=3)

  • Output: reports_20200726z.receive_time, reports_20200726z.corrective_change, reports_20200726z.code_id, reports_20200726z.noop, reports_20200726z.certname, reports_20200726z.puppet_version, reports_20200726z.hash, reports_20200726z.cached_catalog_status, reports_20200726z.transaction_uuid, reports_20200726z.configuration_version, reports_20200726z.job_id, reports_20200726z.catalog_uuid, reports_20200726z.logs, reports_20200726z.logs_json, reports_20200726z.noop_pending, reports_20200726z.end_time, reports_20200726z.report_type, reports_20200726z.start_time, reports_20200726z.id, reports_20200726z.metrics, reports_20200726z.metrics_json, reports_20200726z.producer_timestamp, reports_20200726z.report_format, reports_20200726z.resources, reports_20200726z.environment_id, reports_20200726z.producer_id, reports_20200726z.status_id
  • Index Cond: (reports_20200726z.certname = certnames.certname)
  • Filter: ((NOT (hashed SubPlan 6)) AND (reports_20200726z.report_type = 'agent'::text))
23. 0.258 0.258 ↓ 16.0 16 3

Index Scan using reports_certname_idx_20200727z on public.reports_20200727z (cost=0.16..6.85 rows=1 width=517) (actual time=0.023..0.086 rows=16 loops=3)

  • Output: reports_20200727z.receive_time, reports_20200727z.corrective_change, reports_20200727z.code_id, reports_20200727z.noop, reports_20200727z.certname, reports_20200727z.puppet_version, reports_20200727z.hash, reports_20200727z.cached_catalog_status, reports_20200727z.transaction_uuid, reports_20200727z.configuration_version, reports_20200727z.job_id, reports_20200727z.catalog_uuid, reports_20200727z.logs, reports_20200727z.logs_json, reports_20200727z.noop_pending, reports_20200727z.end_time, reports_20200727z.report_type, reports_20200727z.start_time, reports_20200727z.id, reports_20200727z.metrics, reports_20200727z.metrics_json, reports_20200727z.producer_timestamp, reports_20200727z.report_format, reports_20200727z.resources, reports_20200727z.environment_id, reports_20200727z.producer_id, reports_20200727z.status_id
  • Index Cond: (reports_20200727z.certname = certnames.certname)
  • Filter: ((NOT (hashed SubPlan 6)) AND (reports_20200727z.report_type = 'agent'::text))
24. 0.228 0.228 ↓ 13.0 13 3

Index Scan using reports_certname_idx_20200728z on public.reports_20200728z (cost=0.16..6.85 rows=1 width=517) (actual time=0.028..0.076 rows=13 loops=3)

  • Output: reports_20200728z.receive_time, reports_20200728z.corrective_change, reports_20200728z.code_id, reports_20200728z.noop, reports_20200728z.certname, reports_20200728z.puppet_version, reports_20200728z.hash, reports_20200728z.cached_catalog_status, reports_20200728z.transaction_uuid, reports_20200728z.configuration_version, reports_20200728z.job_id, reports_20200728z.catalog_uuid, reports_20200728z.logs, reports_20200728z.logs_json, reports_20200728z.noop_pending, reports_20200728z.end_time, reports_20200728z.report_type, reports_20200728z.start_time, reports_20200728z.id, reports_20200728z.metrics, reports_20200728z.metrics_json, reports_20200728z.producer_timestamp, reports_20200728z.report_format, reports_20200728z.resources, reports_20200728z.environment_id, reports_20200728z.producer_id, reports_20200728z.status_id
  • Index Cond: (reports_20200728z.certname = certnames.certname)
  • Filter: ((NOT (hashed SubPlan 6)) AND (reports_20200728z.report_type = 'agent'::text))
25. 0.171 0.171 ↓ 4.0 4 3

Seq Scan on public.reports_20200729z (cost=0.02..3.21 rows=1 width=517) (actual time=0.025..0.057 rows=4 loops=3)

  • Output: reports_20200729z.receive_time, reports_20200729z.corrective_change, reports_20200729z.code_id, reports_20200729z.noop, reports_20200729z.certname, reports_20200729z.puppet_version, reports_20200729z.hash, reports_20200729z.cached_catalog_status, reports_20200729z.transaction_uuid, reports_20200729z.configuration_version, reports_20200729z.job_id, reports_20200729z.catalog_uuid, reports_20200729z.logs, reports_20200729z.logs_json, reports_20200729z.noop_pending, reports_20200729z.end_time, reports_20200729z.report_type, reports_20200729z.start_time, reports_20200729z.id, reports_20200729z.metrics, reports_20200729z.metrics_json, reports_20200729z.producer_timestamp, reports_20200729z.report_format, reports_20200729z.resources, reports_20200729z.environment_id, reports_20200729z.producer_id, reports_20200729z.status_id
  • Filter: ((NOT (hashed SubPlan 6)) AND (reports_20200729z.report_type = 'agent'::text) AND (certnames.certname = reports_20200729z.certname))
  • Rows Removed by Filter: 7
26. 0.762 0.762 ↓ 14.0 14 3

Index Scan using reports_certname_idx_20200730z on public.reports_20200730z (cost=0.16..6.85 rows=1 width=517) (actual time=0.034..0.254 rows=14 loops=3)

  • Output: reports_20200730z.receive_time, reports_20200730z.corrective_change, reports_20200730z.code_id, reports_20200730z.noop, reports_20200730z.certname, reports_20200730z.puppet_version, reports_20200730z.hash, reports_20200730z.cached_catalog_status, reports_20200730z.transaction_uuid, reports_20200730z.configuration_version, reports_20200730z.job_id, reports_20200730z.catalog_uuid, reports_20200730z.logs, reports_20200730z.logs_json, reports_20200730z.noop_pending, reports_20200730z.end_time, reports_20200730z.report_type, reports_20200730z.start_time, reports_20200730z.id, reports_20200730z.metrics, reports_20200730z.metrics_json, reports_20200730z.producer_timestamp, reports_20200730z.report_format, reports_20200730z.resources, reports_20200730z.environment_id, reports_20200730z.producer_id, reports_20200730z.status_id
  • Index Cond: (reports_20200730z.certname = certnames.certname)
  • Filter: ((NOT (hashed SubPlan 6)) AND (reports_20200730z.report_type = 'agent'::text))
27. 0.060 0.060 ↑ 1.0 1 3

Index Scan using reports_certname_idx_20200803z on public.reports_20200803z (cost=0.17..6.86 rows=1 width=517) (actual time=0.019..0.020 rows=1 loops=3)

  • Output: reports_20200803z.receive_time, reports_20200803z.corrective_change, reports_20200803z.code_id, reports_20200803z.noop, reports_20200803z.certname, reports_20200803z.puppet_version, reports_20200803z.hash, reports_20200803z.cached_catalog_status, reports_20200803z.transaction_uuid, reports_20200803z.configuration_version, reports_20200803z.job_id, reports_20200803z.catalog_uuid, reports_20200803z.logs, reports_20200803z.logs_json, reports_20200803z.noop_pending, reports_20200803z.end_time, reports_20200803z.report_type, reports_20200803z.start_time, reports_20200803z.id, reports_20200803z.metrics, reports_20200803z.metrics_json, reports_20200803z.producer_timestamp, reports_20200803z.report_format, reports_20200803z.resources, reports_20200803z.environment_id, reports_20200803z.producer_id, reports_20200803z.status_id
  • Index Cond: (reports_20200803z.certname = certnames.certname)
  • Filter: ((NOT (hashed SubPlan 6)) AND (reports_20200803z.report_type = 'agent'::text))
28. 0.000 0.000 ↑ 2.0 1 330

Materialize (cost=0.00..1.03 rows=2 width=22) (actual time=0.000..0.000 rows=1 loops=330)

  • Output: environments.environment, environments.id
29. 0.002 0.002 ↑ 2.0 1 1

Seq Scan on public.environments (cost=0.00..1.02 rows=2 width=22) (actual time=0.002..0.002 rows=1 loops=1)

  • Output: environments.environment, environments.id
30. 0.000 0.000 ↑ 1.0 1 330

Materialize (cost=0.00..1.01 rows=1 width=42) (actual time=0.000..0.000 rows=1 loops=330)

  • Output: producers.name, producers.id
31. 0.004 0.004 ↓ 2.0 2 1

Seq Scan on public.producers (cost=0.00..1.01 rows=1 width=42) (actual time=0.003..0.004 rows=2 loops=1)

  • Output: producers.name, producers.id
32. 0.000 0.000 ↑ 1.5 2 330

Materialize (cost=0.00..1.04 rows=3 width=16) (actual time=0.000..0.000 rows=2 loops=330)

  • Output: report_statuses.status, report_statuses.id
33. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on public.report_statuses (cost=0.00..1.03 rows=3 width=16) (actual time=0.003..0.004 rows=3 loops=1)

  • Output: report_statuses.status, report_statuses.id
34.          

SubPlan (for Nested Loop Left Join)

35. 12.540 12.540 ↑ 1.0 1 330

Result (cost=0.00..0.02 rows=1 width=32) (actual time=0.037..0.038 rows=1 loops=330)

  • Output: row_to_json(ROW(COALESCE(reports.logs, (reports.logs_json)::jsonb), format('/pdb/query/v4/reports/%s/logs'::text, encode(reports.hash, 'hex'::text))))
36. 10.560 10.560 ↑ 1.0 1 330

Result (cost=0.00..0.02 rows=1 width=32) (actual time=0.032..0.032 rows=1 loops=330)

  • Output: row_to_json(ROW(COALESCE(reports.metrics, (reports.metrics_json)::jsonb), format('/pdb/query/v4/reports/%s/metrics'::text, encode(reports.hash, 'hex'::text))))
37. 416.790 416.790 ↑ 1.0 1 330

Result (cost=0.00..0.02 rows=1 width=32) (actual time=1.261..1.263 rows=1 loops=330)

  • Output: row_to_json(ROW(reports.resources, format('/pdb/query/v4/reports/%s/resources'::text, encode(reports.hash, 'hex'::text))))
38.          

SubPlan (for Result)

39. 0.200 1.500 ↑ 1.0 1 50

Subquery Scan on event_data (cost=57.30..57.33 rows=1 width=32) (actual time=0.030..0.030 rows=1 loops=50)

  • Output: row_to_json(event_data.*)
40. 0.300 1.300 ↑ 1.0 1 50

Aggregate (cost=57.30..57.31 rows=1 width=64) (actual time=0.026..0.026 rows=1 loops=50)

  • Output: json_agg(row_to_json(ROW(re.status, re."timestamp", re.resource_type, re.resource_title, re.property, re.corrective_change, (re.new_value)::jsonb, (re.old_value)::jsonb, re.message, re.file, re.line, re.containment_path, re.containing_class, re.name))), format('/pdb/query/v4/reports/%s/events'::text, encode(reports.hash, 'hex'::text))
41. 0.500 1.000 ↓ 0.0 0 50

Append (cost=0.00..57.18 rows=8 width=365) (actual time=0.020..0.020 rows=0 loops=50)

42. 0.000 0.000 ↓ 0.0 0 50

Seq Scan on public.resource_events re (cost=0.00..0.00 rows=1 width=365) (actual time=0.000..0.000 rows=0 loops=50)

  • Output: re.status, re."timestamp", re.resource_type, re.resource_title, re.property, re.corrective_change, re.new_value, re.old_value, re.message, re.file, re.line, re.containment_path, re.containing_class, re.name
  • Filter: (reports.id = re.report_id)
43. 0.200 0.200 ↓ 0.0 0 50

Index Scan using resource_events_reports_id_idx_20200721z on public.resource_events_20200721z re_1 (cost=0.14..8.16 rows=1 width=365) (actual time=0.004..0.004 rows=0 loops=50)

  • Output: re_1.status, re_1."timestamp", re_1.resource_type, re_1.resource_title, re_1.property, re_1.corrective_change, re_1.new_value, re_1.old_value, re_1.message, re_1.file, re_1.line, re_1.containment_path, re_1.containing_class, re_1.name
  • Index Cond: (reports.id = re_1.report_id)
44. 0.050 0.050 ↓ 0.0 0 50

Index Scan using resource_events_reports_id_idx_20200724z on public.resource_events_20200724z re_2 (cost=0.14..8.16 rows=1 width=365) (actual time=0.001..0.001 rows=0 loops=50)

  • Output: re_2.status, re_2."timestamp", re_2.resource_type, re_2.resource_title, re_2.property, re_2.corrective_change, re_2.new_value, re_2.old_value, re_2.message, re_2.file, re_2.line, re_2.containment_path, re_2.containing_class, re_2.name
  • Index Cond: (reports.id = re_2.report_id)
45. 0.050 0.050 ↓ 0.0 0 50

Index Scan using resource_events_reports_id_idx_20200727z on public.resource_events_20200727z re_3 (cost=0.14..8.16 rows=1 width=365) (actual time=0.001..0.001 rows=0 loops=50)

  • Output: re_3.status, re_3."timestamp", re_3.resource_type, re_3.resource_title, re_3.property, re_3.corrective_change, re_3.new_value, re_3.old_value, re_3.message, re_3.file, re_3.line, re_3.containment_path, re_3.containing_class, re_3.name
  • Index Cond: (reports.id = re_3.report_id)
46. 0.050 0.050 ↓ 0.0 0 50

Index Scan using resource_events_reports_id_idx_20200728z on public.resource_events_20200728z re_4 (cost=0.14..8.16 rows=1 width=365) (actual time=0.001..0.001 rows=0 loops=50)

  • Output: re_4.status, re_4."timestamp", re_4.resource_type, re_4.resource_title, re_4.property, re_4.corrective_change, re_4.new_value, re_4.old_value, re_4.message, re_4.file, re_4.line, re_4.containment_path, re_4.containing_class, re_4.name
  • Index Cond: (reports.id = re_4.report_id)
47. 0.050 0.050 ↓ 0.0 0 50

Index Scan using resource_events_reports_id_idx_20200729z on public.resource_events_20200729z re_5 (cost=0.14..8.16 rows=1 width=365) (actual time=0.001..0.001 rows=0 loops=50)

  • Output: re_5.status, re_5."timestamp", re_5.resource_type, re_5.resource_title, re_5.property, re_5.corrective_change, re_5.new_value, re_5.old_value, re_5.message, re_5.file, re_5.line, re_5.containment_path, re_5.containing_class, re_5.name
  • Index Cond: (reports.id = re_5.report_id)
48. 0.050 0.050 ↓ 0.0 0 50

Index Scan using resource_events_reports_id_idx_20200730z on public.resource_events_20200730z re_6 (cost=0.14..8.16 rows=1 width=365) (actual time=0.001..0.001 rows=0 loops=50)

  • Output: re_6.status, re_6."timestamp", re_6.resource_type, re_6.resource_title, re_6.property, re_6.corrective_change, re_6.new_value, re_6.old_value, re_6.message, re_6.file, re_6.line, re_6.containment_path, re_6.containing_class, re_6.name
  • Index Cond: (reports.id = re_6.report_id)
49. 0.050 0.050 ↓ 0.0 0 50

Index Scan using resource_events_reports_id_idx_20200803z on public.resource_events_20200803z re_7 (cost=0.14..8.16 rows=1 width=365) (actual time=0.001..0.001 rows=0 loops=50)

  • Output: re_7.status, re_7."timestamp", re_7.resource_type, re_7.resource_title, re_7.property, re_7.corrective_change, re_7.new_value, re_7.old_value, re_7.message, re_7.file, re_7.line, re_7.containment_path, re_7.containing_class, re_7.name
  • Index Cond: (reports.id = re_7.report_id)