explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NpNxR

Settings
# exclusive inclusive rows x rows loops node
1. 221.852 1,440.750 ↑ 1.7 84,745 1

Gather (cost=15,688.83..366,895.15 rows=145,705 width=609) (actual time=879.127..1,440.750 rows=84,745 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 91.584 1,218.898 ↑ 2.1 28,248 3 / 3

Hash Join (cost=14,688.83..351,324.65 rows=60,710 width=609) (actual time=837.430..1,218.898 rows=28,248 loops=3)

  • Hash Cond: (clp.lease_id = lus.lease_id)
3. 569.108 569.108 ↑ 2.1 28,120 3 / 3

Parallel Seq Scan on cached_lease_periods clp (cost=0.00..333,762.60 rows=60,430 width=545) (actual time=276.704..569.108 rows=28,120 loops=3)

  • Filter: ((cid = 13531) AND (post_month = '2020-05-01'::date) AND (lease_status_type_id = ANY ('{3,4,5}'::integer[])))
  • Rows Removed by Filter: 1290400
4. 283.222 558.206 ↓ 1.0 420,946 3 / 3

Hash (cost=9,431.30..9,431.30 rows=420,602 width=64) (actual time=558.206..558.206 rows=420,946 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 38769kB
5. 274.984 274.984 ↓ 1.0 420,946 3 / 3

Seq Scan on lease_unit_spaces lus (cost=0.00..9,431.30 rows=420,602 width=64) (actual time=0.039..274.984 rows=420,946 loops=3)

  • Filter: ((deleted_on IS NULL) AND (deleted_by IS NULL) AND (cid = 13531))
  • Rows Removed by Filter: 358