explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wKKa

Settings
# exclusive inclusive rows x rows loops node
1. 0.131 0.995 ↑ 47.0 7 1

Hash Left Join (cost=56.46..150.51 rows=329 width=664) (actual time=0.713..0.995 rows=7 loops=1)

  • Hash Cond: (media_item.media_type_id = media_type.id)
2. 0.129 0.591 ↑ 47.0 7 1

Hash Join (cost=35.89..129.06 rows=329 width=552) (actual time=0.412..0.591 rows=7 loops=1)

  • Hash Cond: (collection_media_relation.media_item_id = media_item.id)
3. 0.093 0.093 ↑ 41.3 7 1

Seq Scan on collection_media_relation (cost=0.00..88.81 rows=289 width=64) (actual time=0.019..0.093 rows=7 loops=1)

  • Filter: (collection_id = ANY ('{4322299a-9b4f-45f5-8f91-54b661e90003,1b941000-8b8f-4dac-bebc-d300463d804a,4e969d11-c367-4d1a-a277-132007295e8e,5942632a-5b18-48a1-8e6f-8c6e2ad8576c,1701ff73-b38b-4d9b-b518-7c9bf1408476,17612c4d-5d58-4c83-b877-c459cc9edc0a,2304fc98-4f4c-49d6-a1c0-25f1ad87cd43,eda8923b-8ef3-489d-b546-a48390743edd,a8091713-799d-4ab5-9cbe-8b550d65d251,eb7ef141-67c9-4df4-b3aa-d4e03b460257,583b016c-e310-4386-a568-23c60f65ca61,8c57cd7f-3cf0-4e70-bfd7-10e65232b506,13a32474-2d5c-44a7-ab46-89e762713787,91e5eb6e-fdfb-460c-b764-c45f486f441c,5048ad49-db5c-4fb2-b820-7c61e6003f95,94d9fb30-00cd-404e-a47a-7f9082a856f4,8a9da9e8-f19d-4f2e-a7e5-1a7f6805ee46,16fadc10-e523-4b2a-88ca-aa3cdeab076e,ac2db8da-4c56-4e6a-93ce-11d72d996a7d,6d877fb5-5333-4456-a5ba-3c06c68e2629,910456b4-8eca-4df3-b63c-22d9b060f3a3,87c5950a-51c0-4a5c-bc7f-58a0214b8e24,71594454-9030-4fa8-ad6c-9f67e2a46e08,446ea951-19f6-4cb3-b135-c5360f4aa300,e5926ce7-89e2-4ac8-b597-20e04dfb1fa0,006c7362-c1de-47aa-a638-ae0678feebe6,55daf8fa-16b0-4316-96b8-cc11fb42c660,9f6231ff-196b-46a7-b167-5e85f43c7c38,be6eb6b3-0c0a-4b30-b61e-2592d5a1b5e9,c3891445-4831-48e0-8e80-609b6ec51507,02ea23b0-7a4f-4525-be85-272c7034bdef,4e7758ca-da51-4001-bc46-f4078051901e,647f95ec-9777-48e3-8ac1-58bdbe9089fa,b04d62c8-b06b-4fb6-8cee-7ecc33eaa64f,4822695d-90ce-4781-96c0-1f825f1d1452,7fec2943-0718-41e8-af7f-5a4871c90a13,d627c0ed-bbb1-4ff2-a49f-d03ad0aae1f0,4e1a9203-c259-4281-96e7-24362c707dd5,2f7e1e5c-af04-4177-9834-da1dd3fed62d,180c2505-90d7-4626-9487-f8b906b251db,e3ede5c8-ddfd-4d7d-8674-61c7092f7fa7,b5292219-07f4-4f46-894a-9bee395e4f44,351e3713-f173-4e11-9f0c-0f76b4325f1b,719c62b7-0da8-4a0d-ac1a-374f23887cbe,b46be6a8-c53a-4317-b9a6-272a81254977,8c94ed04-4c95-435c-8b8d-7eb3fc56d4a0,afa844a5-ae53-422d-a10c-4e372cc642a0,ea0b5934-bdb8-48e3-9c9b-275557529178,5a9840da-c4a0-4a2d-9c5e-061f07b1720f,0fd067ed-8e6d-4527-b72f-48abb61a80b0,93aa5553-a42d-4d8e-b565-e9393835a3c8,1b55c0b6-07f3-4f21-8ea0-034818bbfb6c,0645ece5-4106-43a2-ab86-ba10e1eeac73,d4d91aac-0bce-410d-8e8c-14f259c7716e,6eb20eed-0a9c-4617-8ce6-9641c9f9af6c,44d036c6-2381-42b6-8684-2a96f7c9725e,bf235e06-bc06-4031-b4ad-4f6670ec5055,e1f571c4-3b3e-44b0-b99b-e3c02699ab5d,060abd58-5ec6-4f4f-a29d-43227a7698dc,5889cf55-1e07-4365-a32f-9f840974242d,bf63fc66-72ac-4c11-8713-cbc72425a037,ae228ded-d0b2-4a9b-9f00-34e204281901,0a25fced-d593-45f8-8ae8-eda2c54b5dc4,56709c04-a3fe-498d-96e6-541a1fe17597,03fe06a9-c536-4e29-bb4e-cf21f1deb4f1,f39e546b-6c96-4259-a5d5-c04840dfb7a2,c9b9fb1e-bcc6-4e44-ad6d-a1578541feb8,bc4a6b51-5a98-44a5-ae04-2986c9cb2f4c,c0537fd5-89de-48b3-b5e0-78488d86a202,2b3c23f5-f48b-498e-9e05-60fb04f2b739,e700fca1-1e34-4f38-bd70-946c71763cc8,b078dd3e-1670-479a-a44f-3b71ba1c8a27,289a51e9-cb0e-4dbf-bd15-3c44bfb813d5,8613f951-7b64-442d-8f09-54b963ca1123,a655bfc6-7bd7-4eeb-bb59-4e1d7e816cd8,5871379b-63eb-40b7-8787-30b51b522ec0,ed53fb96-a0ad-4bb0-9dc9-9f62c9eeb767,fbbf5584-45a9-4237-904b-1efb3a9bf62f,ae01a82f-461a-4f6f-b855-c17efeb50f29,f81042fa-9e36-42dc-8349-2293390e1d91,3a2243a4-dd4c-4e7a-8ab9-1ef88a63f087,366a26f6-9b35-44a0-a404-afe91791f708,4c62a4a8-b2bb-41cb-8583-31d35c3ba5ca,6e25e66c-576b-447d-be69-2d3ab33f62e5,06f9e73c-0b3d-444a-a107-8e26fe007cb3,4eefd1d9-ab0a-44e2-aa74-a60ef0cc756b,b3941f12-0991-4e5d-8dce-c703755d64d5,ccd2c1ff-2a3e-4c69-89f1-2a5169b30154,29fe7eeb-9d80-4e8e-af90-4950b44ecb7f}'::text[]))
4. 0.064 0.369 ↑ 42.1 7 1

Hash (cost=32.20..32.20 rows=295 width=520) (actual time=0.362..0.369 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
5. 0.088 0.305 ↑ 42.1 7 1

Hash Right Join (cost=18.40..32.20 rows=295 width=520) (actual time=0.253..0.305 rows=7 loops=1)

  • Hash Cond: (video_synchronization.media_item_id = media_item.id)
6. 0.032 0.032 ↓ 0.0 0 1

Seq Scan on video_synchronization (cost=0.00..13.00 rows=300 width=240) (actual time=0.025..0.032 rows=0 loops=1)

7. 0.093 0.185 ↑ 36.6 7 1

Hash (cost=15.20..15.20 rows=256 width=280) (actual time=0.177..0.185 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
8. 0.092 0.092 ↑ 36.6 7 1

Seq Scan on media_item (cost=0.00..15.20 rows=256 width=280) (actual time=0.017..0.092 rows=7 loops=1)

  • Filter: ((name ~* '^.*.*$'::text) OR (title ~* '^.*.*$'::text) OR (keywords ~* '^.*.*$'::text) OR (description ~* '^.*.*$'::text))
9. 0.148 0.273 ↑ 31.3 15 1

Hash (cost=14.70..14.70 rows=470 width=144) (actual time=0.267..0.273 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
10. 0.125 0.125 ↑ 31.3 15 1

Seq Scan on media_type (cost=0.00..14.70 rows=470 width=144) (actual time=0.011..0.125 rows=15 loops=1)

Planning time : 0.426 ms
Execution time : 1.824 ms