explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k8Eg

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 227,230.077 ↑ 1.0 21 1

Limit (cost=0.99..14,486.73 rows=21 width=566) (actual time=227,225.393..227,230.077 rows=21 loops=1)

2. 21,608.056 227,230.057 ↑ 21,757.3 21 1

Merge Join (cost=0.99..315,171,027.15 rows=456,904 width=566) (actual time=227,225.390..227,230.057 rows=21 loops=1)

  • Merge Cond: (tr.id = t.test_run_id)
3. 24,098.637 24,098.637 ↑ 1,140.2 5 1

Index Scan using core_testrun_pkey on core_testrun tr (cost=0.43..3,762,107.66 rows=5,701 width=4) (actual time=24,094.006..24,098.637 rows=5 loops=1)

  • Filter: (build_id = 11,188)
  • Rows Removed by Filter: 1,060,269
4. 181,523.364 181,523.364 ↑ 1.1 86,290,058 1

Index Scan using core_test_ba18909e on core_test t (cost=0.57..311,175,864.25 rows=91,388,779 width=566) (actual time=3.694..181,523.364 rows=86,290,058 loops=1)

Planning time : 0.195 ms
Execution time : 227,230.124 ms