explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GQQ2

Settings
# exclusive inclusive rows x rows loops node
1. 56.268 10,778.316 ↓ 169.7 53,632 1

WindowAgg (cost=10,481.85..10,494.49 rows=316 width=56) (actual time=10,674.691..10,778.316 rows=53,632 loops=1)

2. 31.157 10,722.048 ↓ 169.7 53,632 1

Group (cost=10,481.85..10,485.80 rows=316 width=48) (actual time=10,674.682..10,722.048 rows=53,632 loops=1)

  • Group Key: (btrim((metadata ->> 'scorecardName'::text))), id
3. 187.693 10,690.891 ↓ 169.7 53,632 1

Sort (cost=10,481.85..10,482.64 rows=316 width=48) (actual time=10,674.678..10,690.891 rows=53,632 loops=1)

  • Sort Key: (btrim((metadata ->> 'scorecardName'::text))), id
  • Sort Method: quicksort Memory: 7890kB
4. 10,503.198 10,503.198 ↓ 169.7 53,632 1

Seq Scan on custom_reports prior_cr (cost=0.00..10,468.74 rows=316 width=48) (actual time=1.010..10,503.198 rows=53,632 loops=1)

  • Filter: ((metadata IS NOT NULL) AND (report_type = 6) AND ((metadata ->> 'isScheduledExport'::text) = '1'::text))
  • Rows Removed by Filter: 13134
Planning time : 0.212 ms
Execution time : 10,788.671 ms