explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q67g

Settings
# exclusive inclusive rows x rows loops node
1. 1.258 5.843 ↓ 30.0 30 1

Nested Loop Left Join (cost=2.13..20.68 rows=1 width=91) (actual time=0.727..5.843 rows=30 loops=1)

2. 0.136 4.285 ↓ 30.0 30 1

Nested Loop Left Join (cost=1.85..19.83 rows=1 width=91) (actual time=0.637..4.285 rows=30 loops=1)

3. 1.547 3.909 ↓ 30.0 30 1

Nested Loop Left Join (cost=1.57..19.54 rows=1 width=91) (actual time=0.620..3.909 rows=30 loops=1)

4. 0.139 2.092 ↓ 30.0 30 1

Nested Loop Left Join (cost=1.43..17.62 rows=1 width=74) (actual time=0.465..2.092 rows=30 loops=1)

5. 0.137 1.773 ↓ 30.0 30 1

Nested Loop (cost=1.29..17.47 rows=1 width=74) (actual time=0.389..1.773 rows=30 loops=1)

6. 0.145 1.036 ↓ 30.0 30 1

Nested Loop (cost=0.86..16.90 rows=1 width=58) (actual time=0.311..1.036 rows=30 loops=1)

7. 0.231 0.231 ↓ 30.0 30 1

Index Only Scan using fdc_request_pts_req_i on fdc_request_pts (cost=0.43..8.45 rows=1 width=8) (actual time=0.166..0.231 rows=30 loops=1)

  • Index Cond: (request_id = 16,404,697)
  • Heap Fetches: 30
8. 0.660 0.660 ↑ 1.0 1 30

Index Scan using fdc_pts_ver_pk on fdc_pts_ver v (cost=0.43..8.45 rows=1 width=58) (actual time=0.022..0.022 rows=1 loops=30)

  • Index Cond: (id = fdc_request_pts.pasport_id)
9. 0.600 0.600 ↑ 1.0 1 30

Index Scan using fdc_pts_root_pk on fdc_pts_root r (cost=0.43..0.57 rows=1 width=24) (actual time=0.020..0.020 rows=1 loops=30)

  • Index Cond: (id = v.root_id)
10. 0.180 0.180 ↑ 1.0 1 30

Index Only Scan using fdc_status_pts_pk on fdc_status_pts status (cost=0.14..0.15 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=30)

  • Index Cond: (id = v.status_id)
  • Heap Fetches: 30
11. 0.270 0.270 ↑ 1.0 1 30

Index Scan using fdc_status_pts_translation_vl_i on fdc_status_pts_translation status_translation (cost=0.14..1.76 rows=1 width=33) (actual time=0.009..0.009 rows=1 loops=30)

  • Index Cond: ((status.id = status_id) AND (language_id = lang.get_current_lang_id()))
12. 0.240 0.240 ↑ 1.0 1 30

Index Only Scan using fdc_ts_trademark_pk on fdc_ts_trademark trademark (cost=0.28..0.29 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=30)

  • Index Cond: (id = v.ts_trademark_id)
  • Heap Fetches: 28
13. 0.300 0.300 ↑ 1.0 1 30

Index Scan using fdc_ts_trademark_translation_vl_i on fdc_ts_trademark_translation trademark_translation (cost=0.29..0.84 rows=1 width=16) (actual time=0.010..0.010 rows=1 loops=30)

  • Index Cond: ((trademark.id = trademark_id) AND (language_id = lang.get_current_lang_id()))
Planning time : 12.477 ms
Execution time : 6.102 ms