explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ogCe

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.089 ↑ 1.0 1 1

Result (cost=12.54..12.55 rows=1 width=0) (actual time=0.089..0.089 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.031 0.088 ↑ 1.0 1 1

Nested Loop (cost=8.48..12.54 rows=1 width=0) (actual time=0.088..0.088 rows=1 loops=1)

  • Join Filter: ((ud.doc ->> 'mac_signing_certificate'::text) = sm.user_id)
4. 0.005 0.052 ↑ 1.0 1 1

Merge Join (cost=8.33..9.93 rows=1 width=961) (actual time=0.052..0.052 rows=1 loops=1)

  • Merge Cond: (((ud.doc ->> 'mac_signing_certificate'::text)) = (sh.doc ->> 'personal_space_of'::text))
5. 0.013 0.045 ↑ 1.0 1 1

Sort (cost=8.19..8.19 rows=1 width=18) (actual time=0.045..0.045 rows=1 loops=1)

  • Sort Key: ((ud.doc ->> 'mac_signing_certificate'::text))
  • Sort Method: quicksort Memory: 25kB
6. 0.032 0.032 ↑ 1.0 1 1

Index Scan using user_data_email_idx on userdata ud (cost=0.15..8.18 rows=1 width=18) (actual time=0.031..0.032 rows=1 loops=1)

  • Index Cond: (email = 'nuage@ercom.fr'::text)
  • Filter: ('deleted'::text <> ALL (flags))
7. 0.002 0.002 ↑ 20.0 1 1

Index Scan using spacehistory_personal_space_of_idx on spacehistory sh (cost=0.14..10.49 rows=20 width=943) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: ((doc ->> 'personal_space_of'::text) IS NOT NULL)
8. 0.005 0.005 ↑ 2.0 1 1

Index Only Scan using spacemember_user_id_idx on spacemember sm (cost=0.15..2.58 rows=2 width=44) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (user_id = (sh.doc ->> 'personal_space_of'::text))
  • Heap Fetches: 1
Planning time : 0.898 ms
Execution time : 0.175 ms