explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TE31

Settings
# exclusive inclusive rows x rows loops node
1. 0.672 0.672 ↑ 1.0 7,648 1

Hash Join (cost=299748.27..6226382.31 rows=2073817 width=72) (actual time=2608.422..357391.289 rows=133299 loops=1)Hash Cond: (xcap.application_id = app_is_suite.appid)-> Merge Right Join (cost=299534.19..489471.95 rows=2073817 width=56) (actual time=2423.529..7941.625 rows=2073817 loops=1)Merge Cond: ((app_is_terminal_by_client_oto.appid = xcap.application_id) AND (app_is_terminal_by_client_oto.client_id = xcap.client_id))-> Index Scan using app_is_terminal_app_client_id_idx on app_is_terminal_by_client_oto (cost=0.43..140318.03 rows=4101672 width=21) (actual time=0.014..3598.640 rows=4093643 loops=1)-> Materialize (cost=299096.22..309465.30 rows=2073817 width=55) (actual time=2423.478..3279.667 rows=2073817 loops=1)-> Sort (cost=299096.22..304280.76 rows=2073817 width=55) (actual time=2423.473..2988.407 rows=2073817 loops=1)Sort Key: xcap.application_id, xcap.client_idSort Method: external merge Disk: 82336kB-> Seq Scan on x_client_app_parent xcap (cost=0.00..39994.17 rows=2073817 width=55) (actual time=0.017..240.642 rows=2073817 loops=1)-> Hash (cost=118.48..118.48 rows=7648 width=16) (actual time=181.152..181.152 rows=7648 loops=1)Buckets: 8192 Batches: 1 Memory Usage: 423kB-> Seq Scan on app_ids_issuite_oto app_is_suite (cost=0.00..118.48 rows=7,648 width=16) (actual time=0.017..0.672 rows=7,648 loops=1)

Execution time : 357,448.963 ms