explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QIfPS

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 137.522 ↓ 0.0 0 1

Nested Loop Left Join (cost=87.47..306.18 rows=1 width=170) (actual time=137.521..137.522 rows=0 loops=1)

  • Filter: ((route.route_type = 3) OR (upper((plan.trip_id)::text) = upper((source_activities.trip_id)::text)))
  • Buffers: shared hit=18 read=63
2. 0.001 137.521 ↓ 0.0 0 1

Nested Loop (cost=87.19..305.76 rows=1 width=180) (actual time=137.521..137.521 rows=0 loops=1)

  • Join Filter: (upper((source_activities.activity_id)::text) = upper((activity.activity_id)::text))
  • Buffers: shared hit=18 read=63
3. 0.001 137.520 ↓ 0.0 0 1

Nested Loop (cost=86.90..305.38 rows=1 width=180) (actual time=137.520..137.520 rows=0 loops=1)

  • Join Filter: (upper((source_activities.stop_id)::text) = upper((stop.stop_id)::text))
  • Buffers: shared hit=18 read=63
4. 0.032 137.519 ↓ 0.0 0 1

Nested Loop (cost=86.61..303.95 rows=1 width=172) (actual time=137.519..137.519 rows=0 loops=1)

  • Join Filter: ((source_activities.route_type = route.route_type) AND (upper((source_activities.route_id)::text) = upper((route.route_id)::text)))
  • Rows Removed by Join Filter: 8
  • Buffers: shared hit=18 read=63
5. 0.175 136.293 ↑ 2.0 1 1

Hash Join (cost=7.60..11.29 rows=2 width=170) (actual time=136.290..136.293 rows=1 loops=1)

  • Hash Cond: (upper((source_activities.organization_id)::text) = upper((organization.display_id)::text))
  • Buffers: shared hit=17 read=4
6. 0.027 0.027 ↑ 100.0 1 1

Function Scan on unnest source_activities (cost=0.00..3.00 rows=100 width=162) (actual time=0.026..0.027 rows=1 loops=1)

7. 0.199 136.091 ↑ 1.0 3 1

Hash (cost=7.50..7.50 rows=3 width=16) (actual time=136.091..136.091 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1 read=4
8. 0.063 135.892 ↑ 1.0 3 1

Bitmap Heap Scan on common_entities_organization organization (cost=2.30..7.50 rows=3 width=16) (actual time=135.842..135.892 rows=3 loops=1)

  • Recheck Cond: ((company_identity)::text = 'c51e2b44-b7db-49a6-8c3e-a54fb6cc0a11'::text)
  • Heap Blocks: exact=3
  • Buffers: shared hit=1 read=4
9. 135.829 135.829 ↑ 1.0 3 1

Bitmap Index Scan on ix_common_entities_organization_04 (cost=0.00..2.29 rows=3 width=0) (actual time=135.829..135.829 rows=3 loops=1)

  • Index Cond: ((company_identity)::text = 'c51e2b44-b7db-49a6-8c3e-a54fb6cc0a11'::text)
  • Buffers: shared read=2
10. 0.013 1.194 ↑ 20.8 8 1

Bitmap Heap Scan on trip_route route (cost=79.01..139.69 rows=166 width=23) (actual time=1.191..1.194 rows=8 loops=1)

  • Recheck Cond: ((organization_sid = organization.sid) AND (NOT mark_for_delete))
  • Heap Blocks: exact=1
  • Buffers: shared hit=1 read=59
11. 1.181 1.181 ↑ 9.8 17 1

Bitmap Index Scan on ix_trip_route_07 (cost=0.00..78.97 rows=166 width=0) (actual time=1.180..1.181 rows=17 loops=1)

  • Index Cond: (organization_sid = organization.sid)
  • Buffers: shared read=59
12. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_trip_route_stop_01 on trip_route_stop stop (cost=0.29..1.05 rows=10 width=18) (never executed)

  • Index Cond: (route_sid = route.route_sid)
  • Filter: (NOT mark_for_delete)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_trip_route_activity_02 on trip_route_activity activity (cost=0.29..0.35 rows=1 width=26) (never executed)

  • Index Cond: (stop_sid = stop.route_stop_sid)
  • Filter: (NOT mark_for_delete)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_trip_trip_plan_03 on trip_trip_plan plan (cost=0.28..0.37 rows=1 width=18) (never executed)

  • Index Cond: (route_sid = route.route_sid)
Planning time : 12.026 ms
Execution time : 137.892 ms