explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Wd4

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.810 18.721 ↑ 1.0 10,000 1

Limit (cost=14.56..1,655.21 rows=10,000 width=718) (actual time=0.189..18.721 rows=10,000 loops=1)

2. 6.046 17.911 ↑ 38.8 10,000 1

Hash Left Join (cost=14.56..63,625.28 rows=387,718 width=718) (actual time=0.188..17.911 rows=10,000 loops=1)

  • Hash Cond: (p.contract_id = c.id)
3. 7.823 11.782 ↑ 38.8 10,000 1

Hash Left Join (cost=6.76..57,317.07 rows=387,718 width=671) (actual time=0.086..11.782 rows=10,000 loops=1)

  • Hash Cond: (p.operation_type_id = op.id)
4. 3.906 3.906 ↑ 38.8 10,000 1

Seq Scan on registry_payment_dto p (cost=0.00..51,979.18 rows=387,718 width=423) (actual time=0.005..3.906 rows=10,000 loops=1)

  • Filter: (id IS NOT NULL)
5. 0.011 0.053 ↑ 1.0 34 1

Hash (cost=6.34..6.34 rows=34 width=256) (actual time=0.053..0.053 rows=34 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
6. 0.042 0.042 ↑ 1.0 34 1

Seq Scan on nsi_operation_types op (cost=0.00..6.34 rows=34 width=256) (actual time=0.020..0.042 rows=34 loops=1)

7. 0.026 0.083 ↓ 1.0 82 1

Hash (cost=6.80..6.80 rows=80 width=63) (actual time=0.083..0.083 rows=82 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
8. 0.057 0.057 ↓ 1.0 82 1

Seq Scan on contract c (cost=0.00..6.80 rows=80 width=63) (actual time=0.007..0.057 rows=82 loops=1)