explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gDq8

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 4.784 ↑ 1.0 10 1

Limit (cost=0.42..79.53 rows=10 width=17) (actual time=4.756..4.784 rows=10 loops=1)

2. 0.011 4.777 ↑ 2,837,878.4 10 1

Nested Loop (cost=0.42..224,489,311.05 rows=28,378,784 width=17) (actual time=4.754..4.777 rows=10 loops=1)

3. 4.746 4.746 ↑ 2,837,878.4 10 1

Seq Scan on terminal_has_apps_versions_installed tha (cost=0.00..5,616,040.84 rows=28,378,784 width=4) (actual time=4.743..4.746 rows=10 loops=1)

4. 0.020 0.020 ↑ 1.0 1 10

Index Scan using terminals_pkey on terminals t (cost=0.42..7.71 rows=1 width=21) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: (id = tha.terminal_id)
Planning time : 3.760 ms