explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nXjk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 135.872 ↓ 1.6 16 1

Limit (cost=45,280.47..45,281.63 rows=10 width=114) (actual time=135.851..135.872 rows=16 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 47.131 47.131 ↓ 1.6 16 1 / 3

Gather Merge (cost=45,280.47..45,281.63 rows=10 width=114) (actual time=135.846..141.394 rows=16 loops=1)

3. 0.080 131.110 ↑ 1.0 5 3 / 3

Sort (cost=44,280.44..44,280.46 rows=5 width=114) (actual time=131.110..131.110 rows=5 loops=3)

  • Sort Key: last_updated_dt
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 27kB
4. 131.030 131.030 ↑ 1.0 5 3 / 3

Parallel Seq Scan on loan_transaction (cost=0.00..44,280.39 rows=5 width=114) (actual time=109.328..131.030 rows=5 loops=3)

  • Filter: (1356988712 = subscriber_id)
  • Rows Removed by Filter: 601,763
Planning time : 0.731 ms
Execution time : 141.527 ms