explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SW4N

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 158.723 ↓ 14.1 141 1

Nested Loop (cost=0.98..74.35 rows=10 width=16) (actual time=20.635..158.723 rows=141 loops=1)

2. 0.013 0.013 ↑ 1.0 1 1

Index Scan using testcases_name_key on testcases (cost=0.41..8.43 rows=1 width=8) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((name)::text = 'ITc_libstorage_get_internal_memory_size_p'::text)
3. 0.045 158.658 ↓ 10.1 141 1

Nested Loop (cost=0.56..65.78 rows=14 width=24) (actual time=20.622..158.658 rows=141 loops=1)

4. 0.033 0.033 ↑ 1.0 1 1

Seq Scan on suites (cost=0.00..4.96 rows=1 width=8) (actual time=0.013..0.033 rows=1 loops=1)

  • Filter: ((name)::text = 'tct-libstorage-native-itc'::text)
  • Rows Removed by Filter: 236
5. 158.580 158.580 ↓ 10.1 141 1

Index Scan using stats_idx1 on stats (cost=0.56..60.68 rows=14 width=28) (actual time=20.607..158.580 rows=141 loops=1)

  • Index Cond: ((suiteid = suites.id) AND (testcase = testcases.id) AND (date < '1509138583001'::bigint))