explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OXxT

Settings
# exclusive inclusive rows x rows loops node
1. 132.516 681.130 ↓ 1.0 68,712 1

Nested Loop Left Join (cost=0.99..33,249.22 rows=68,517 width=5,499) (actual time=0.067..681.130 rows=68,712 loops=1)

2. 50.670 342.478 ↓ 1.0 68,712 1

Nested Loop Left Join (cost=0.84..21,581.48 rows=68,517 width=2,842) (actual time=0.054..342.478 rows=68,712 loops=1)

3. 81.943 223.096 ↓ 1.0 68,712 1

Merge Join (cost=0.70..9,913.75 rows=68,517 width=185) (actual time=0.049..223.096 rows=68,712 loops=1)

  • Merge Cond: (t0.id = t1.correspondent_id)
4. 14.865 14.865 ↓ 1.0 8,116 1

Index Scan using swemel_correspondent_pkey on swemel_correspondent t0 (cost=0.28..938.74 rows=8,102 width=16) (actual time=0.020..14.865 rows=8,116 loops=1)

  • Filter: (delete_ts IS NULL)
  • Rows Removed by Filter: 57
5. 126.288 126.288 ↑ 1.0 68,712 1

Index Scan using idx_swemel_correspondent_local_correspondent on swemel_correspondent_local t1 (cost=0.42..8,096.98 rows=69,041 width=169) (actual time=0.013..126.288 rows=68,712 loops=1)

  • Filter: (delete_ts IS NULL)
  • Rows Removed by Filter: 64
6. 68.712 68.712 ↓ 0.0 0 68,712

Index Scan using df_organization_pkey on df_organization t2 (cost=0.14..0.16 rows=1 width=2,673) (actual time=0.000..0.001 rows=0 loops=68,712)

  • Index Cond: (t1.create_in_organization_id = id)
7. 206.136 206.136 ↑ 1.0 1 68,712

Index Scan using df_organization_pkey on df_organization t3 (cost=0.14..0.16 rows=1 width=2,673) (actual time=0.003..0.003 rows=1 loops=68,712)

  • Index Cond: (t1.organization_id = id)
Planning time : 5.047 ms
Execution time : 692.404 ms