explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bbgN

Settings
# exclusive inclusive rows x rows loops node
1. 1.911 8.731 ↑ 1.6 854 1

Merge Right Join (cost=73.99..177.88 rows=1,388 width=8) (actual time=1.969..8.731 rows=854 loops=1)

  • Merge Cond: (u.id = c.user_add)
2. 1.678 4.263 ↑ 1.6 374 1

Nested Loop Left Join (cost=0.55..712.20 rows=616 width=8) (actual time=0.044..4.263 rows=374 loops=1)

3. 0.715 0.715 ↑ 1.0 374 1

Index Scan using fdc_user_pk on fdc_user u (cost=0.27..453.91 rows=377 width=16) (actual time=0.014..0.715 rows=374 loops=1)

4. 1.870 1.870 ↑ 2.0 1 374

Index Only Scan using fdc_person_root_i on fdc_person per (cost=0.28..0.67 rows=2 width=8) (actual time=0.004..0.005 rows=1 loops=374)

  • Index Cond: (person_root_id = u.person_root_id)
  • Heap Fetches: 353
5. 1.650 2.557 ↓ 1.0 854 1

Sort (cost=61.86..63.98 rows=850 width=16) (actual time=1.815..2.557 rows=854 loops=1)

  • Sort Key: c.user_add
  • Sort Method: quicksort Memory: 65kB
6. 0.907 0.907 ↓ 1.0 854 1

Seq Scan on fdc_ts_trademark c (cost=0.00..20.50 rows=850 width=16) (actual time=0.016..0.907 rows=854 loops=1)

Planning time : 0.750 ms
Execution time : 9.514 ms