explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ryd1

Settings
# exclusive inclusive rows x rows loops node
1. 1,952.382 1,952.464 ↑ 1.0 1 1

Result (cost=7.89..8.41 rows=1 width=303) (actual time=1,952.458..1,952.464 rows=1 loops=1)

2. 0.018 0.082 ↑ 1.0 1 1

Sort (cost=7.89..7.90 rows=1 width=888) (actual time=0.079..0.082 rows=1 loops=1)

  • Sort Key: "PC0".pxcreatedatetime
  • Sort Method: quicksort Memory: 25kB
3. 0.008 0.064 ↑ 1.0 1 1

Nested Loop (cost=0.55..7.88 rows=1 width=888) (actual time=0.045..0.064 rows=1 loops=1)

4. 0.020 0.020 ↓ 2.0 4 1

Index Scan using attach_ref_from on pc_link_attachment "PC0" (cost=0.28..3.28 rows=2 width=196) (actual time=0.017..0.020 rows=4 loops=1)

  • Index Cond: (((pxlinkedreffrom)::text = 'JPMC-FW-OPTIMA-WORK R-4259'::text) AND ((pxobjclass)::text = 'Link-Attachment'::text))
5. 0.036 0.036 ↓ 0.0 0 4

Index Scan using pc_data_workattach_pk on pc_data_workattach "WA" (cost=0.27..2.29 rows=1 width=692) (actual time=0.009..0.009 rows=0 loops=4)

  • Index Cond: ((pzinskey)::text = ("PC0".pxlinkedrefto)::text)
  • Filter: ((pxobjclass)::text = 'Data-WorkAttach-File'::text)