explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a6H3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 56.058 ↑ 1.0 1 1

Aggregate (cost=9,754.87..9,754.88 rows=1 width=8) (actual time=56.057..56.058 rows=1 loops=1)

2. 56.050 56.050 ↓ 0.0 0 1

Nested Loop (cost=8.12..9,754.86 rows=1 width=8) (actual time=56.050..56.050 rows=0 loops=1)

3. 47.221 47.221 ↓ 8.6 337 1

Nested Loop (cost=7.69..9,450.89 rows=39 width=16) (actual time=0.846..47.221 rows=337 loops=1)

4. 21.379 21.379 ↑ 4.4 882 1

Nested Loop (cost=7.12..1,967.20 rows=3,846 width=16) (actual time=0.565..21.379 rows=882 loops=1)

5. 8.239 8.239 ↓ 2.1 882 1

Bitmap Heap Scan on evs (cost=6.70..606.58 rows=423 width=8) (actual time=0.516..8.239 rows=882 loops=1)

6. 0.421 0.421 ↓ 2.2 912 1

Bitmap Index Scan on evs_company_id_idx (cost=0.00..6.59 rows=423 width=0) (actual time=0.421..0.421 rows=912 loops=1)

7. 12.348 12.348 ↑ 1.0 1 882

Index Scan using comm_comm_ev_id_uidx on comm c_0 (cost=0.42..3.22 rows=1 width=16) (actual time=0.014..0.014 rows=1 loops=882)

8. 22.932 22.932 ↓ 0.0 0 882

Index Scan using idx_comm_fld_name on comm_flds cf_0 (cost=0.56..1.94 rows=1 width=16) (actual time=0.026..0.026 rows=0 loops=882)

9. 8.762 8.762 ↓ 0.0 0 337

Index Scan using idx_comm_values1 on comm_values cv_0 (cost=0.44..7.78 rows=1 width=8) (actual time=0.026..0.026 rows=0 loops=337)