explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SroN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=69,530.59..69,533.55 rows=74 width=23) (actual rows= loops=)

  • Group Key: tca_fills.order_id
2. 0.000 0.000 ↓ 0.0

Sort (cost=69,530.59..69,530.77 rows=74 width=59) (actual rows= loops=)

  • Sort Key: tca_fills.order_id
3. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=67,923.49..69,528.29 rows=74 width=59) (actual rows= loops=)

  • Hash Cond: ((ref.isin = raw_fills.security_id) AND (ind.currency = raw_fills.ccy))
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=24.14..1,614.82 rows=806 width=17) (actual rows= loops=)

  • Hash Cond: (ref.isin = ind.isin)
5. 0.000 0.000 ↓ 0.0

Seq Scan on edi_reference_data ref (cost=0.00..1,176.23 rows=65,023 width=13) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=14.06..14.06 rows=806 width=17) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on index_data ind (cost=0.00..14.06 rows=806 width=17) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=67,898.25..67,898.25 rows=74 width=76) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=67,883.76..67,898.25 rows=74 width=76) (actual rows= loops=)

  • Hash Cond: (test.date = raw_fills.date)
10. 0.000 0.000 ↓ 0.0

Function Scan on crosstab test (cost=0.00..10.00 rows=1,000 width=12) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=67,883.37..67,883.37 rows=31 width=72) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.09..67,883.37 rows=31 width=72) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.55..36,838.41 rows=47,641 width=209) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on uploads (cost=0.00..38.08 rows=608 width=111) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using tca_fills_cr_req on tca_fills (cost=0.55..60.24 rows=29 width=135) (actual rows= loops=)

  • Index Cond: ((created_by = uploads.created_by) AND (request_id = uploads.request_id))
  • Filter: (('9bd38d15-94dd-451d-b8fc-60a29e42a1c0'::text = created_by) OR (('c2a7f7d0-2c38-4418-adda-0f7c6af31440'::text = uploads.organization_id) AND uploads.is_public))
16. 0.000 0.000 ↓ 0.0

Index Scan using raw_fills_cr_req_order_id on raw_fills (cost=0.55..0.64 rows=1 width=148) (actual rows= loops=)

  • Index Cond: ((created_by = tca_fills.created_by) AND (request_id = tca_fills.request_id) AND (order_id = tca_fills.order_id))
  • Filter: (tca_fills.fill_id = fill_id)