explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XdF3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 9,439.446 ↑ 1.0 1 1

Finalize Aggregate (cost=75,430.53..75,430.54 rows=1 width=8) (actual time=9,439.446..9,439.446 rows=1 loops=1)

2. 46.940 9,447.879 ↓ 1.5 3 1

Gather (cost=75,430.32..75,430.53 rows=2 width=8) (actual time=9,424.748..9,447.879 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 9,400.939 9,400.939 ↑ 1.0 1 3

Partial Aggregate (cost=74,430.32..74,430.33 rows=1 width=8) (actual time=9,400.939..9,400.939 rows=1 loops=3)

  • -> Parallel Index Scan using requestlog_created_at_idx on requestlog (cost=0.44..74426.53 rows=1516 width=0) (actual time=2.260..9400.642 row
  • Index Cond: (created_at > (CURRENT_TIMESTAMP - '8 days'::interval))
  • Filter: ((execution_time IS NOT NULL) AND (((req_body)::jsonb -> 'method'::text) IS NOT NULL) AND (((res_body)::jsonb ->> 'result'::text)
  • Rows Removed by Filter: 246049
Planning time : 0.233 ms
Execution time : 9,447.952 ms