explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Zf4

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1.413 ↓ 2.5 10 1

Limit (cost=1,982.98..1,982.99 rows=4 width=77) (actual time=1.408..1.413 rows=10 loops=1)

2. 0.019 1.408 ↓ 2.5 10 1

Sort (cost=1,982.98..1,982.99 rows=4 width=77) (actual time=1.406..1.408 rows=10 loops=1)

  • Sort Key: (max(rl.duration)) DESC
  • Sort Method: top-N heapsort Memory: 28kB
3. 0.072 1.389 ↓ 10.2 41 1

GroupAggregate (cost=1,982.84..1,982.94 rows=4 width=77) (actual time=1.321..1.389 rows=41 loops=1)

  • Group Key: rl.name
4. 0.117 1.317 ↓ 37.5 150 1

Sort (cost=1,982.84..1,982.85 rows=4 width=61) (actual time=1.309..1.317 rows=150 loops=1)

  • Sort Key: rl.name
  • Sort Method: quicksort Memory: 47kB
5. 0.029 1.200 ↓ 37.5 150 1

Nested Loop (cost=4.49..1,982.80 rows=4 width=61) (actual time=0.988..1.200 rows=150 loops=1)

6. 0.013 1.066 ↓ 7.0 7 1

Nested Loop (cost=4.07..1,973.70 rows=1 width=4) (actual time=0.972..1.066 rows=7 loops=1)

7. 0.013 1.018 ↓ 7.0 7 1

Nested Loop (cost=4.07..1,972.12 rows=1 width=8) (actual time=0.961..1.018 rows=7 loops=1)

8. 0.009 0.963 ↓ 7.0 7 1

Nested Loop (cost=4.07..1,970.64 rows=1 width=8) (actual time=0.946..0.963 rows=7 loops=1)

9. 0.564 0.926 ↑ 23.0 4 1

Hash Join (cost=3.78..75.82 rows=92 width=8) (actual time=0.901..0.926 rows=4 loops=1)

  • Hash Cond: (tests.test_suite_id = test_suites.id)
10. 0.326 0.326 ↑ 1.0 2,522 1

Seq Scan on tests (cost=0.00..65.22 rows=2,522 width=8) (actual time=0.010..0.326 rows=2,522 loops=1)

11. 0.005 0.036 ↑ 1.0 5 1

Hash (cost=3.71..3.71 rows=5 width=8) (actual time=0.036..0.036 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.031 0.031 ↑ 1.0 5 1

Seq Scan on test_suites (cost=0.00..3.71 rows=5 width=8) (actual time=0.008..0.031 rows=5 loops=1)

  • Filter: (organization_id = 36)
  • Rows Removed by Filter: 132
13. 0.028 0.028 ↓ 2.0 2 4

Index Scan using tasks_test_id on tasks (cost=0.29..20.59 rows=1 width=8) (actual time=0.006..0.007 rows=2 loops=4)

  • Index Cond: (test_id = tests.id)
  • Filter: ((updated_at >= '2020-03-11 00:00:00+00'::timestamp with time zone) AND (updated_at <= '2020-03-18 22:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 1
14. 0.042 0.042 ↑ 1.0 1 7

Seq Scan on organizations (cost=0.00..1.48 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=7)

  • Filter: (id = 36)
  • Rows Removed by Filter: 37
15. 0.035 0.035 ↑ 1.0 1 7

Seq Scan on organization_members (cost=0.00..1.57 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=7)

  • Filter: ((organization_id = 36) AND (user_id = 35))
  • Rows Removed by Filter: 37
16. 0.105 0.105 ↓ 1.1 21 7

Index Scan using request_logs_task_id on request_logs rl (cost=0.42..8.91 rows=19 width=65) (actual time=0.005..0.015 rows=21 loops=7)

  • Index Cond: (task_id = tasks.id)
  • Filter: ((entry_type)::text <> 'navigation'::text)
  • Rows Removed by Filter: 1
Planning time : 1.664 ms
Execution time : 1.538 ms