explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qZ2l : asddasfdfasdfs

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 977.058 ↑ 6.4 18 1

Gather Merge (cost=46,773.17..46,787.06 rows=116 width=86) (actual time=975.124..977.058 rows=18 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 0.305 4,858.235 ↑ 7.2 4 5

Sort (cost=45,773.11..45,773.19 rows=29 width=86) (actual time=971.646..971.647 rows=4 loops=5)

  • Sort Key: start_timestamp DESC
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
  • Worker 3: Sort Method: quicksort Memory: 25kB
3. 4,857.930 4,857.930 ↑ 7.2 4 5

Parallel Seq Scan on cdc_audit (cost=0.00..45,772.41 rows=29 width=86) (actual time=970.623..971.586 rows=4 loops=5)

  • Filter: ((job_name)::text ~~* '%call_time_snapshot#%'::text)
  • Rows Removed by Filter: 483274
Planning time : 0.605 ms
Execution time : 977.100 ms