explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 27dS

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

Aggregate (cost=12,876.74..12,876.75 rows=1 width=8) (actual time=41.782..41.782 rows=1 loops=1)

2. 41.774 41.774 ↓ 0.0 0 1

Nested Loop (cost=8.00..12,876.73 rows=1 width=8) (actual time=41.774..41.774 rows=0 loops=1)

3. 34.821 34.821 ↓ 8.7 339 1

Nested Loop (cost=7.56..12,572.74 rows=39 width=16) (actual time=0.553..34.821 rows=339 loops=1)

4. 17.872 17.872 ↑ 4.3 885 1

Nested Loop (cost=7.12..1,967.20 rows=3,836 width=16) (actual time=0.369..17.872 rows=885 loops=1)

5. 6.218 6.218 ↓ 2.1 885 1

Bitmap Heap Scan on evs (cost=6.70..606.58 rows=423 width=8) (actual time=0.325..6.218 rows=885 loops=1)

6. 0.226 0.226 ↓ 2.1 907 1

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

7. 11.505 11.505 ↑ 1.0 1 885

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

8. 16.815 16.815 ↓ 0.0 0 885

Index Scan using idx_comm_flds1 on comm_flds cf_0 (cost=0.44..2.75 rows=1 width=16) (actual time=0.018..0.019 rows=0 loops=885)

9. 6.780 6.780 ↓ 0.0 0 339

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